SQLJ.install_ja r raises unexpected system error

[tol7481]

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_JA R ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea

[tol7481]

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_ja r?
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_JA R ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea

[Rhino]

<to*****@iperbo le.bologna.it> wrote in message
news:11******** **************@ c74g2000cwc.goo glegroups.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_ja r?
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_ja r() should only have two
parameters but you've supplied THREE, according to your example. The example
in the manual is:

CALL sqlj.install_ja r( '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_JA R ('file:/something/else.jar', 'jjjjjj', 0)

but the result is

SQL1042C An unexpected system error occurred. SQLSTATE=58004

any idea?

Thanks,
Andrea

[tol7481]

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_ja r() should only have two
parameters but you've supplied THREE, according to your example. The example
in the manual is:
CALL sqlj.install_ja r( '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 "experiment s"
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