sqlejProcs - Missing, or is it?

[David Lentz]

Hello all,
I have bowed down and resorted to the GUI Stored Procedure Builder to
create 1 stored procedure that works in DB/2 7.2, JDK 1.2. ( I loathe GUI
Development environments) However, when I run a stored procedure inside the
builder, I get:

QUEST.TEST - [IBM][CLI Driver][DB2/NT] SQL4304N Java stored procedure or
user-defined function ".", specific name "" could not load Java class
"COM/ibm/db2/app/sqlejProcs", reason code "1". SQLSTATE=42724

I looked and found that class in the db2java.zip file (which is in my
classpath). Do I need to set anything else up to get this to work?

Thanks,
dlentz

PS - Here is a snippet from my db2diag.log:
2001-08-07-08.38.37.576000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP_dll Probe:41

Class loader loadClass failed. class:7265 6164 4c69 7374 73
readLists

2001-08-07-08.38.37.606000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP Probe:30

Error from DB2JEXT CallSTP. RC:
30ef ffff 0пяя

2001-08-07-08.41.20.110000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP_dll Probe:38

Exception thrown during class loader loadClass:f43c b602
ф<¶.

2001-08-07-08.41.20.130000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejLogException Probe:10

java.lang.ClassNotFoundException: COM/ibm/db2/app/sqlejProcs
at java.lang.Throwable.<init>(Throwable.java:96)
at java.lang.Exception.<init>(Exception.java:44)
at java.lang.ClassNotFoundException.<init>(ClassNotFoundException.java:71)
at
COM.ibm.db2.app.classloader.DynamicClassLoader.loadNonSystemClass(DynamicCla
ssLoader.java(Compiled Code))
at
COM.ibm.db2.app.classloader.ClassLoaderTemplate.loadClass(ClassLoaderTemplat
e.java:83)
at java.lang.ClassLoader.loadClass(ClassLoader.java:250)
at
COM.ibm.db2.app.classloader.PowerClassLoader.loadNonSystemClass(PowerClassLo
ader.java:76)
at
COM.ibm.db2.app.classloader.ClassLoaderTemplate.loadClass(ClassLoaderTemplat
e.java:83)
at java.lang.ClassLoader.loadClass(ClassLoader.java:250)

2001-08-07-08.41.20.140000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejLogException Probe:30

COM/ibm/db2/app/sqlejProcs

2001-08-07-08.41.20.160000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP_dll Probe:40

Class loader loadClass failed. class:434f 4d2f 6962 6d2f 6462 322f 6170 702f
COM/ibm/db2/app/
7371 6c65 6a50 726f 6373 sqlejProcs

2001-08-07-08.41.20.170000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP_dll Probe:41

Class loader loadClass failed. class:7371 6c65 6a52 6561 644a 6172
sqlejReadJar

2001-08-07-08.41.20.210000 Instance:DB2 Node:000
PID:1492(db2dari.exe) TID:856 Appid:
BSU Java support sqlejCallSTP Probe:30

Error from DB2JEXT CallSTP. RC:
30ef ffff 0пяя