SEO

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.

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.

raquel_rodriguezus@yahoo.com (Raquel) wrote in message news:<9a73b58d.0406080259.3f44ab3@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.

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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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.

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.

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 InstanceB2 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 InstanceB2 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 InstanceB2 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 InstanceB2 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.