"Rhino" <rhino1@NOSPAM.sympatico.ca> wrote in message
news:vq9Xc.16825$_H5.564966@news20.bellglobal.com. ..
>
> "Xela" <abuse@yahoo.com> wrote in message
> news:cgisiv$aqd$1@apollon.grec.isp.9tel.net...
> > Hi
> >
> > 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!
> >
> Check your file permissions for the directory containing the jar: do you
> have write authority to that file in the file system?
> 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
>


> Check your file permissions for the directory containing the jar: do you
> have write authority to that file in the file system?

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