SQL1131N with INSTALL_JAR on DB2 7.2 FP11

[gaetan]

Hi everybody,

I have several stored procedure developped in Java that ran fine when
I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11,
I'm not able to call any of my stored procedure or call an
install_JAR, replace_jar or whatever.

I always get the following error :
SQL1131N DARI (Stored Procedure) process has been terminated
abnormally. SQLSTATE=38503
and a Dr Watson is raised.

I have read many post on this forum for a similar problem but any of
the solution suggested have worked.
In fact at the beginning I got the error SQL4304N with errorCode4, so
I have installed JDK1.2.1 and I have updated my DBM CFG like this :

db2set DB2_USE_JDK12=1
db2 update dbm cfg using JDK11_PATH c:\jdk1.2.1
db2stop
db2start

and now i got the error SQL1131N with Dr Watson...

does someone have the solution?
I have set my classpath, path and java_home to refers to c:\jdk1.2.1
first but I have several jdk installed on my computer...

Thanks for your help

[Sean McKeough]

What's the build date of the JDK (java -fullversion)? A good first step
would be to make sure you have the most recent.

gaetan wrote:

Hi everybody,

I have several stored procedure developped in Java that ran fine when
I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11,
I'm not able to call any of my stored procedure or call an
install_JAR, replace_jar or whatever.

I always get the following error :
SQL1131N DARI (Stored Procedure) process has been terminated
abnormally. SQLSTATE=38503
and a Dr Watson is raised.

I have read many post on this forum for a similar problem but any of
the solution suggested have worked.
In fact at the beginning I got the error SQL4304N with errorCode4, so
I have installed JDK1.2.1 and I have updated my DBM CFG like this :

db2set DB2_USE_JDK12=1
db2 update dbm cfg using JDK11_PATH c:\jdk1.2.1
db2stop
db2start

and now i got the error SQL1131N with Dr Watson...

does someone have the solution?
I have set my classpath, path and java_home to refers to c:\jdk1.2.1
first but I have several jdk installed on my computer...

Thanks for your help

[Jean-Marc Blaise]

I suggest not to install multiple JDK 's versions on the same computer. It's
the best way to loose control of the situation.

You should keep using the JDK installed by IBM in the SQLLIB directory. The
SQL4304N with errorCode4 suggested a problem with your classpath. Has it
been corrupted ?

Hth,

Jean-Marc

"gaetan" <ga******@hotma il.com> a écrit dans le message de
news:7b******** *************** ***@posting.goo gle.com...

Hi everybody,

I have several stored procedure developped in Java that ran fine when
I was in DB2 7.2 FP6 (on Windows) but since I have passed the FP11,
I'm not able to call any of my stored procedure or call an
install_JAR, replace_jar or whatever.

I always get the following error :
SQL1131N DARI (Stored Procedure) process has been terminated
abnormally. SQLSTATE=38503
and a Dr Watson is raised.

I have read many post on this forum for a similar problem but any of
the solution suggested have worked.
In fact at the beginning I got the error SQL4304N with errorCode4, so
I have installed JDK1.2.1 and I have updated my DBM CFG like this :

db2set DB2_USE_JDK12=1
db2 update dbm cfg using JDK11_PATH c:\jdk1.2.1
db2stop
db2start

and now i got the error SQL1131N with Dr Watson...

does someone have the solution?
I have set my classpath, path and java_home to refers to c:\jdk1.2.1
first but I have several jdk installed on my computer...

Thanks for your help

[gaetan]

Hi,

Thanks for your replies. That's right that i shouldn't have multiple
JDK installed on my computer but it was working fine with FP6.
Moreover, in fixpak 11, IBM has removed is jdk12 under
SQLLIB\java...s o I have installed this version : java full version
"JDK-1.2.1_004"
Because as far as i know this is the last release supported by DB2.

In fact, I have insulated a little bit more the problem. I seems that
it comes from the db2java.zip used with usejdbc2.bat because if I go
back to usejdb1, I can call some stored procedure successfully but not
the ones that return a ResultSet...

any idea?

Thanks a lot for your help

[Sean McKeough]

A 1.2.1 jdk is very old...you should move up to the most recent 1.2.2
jdk you can find.

I forgot that some jdks do not show the date of the build on
fullversion...t ry 'java -version' you should see something like:

"Classic VM (J2RE 1.2.2 IBM build ca122-20001206a (JIT enabled: jitc))"

The date is December of 2000...I think that was the last jvm patch put
out on 1.2.2.

gaetan wrote:

Hi,

Thanks for your replies. That's right that i shouldn't have multiple
JDK installed on my computer but it was working fine with FP6.
Moreover, in fixpak 11, IBM has removed is jdk12 under
SQLLIB\java...s o I have installed this version : java full version
"JDK-1.2.1_004"
Because as far as i know this is the last release supported by DB2.

In fact, I have insulated a little bit more the problem. I seems that
it comes from the db2java.zip used with usejdbc2.bat because if I go
back to usejdb1, I can call some stored procedure successfully but not
the ones that return a ResultSet...

any idea?

Thanks a lot for your help

[gaetan]

Hi,

Thanks for your help.

In fact, i use the jdk build by sun (i cannot find where to download
the jdk build by ibm as far as the removed it with the Fixpak 11).

So java -version returns the information below:
java version "1.2.2"
Classic VM (build JDK-1.2.2_017, native threads, symcjit)

With that version, i'm not able to call stored procedures which return
a ResultSet...

thanks

[Sean McKeough]

Ok, but you're getting further now. :-) What's the error returned when
you try to call an sp that returns a result set?

gaetan wrote:

Hi,

Thanks for your help.

In fact, i use the jdk build by sun (i cannot find where to download
the jdk build by ibm as far as the removed it with the Fixpak 11).

So java -version returns the information below:
java version "1.2.2"
Classic VM (build JDK-1.2.2_017, native threads, symcjit)

With that version, i'm not able to call stored procedures which return
a ResultSet...

thanks