Sample SP error 
Author Message
 Sample SP error

Server - DB2 UDB 6.1 on NT w SP4
Client - DB2 UDB 6.1 on NT w SP3
JDK version 1.2.1

Follow carefully the instructions but still getting the error.  Can anyone
help me, please?

Thanks in advance.

----------------------------------------------------------------------------
---

Java Stored Procedure Sample

  Registering Java stored procedure SAMPLESTOREDPROC
     as DB2Stp!salaryModification
     in not fenced mode

  Calling stored procedure: SAMPLESTOREDPROC
COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL4301N  Java
inte
rpreter startup or communication failed, reason code "2".  SQLSTATE=58004

        at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Compile
d Code)
        at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep
tionGenerator.java:370)
        at
COM.ibm.db2.jdbc.app.DB2CallableStatement.execute2(DB2CallableStateme
nt.java:926)
        at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatemen
t.java:2128)
        at DB2SpCli.callStoredProc(DB2SpCli.java:159)
        at DB2SpCli.main(DB2SpCli.java:235)



Fri, 23 Aug 2002 03:00:00 GMT
 Sample SP error

What is the error?

Quote:
> Server - DB2 UDB 6.1 on NT w SP4
> Client - DB2 UDB 6.1 on NT w SP3
> JDK version 1.2.1

> Follow carefully the instructions but still getting the error.  Can anyone
> help me, please?

> Thanks in advance.

> --------------------------------------------------------------------------
--
> ---

> Java Stored Procedure Sample

>   Registering Java stored procedure SAMPLESTOREDPROC
>      as DB2Stp!salaryModification
>      in not fenced mode

>   Calling stored procedure: SAMPLESTOREDPROC
> COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL4301N
Java
> inte
> rpreter startup or communication failed, reason code "2".  SQLSTATE=58004

>         at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Compile
> d Code)
>         at
> COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExcep
> tionGenerator.java:370)
>         at
> COM.ibm.db2.jdbc.app.DB2CallableStatement.execute2(DB2CallableStateme
> nt.java:926)
>         at
> COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatemen
> t.java:2128)
>         at DB2SpCli.callStoredProc(DB2SpCli.java:159)
>         at DB2SpCli.main(DB2SpCli.java:235)



Tue, 27 Aug 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error 18481 when calling remote SP from local SP

2. passing params in an sp returns error saying the sp has no params

3. SP:ExecContextHit,SP:CacheMiss,SP:CacheInsert

4. Sample ASP connection to northwind SQL sample database.

5. Sample data for the sample DM model

6. New Client/Server Samples added to the samples collection

7. SP: Howto return own errors against sql errors

8. SP: Howto return own errors against sql errors

9. error#-2147217833 truncation error for SP parameter

10. error 28559 when testing sdapp_ssce samples

11. Error 80040154 ? IN SAMPLE

12. Error : 0xC0000005 : Access Violation in Sample


 
Powered by phpBB® Forum Software