By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,559 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,559 IT Pros & Developers. It's quick & easy.

SQLJ.install_jar raises unexpected system error

P: n/a
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
sqllib/java/db2jcc.jar
sqllib/java/db2jcc_license_cu.jar
sqllib/java/sqlj.zip

then with the DB2 interactive SQL I've launched

db2 => CALL SQLJ.INSTALL_JAR ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea

May 26 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi,
it's me again.
I (almost) solved my problem manually moving the JAR in the folder

/home/db2inst1/sqllib/function/jar/<DB NAME>

on the server but now I have a problem launching my stored procedure...
DB2 raises

SQL4301N Java or .NET interpreter startup or communication failed,
reason
code "0". SQLSTATE=58004
....
sqlcode : -4301

sqlstate : 58004

Maybe DB2 JVM can't find my jar file because I didn't use
SQLJ.install_jar?
Any idea about my install_jar problem?

Thanks,
Andrea
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
sqllib/java/db2jcc.jar
sqllib/java/db2jcc_license_cu.jar
sqllib/java/sqlj.zip

then with the DB2 interactive SQL I've launched

db2 => CALL SQLJ.INSTALL_JAR ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea


Jun 6 '06 #2

P: n/a

<to*****@iperbole.bologna.it> wrote in message
news:11**********************@c74g2000cwc.googlegr oups.com...
Hi,
it's me again.
I (almost) solved my problem manually moving the JAR in the folder

/home/db2inst1/sqllib/function/jar/<DB NAME>

on the server but now I have a problem launching my stored procedure...
DB2 raises

SQL4301N Java or .NET interpreter startup or communication failed,
reason
code "0". SQLSTATE=58004
...
sqlcode : -4301

sqlstate : 58004

Maybe DB2 JVM can't find my jar file because I didn't use
SQLJ.install_jar?
Any idea about my install_jar problem?
Are you sure you've copied the error information correctly? According to the
Information Center, there is no reason code 0 for SQL4301N, just reason
codes 1 through 6.

Also, according to the manuals, sqlj.install_jar() should only have two
parameters but you've supplied THREE, according to your example. The example
in the manual is:

CALL sqlj.install_jar( 'file:/home/bob/bobsjar.jar', 'MYJAR' )
Maybe the solution is as simple as removing your last parameter?--Rhino
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
sqllib/java/db2jcc.jar
sqllib/java/db2jcc_license_cu.jar
sqllib/java/sqlj.zip

then with the DB2 interactive SQL I've launched

db2 => CALL SQLJ.INSTALL_JAR ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea

Jun 6 '06 #3

P: n/a
Hi!
Are you sure you've copied the error information correctly? According to the
Information Center, there is no reason code 0 for SQL4301N, just reason
codes 1 through 6. Yes the error information was just copied & pasted, this reason code is
also explained in

http://www-128.ibm.com/developerwork...commonproblems

I checked my configuration according to the article (JDK_PATH, ...) but
everything seems fine...
Also, according to the manuals, sqlj.install_jar() should only have two
parameters but you've supplied THREE, according to your example. The example
in the manual is:
CALL sqlj.install_jar( 'file:/home/bob/bobsjar.jar', 'MYJAR' )
Maybe the solution is as simple as removing your last parameter?--Rhino

Same error even with two parameters.
I used the three params syntax because I made my first "experiments"
with iSeries and I found that syntax in the documentation:

http://publib.boulder.ibm.com/infoce...jnkmstr132.htm

Errata corrige about the error I get with install_jar: I've corrected
the CLASSPATH (db2java.zip and other jars were not included) and
now I get the error about the JVM:
SQL4301N Java or .NET interpreter startup or communication failed,
reason code "0". SQLSTATE=58004
....
sqlcode : -4301
sqlstate : 58004

:-(

Any idea?
Thanks,
Andrea

Jun 7 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.