469,945 Members | 1,794 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,945 developers. It's quick & easy.

SQLJ.install_jar raises unexpected system error

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
3 2962
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

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

By using this site, you agree to our Privacy Policy and Terms of Use.