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 6 2420
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
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******@hotmail.com> a écrit dans le message de
news:7b**************************@posting.google.c om... 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
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...so 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
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...try '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...so 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Reddin |
last post by:
Hi,
(V8.1 FP2)
Trying to run SQLJ.INSTALL_JAR, we get the following error
SQL1131N DARI (Stored Procedure) process has been terminated abnormally.
SQLSTATE=38503
Not sure why this has...
|
by: N.V.Dev |
last post by:
Hi,
I am trying to use the db2load API using C. During run-time below is
the error message thrown
call utils.load_table('util.temp')
SQL1131N DARI (Stored Procedure) process has been...
|
by: Jack |
last post by:
I am trying to get javamail running with DB2 and am running into a
problem with the sqlj.install_jar. When I go to install the jar, I
get a SQL1131 error message which is unhelpful. This is a...
|
by: dromuss via DBMonster.com |
last post by:
I have a problem registering Stored Procedures.
I tried diferent stored procedure and non of them work.
Not even an empty stored procedure like the following:
CREATE PROCEDURE DB2INST1.PRUEBA...
|
by: Michel Esber |
last post by:
Hello,
DB2 V7 FP 13 running on Linux.
We have developed a C++ shared library that will be called by a db2
stored procedure. Every time my developers generate a new .so shared
library, I copy...
|
by: annhere |
last post by:
Hi we have a certain SQL script. From that script we have calls like:
DROP FUNCTION A@
call sqlj.remove_jar( 'AXML')@
CALL SQLJ.REFRESH_CLASSES()@
call sqlj.install_jar( 'file:C:\AXML.jar',...
|
by: tol7481 |
last post by:
Hi,
I'm trying to deploy a Java stored procedure on DB2 V8 on a Linux box,
but I have some problems.
I've added to the classpath the following JARs
sqllib/java/db2java.zip...
|
by: ravindrag |
last post by:
Hi,
I am getting error SQL1131N during sqlj.install_jar(...). There is no useful message in the diag.log (even with diag level 4). I am giving the diag.log entries at the end of this posting...
|
by: taisho |
last post by:
HP-UX, DB2v9, Java 1.4.2.13
I attempt to install a stored procedure via SQLJ.install and get the following:
db2 "call...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |