Java stored procedure error ....

[Raquel]

Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP.
I am new to stored procedures.

The stored procedure code I am using is at:
https://www6.software.ibm.com/dw/edu...b2spdc/sp.java

I was able to successfully 'build' the stored procedure that I created
using Development Center, however, at run time it is showing the
following error:

A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL4302N
Java stored procedure or user-defined function
"DB2ADMIN.CHECKRETAILERCREDIT", specific name "SQL040608143836354"
aborted with an exception "". SQLSTATE=38501

Can someone let me know what this error is or is there any way we can
start a trace or something similar in Java to find out more details
about this error.

TIA
Raquel.

[Sean McKeough]

Probably a cranky JVM...you can see the the exception in your
db2diag.log file (in sqllib\<instancename>). If that doesn't explain it,
post what jvm you're jdk_path is pointing to (maker, and build date).

Raquel wrote:

Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP.
I am new to stored procedures.

The stored procedure code I am using is at:
https://www6.software.ibm.com/dw/edu...b2spdc/sp.java

I was able to successfully 'build' the stored procedure that I created
using Development Center, however, at run time it is showing the
following error:

A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL4302N
Java stored procedure or user-defined function
"DB2ADMIN.CHECKRETAILERCREDIT", specific name "SQL040608143836354"
aborted with an exception "". SQLSTATE=38501

Can someone let me know what this error is or is there any way we can
start a trace or something similar in Java to find out more details
about this error.

TIA
Raquel.

[richardshen]

ra****************@yahoo.com (Raquel) wrote in message news:<9a*************************@posting.google.c om>...

Trying to use the "DB2 Development Center" on UDB V8 on my Windows XP.
I am new to stored procedures.

The stored procedure code I am using is at:
https://www6.software.ibm.com/dw/edu...b2spdc/sp.java

I was able to successfully 'build' the stored procedure that I created
using Development Center, however, at run time it is showing the
following error:

A database manager error occurred.[IBM][CLI Driver][DB2/NT] SQL4302N
Java stored procedure or user-defined function
"DB2ADMIN.CHECKRETAILERCREDIT", specific name "SQL040608143836354"
aborted with an exception "". SQLSTATE=38501

Can someone let me know what this error is or is there any way we can
start a trace or something similar in Java to find out more details
about this error.

TIA
Raquel.

try a simple one first, to make sure your DB2 Server is ready for J-SP.
Then test with the sampel from IBM.
Looks like the code aborted itself.

[Raquel]

I downloaded UDB PE V8 from IBM and I guess JDK and JVM get downloaded
along with it. By the way, how do I find WHAT JVM is being used
(maker, build etc.); please pardon my ignorance in this regard but I
am kinda new to all this.

Following is the output from db2diag.log:

/Output-start/

2004-06-09-09.48.39.030000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0x0012F2EC : 0x00E9D060 `...

2004-06-09-09.48.39.186000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback
has been
written to the db2diag.log.

2004-06-09-09.48.39.186001 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejLogException Probe:10

java.lang.NullPointerException
at CheckRetailerCredit.checkRetailerCredit(CheckRetai lerCredit.java:42)

0x0012F13C : 0x00000000 ....

2004-06-09-09.48.39.201000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0x0012F3F8 : 0xFFFFEF32 2...

/Output-end/

Guess, it can be surmised that it is a NullPointerException. Any ideas
why it could be so?

TIA
Raquel.

[Raquel]

ok, looking more closely at the Stored procedure code in
https://www6.software.ibm.com/dw/edu...b2spdc/sp.java , it has
the following piece of code:

while (rs1.next())
{.....}

How is rs1 being populated?? I don't see it in the code. Should there
not have been something along these lines in the code:

rs1 = stmt.getResultSet();

Is the above piece of code missing and is this the reason why the code
is throwing a NullPointerException?

TIA
Raquel.

[Sean McKeough]

Looks like there's a bug in the sample class you're running. The
exception give you the line that failed (42).

Raquel wrote:

I downloaded UDB PE V8 from IBM and I guess JDK and JVM get downloaded
along with it. By the way, how do I find WHAT JVM is being used
(maker, build etc.); please pardon my ignorance in this regard but I
am kinda new to all this.

Following is the output from db2diag.log:

/Output-start/

2004-06-09-09.48.39.030000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315

Exception thrown during routine invocation:

0x0012F2EC : 0x00E9D060 `...

2004-06-09-09.48.39.186000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejLogException Probe:10

ADM10000W A Java exception has been caught. The Java stack traceback
has been
written to the db2diag.log.

2004-06-09-09.48.39.186001 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
BSU Java support sqlejLogException Probe:10

java.lang.NullPointerException
at CheckRetailerCredit.checkRetailerCredit(CheckRetai lerCredit.java:42)

0x0012F13C : 0x00000000 ....

2004-06-09-09.48.39.201000 Instance:DB2 Node:000
PID:2512(db2fmp.exe) TID:1884 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30

Error from DB2ER CallUDF. RC:

0x0012F3F8 : 0xFFFFEF32 2...

/Output-end/

Guess, it can be surmised that it is a NullPointerException. Any ideas
why it could be so?

TIA
Raquel.