A have a very annoying problem. I have written java strored procedures for
DB2 v8.1. Their deployement and usage is fine as long as the server is a
Windows one. But under Solaris 8 and Linux RH, the call of sqlj.install_jar
fails. It correctly create a directiory with the correct schema name, but
the jar is not copied in it. The error is "Permission Denied" SQLSTATE 38501
and in the log, we can see that calling sqlejReadJar fails in method
ZipFile.open. Any help would be greatly apreciated. Thaks for your
attention!
AL
If that's not the problem, what SQLCODE are you getting? The SQLSTATE is not
nearly as useful as the SQLCODE for most problems....
Rhino
Yes I think have. Indeed, when the directory (schema name) )is created by
db2, its rights are "drwxrwxr-x".
It belongs to the instance login whose group has sysadm authority. I tried
to change the rigths to "drwxrwxrwx" and it is all the same. I have also
tried to connect to the db with alternate users. I tried to change the
primary group of the users, but without success.
The SQLCODE is SQL4302N . -4302/38501/[IBM][CLI
The stack log is :
2004-08-26-09.21.07.670993 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejCallJavaRoutine_dll Probe:315
Exception thrown during routine invocation:
0xFFBEDB78 : 0x001322C0 ..".
2004-08-26-09.21.07.717752 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10
ADM10000W A Java exception has been caught. The Java stack traceback has
been
written to the db2diag.log.
2004-08-26-09.21.07.744692 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
BSU Java support sqlejLogException Probe:10
java.util.zip.ZipException: Permission denied
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:112)
at java.util.zip.ZipFile.<init>(ZipFile.java:72)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs.java:76)
0xFFBEDA3C : 0x00000000 ....
2004-08-26-09.21.07.749982 Instance:db2inst1 Node:000
PID:17997(db2fmp (16865) 0) TID:1 Appid:none
routine_infrastructure sqlerJavaCallRoutine Probe:30
Error from DB2ER CallUDF. RC:
0xFFBEDF04 : 0xFFFFEF32 ...2
Many thanks for your attention
AL
Thanks.
"Sean McKeough" <mcke...@nospam.ibm.com> wrote in message
news:412dd...@news3.prserv.net...
I just tried this on a local RH box, and was able to install my jar...
AL
"Sean McKeough" <mcke...@nospam.ibm.com> wrote in message
news:412df...@news3.prserv.net...
AL
"Sean McKeough" <mcke...@nospam.ibm.com> wrote in message
news:412e1...@news3.prserv.net...