Java and Stored Procedures

[nicka3]

Hello!!

How can I obtain out param of Procedure in DB2 from Java??
My code is:

ConnectDB DB = new ConnectDB();
CON = DB.getConnection();
String sRES = "";
String param = "12345678"

CallableStatement cs = null;
String sSQL = " CALL PROCEDURE('"+param+"',?)";
cs = CON.prepareCall(sSQL);
cs.registerOutParameter(1,Types.CHAR);
cs.execute();

sRES = cs.getString(1);

But I Have the exception:

java.lang.NoClassDefFoundError: com/ibm/db2/jcc/SQLJPackage
at COM.ibm.db2.jdbc.net.DB2Connection.prepareCall(DB2Connection.java:658)

Why??? I need help. Thank you.

 

[sedj]

>>>>> java.lang.NoClassDefFoundError: com/ibm/db2/jcc/SQLJPackage

Sounds like your problem is a CLASSPATH issue - it cannot find the indicated package and/or class ...

 

[nicka3]

My application's running The problem was I have 'db2driver.jar' in the classpath, but I haven't included `db2jcc.jar' that is necesary for execute stored procedures with Callable Statement.

Thank you very muchhhhhhhhh...

(I'm sorry my English is very bad)