Client OS: Windows 2000
Server OS : Redhat Linux 8.0
Database: DB2 ver. 8

How to call the store procedure(sqlj.install_jar) using jdbc?

My code as following but doesn't work.

private CallableStatement cblStatement = null;

cblStatement = cn_any.prepareCall("{call sqlj.install_jar(?,?)}");
cblStatement.setString(1,"file:/home/db2inst1/UDR/myudr.jar");
cblStatement.setString(2,"myudr");
cblStatement.executeUpdate();

Is there anyone can help me?

Thanks.

I have 2 questions,

1) What is the SP supposed to do? Does it return a result set?

2) What error (if any) are you getting.

Andy

1.
The SP doesn't return a result set, just put the jar file to the database.
2.
I changed the first parameter:
cblStatement.setString(1,"file:/home/UDR/myudr.jar");
It was still not work.

The error as following:

com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -804, SQLSTATE: 07002, SQLERRMC: 109

Sorry I did not reply sooner, I was out of the office for a few days.

SQL state 07002 is an invalid parameter error. What is the definition of the SP?

Andy

Hi Andy,

Installing, Replacing, and Removing JAR Files
To install or replace a JAR file in the DB2 instance, you can use the following command syntax at the Command Line Processor:

(1) (2)
>>-CALL-+-SQLJ.INSTALL_JAR-+---(--'--jar-url----'--,--'--jar-id----'--)-->
'-SQLJ.REPLACE_JAR-'

>--------------------------------------------------------------><

Notes:


Specifies the URL containing the JAR file to be installed or replaced. The only URL scheme supported is 'file:'.

Specifies the JAR identifier in the database to be associated with the file specified by the jar-url.

For example, to install the Proc.jar file located in the file:/home/db2inst/classes/ directory in the DB2 instance, issue the following command from the Command Line Processor:

CALL SQLJ.INSTALL_JAR('file:/home/db2inst/classes/Proc.jar' , 'myproc_jar')

Stored Procedures and UDFs in Java:
http://www-306.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frame3.htm#db2a0165

Hae you been able to call the SP through the CLP or some other method? It looks OK to me in JDBC.

Andy