By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,376 Members | 1,115 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,376 IT Pros & Developers. It's quick & easy.

Problem to build Java stored procedures on DB2 V8.2

P: n/a
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.

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.