Hi,
I am trying to build a very simple Java stored procedure on DB2 V8.2
for AIX.
I use the WSAD 5.1 or the DB2 Development Center with the same result:
C:\Program Files\SQLLIB\java\jdk\bin\jar cf SQL50107055425339.jar
com\ibm\xseries\PROCEDURE1.class
DB2INST1.PROCEDURE1 - Jar file created.
Call sqlj.install_jar
('file:///E|/ATLASProjects/Publish/.metadata/.plugins/com.ibm.etools.subuilder/dc/bld1105142718859/SQL50107055425339.jar',
'"DB2INST1".SQL50107055425339', 0)
[IBM][CLI Driver][DB2/6000] SQL4302N Procedure or user-defined function
"sqlejReadJar",
specific name "SQL050107190510460" aborted with an exception
"The file access permissions do not all". SQLSTATE=38501
DB2INST1.PROCEDURE1 - Build failed.
In the DB2 log:
2005-01-07-19.05.10.478786-300 I662015C730 LEVEL: Warning
PID : 41614 TID : 1 PROC : db2fmp (36288) 0
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, BSU Java support, sqlejLogException, probe:10
DATA #1 : String, 368 bytes
java.util.zip.ZipException: The file access permissions do not allow
the specifi
ed action.
/home/db2inst1/sqllib/function/jar/DB2INST1/SQL50107055425339.jar
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.(ZipFile.java:138)
at java.util.zip.ZipFile.(ZipFile.java:98)
at COM.ibm.db2.app.sqlejProcs.sqlejReadJar(sqlejProcs .java:76)
Actually I had built and run the same stored procedure successfully
previous to install the FixPack 7 of DB2 V8.1. I don't know what could
happened. This is not a access permission problem since the user has
full access to the db2 file system.
The configuration of the JDK seems to be OK.
$ db2 get dbm cfg
Java Development Kit installation path (JDK_PATH) = /usr/java14
Can some one help me to find out a work around?
Thanks in advance.
Juan Carlos Huitzache.