SQLJ.install_jar raises unexpected system error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tol7481@iperbole.bologna.it - 26 May 2006 17:11 GMT

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

Reply to this Message

tol7481@iperbole.bologna.it - 06 Jun 2006 17:30 GMT

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,
[quoted text clipped - 18 lines]
> Thanks,
> Andrea

Reply to this Message

Rhino - 06 Jun 2006 22:52 GMT

> Hi,
> it's me again.
[quoted text clipped - 16 lines]
> 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,
[quoted text clipped - 18 lines]
>> Thanks,
>> Andrea

Reply to this Message

tol7481@iperbole.bologna.it - 07 Jun 2006 14:07 GMT

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/developerworks/db2/library/techarticle/dm-0510law#commonp
roblems

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/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.
db2.doc.java/bjnkmstr132.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

Reply to this Message