473,387 Members | 1,611 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Problem to build Java stored procedures on DB2 V8.2

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
0 2002

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Suresh Tri | last post by:
Hi all, I am interested in extracting the class or jar files which are stored as java stored procedures in Oracle. But I want to know if these are stored as references to external files in...
1
by: Suresh Tri | last post by:
Hi all, I am in search of any Enterprise level Opensource Project that uses Java Stored Procedures supported by Oracle. I could not find any by googling. Can any one plese point me to any such...
14
by: Tony | last post by:
Can someone a little more clever than I (which means just about anyone on this list) tell me what the implications/benefits are of this are please? ...
4
by: Rhino | last post by:
Is it possible for a Java Stored Procedure in DB2 V7.2 (Windows) to pass a Throwable back to the calling program as an OUT parameter? If yes, what datatype should I use when registering the...
0
by: Sumit Gupta | last post by:
We are developing Java Stored Procedures using DB2 Development Center v8. While importing a stored procedure (.java file) from one database to another using the Development Center, all the...
1
by: Kumar | last post by:
Hi I am trying to recreate a database under the following environments : From: Solaris with DB2UDB version 7.2 with FP 9 To: Linux with DB2UDB version 7.2 with FP 9 It will be of really a...
2
by: Kent Lewandowski | last post by:
hi all, Recently I wrote some stored procedures using java jdbc code (admittedly my first stab) and then tried to implement the same within java packages (for code reuse). I encountered...
1
by: esmith2112 | last post by:
We all of a sudden find ourselves in dire straits, because we have one of those mysteries where everything used to work, and apparently, all of a sudden everything went to pot just in time for a...
4
by: nishi57 | last post by:
I hope I can get some help regarding this issue, which has been going on for a while. I have a desktop user who is having problem running "Stored Procedures". The DB2 Connect application works fine...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.