DB2 V7.1 NT fixpack2 Java Stored Procedure 
Author Message
 DB2 V7.1 NT fixpack2 Java Stored Procedure

Hi,
 I am testing Java stored procedure on DB2 V7.1. with the IBM Stored
Procedure Builder Tool.

Q1: When I use jdk1.1 there 's no problem to build my stored procedure
but I am surprise that when I run the Java instruction
System.getProperty("java.class.path") in the stored procedure,
the Classpath contain only the <DB2PATH>\java directory.
This result in the impossibility to use any other import.

Q1: When I switch to jdk1.2 with commands DB2SET DB2_USE_JDK12=TRUE
and DB2 UPDATE DBM CFG USING JDK11_PATH path, I can't event build any
stored procedure.
I get this message in french:

[IBM][CLI Driver][DB2/NT] SQL4304N La procdure mmorise ou la fonction utilisateur Java ".",
nom spcifique "" n'a pas pu charger la classe
Java "COM/ibm/db2/app/sqlejProcs",
 code anomalie "1".  SQLSTATE=42724

obviously it can't find the import db2java.zip even when referenced in
my system Classpath.

I can't understand why DB2 JVM don't use system default CLasspath ?

Is anyone has already noticed this problem ?

Thanks.

Mat.

--
Sent by mlgmat from  hotmail in area com
This is a spam protected message. Please answer with reference header.
Posted via http://www.***.com/



Sun, 17 Aug 2003 23:32:06 GMT
 DB2 V7.1 NT fixpack2 Java Stored Procedure


Quote:
> Hi,
>  I am testing Java stored procedure on DB2 V7.1. with the IBM Stored
> Procedure Builder Tool.

> Q1: When I use jdk1.1 there 's no problem to build my stored procedure
> but I am surprise that when I run the Java instruction
> System.getProperty("java.class.path") in the stored procedure,
> the Classpath contain only the <DB2PATH>\java directory.
> This result in the impossibility to use any other import.

DB2 uses a classloader internally and is not dependent on the CLASSAPTH
alone. You can either put your classes in the sqllib/function directory or
install them as jars with install_jar. The classloader should also use the
system CLASSPATH.

Quote:
> Q1: When I switch to jdk1.2 with commands DB2SET DB2_USE_JDK12=TRUE
> and DB2 UPDATE DBM CFG USING JDK11_PATH path, I can't event build any
> stored procedure.
> I get this message in french:

> [IBM][CLI Driver][DB2/NT] SQL4304N La procdure mmorise ou la fonction

utilisateur Java ".",

Quote:
> nom spcifique "" n'a pas pu charger la classe
> Java "COM/ibm/db2/app/sqlejProcs",
>  code anomalie "1".  SQLSTATE=42724

> obviously it can't find the import db2java.zip even when referenced in
> my system Classpath.

> I can't understand why DB2 JVM don't use system default CLasspath ?

> Is anyone has already noticed this problem ?

Yep, I've noticed that too and alerted the developers. But it get's fixed
more quickly if you call DB2 service (see second link in my .sig) and tell
them that you need that yesterday ;-)

BTW:That's not a CLASSPATH problem. There's no class sqlejProcs.

Quote:
> Thanks.

> Mat.

Regards, Dirk

--
Dirk Wollcheid, IBM Silicon Valley Labs
Websphere Database Development

Get DB2 help here: http://www-4.ibm.com/software/data/db2/library/

http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/i...
w/report
Get WebSphere help here: http://www-4.ibm.com/software/webservers/appserv/



Mon, 18 Aug 2003 02:07:41 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling a Java Stored Procedure from another Java Stored Stored Procedure

2. Gettting SQL0751N trying to call java stored procedure from a java stored procedure

3. Win2k - DB2 / Compiling stored procedures - V7

4. Connecting to db2 v7.1(linux) from db2 5.2 cc(nt)

5. SQLJ Java Stored Procedures with DB2 6 on OS/390

6. DB2 Java Stored procedures

7. DB2 Java stored procedures privileges

8. accessing db2 stored procedure from java

9. DB2 java stored procedure

10. Interpreted Java Stored Procedures with DB2 on OS/390

11. Problem: DB2 7.2 Stored Procedure in Java

12. STORED PROCEDURES FOR DB2 USING C AND JAVA


 
Powered by phpBB® Forum Software