JDBC driver connection

antoDb2_user · #1 (**permalink**) 02-05-12, 11:49

Hi at all,

A am developing an application that have to connect a DB2 Database system with JDBC driver.
I am using a licensed driver (db2jcc.jar with license jar).

I am able to call simple stored procedure bu i have some problem when i try to invoke a stored procedure that returns a complex out argument.

I have tried with something like this:

Quote:

com.ibm.db2.jcc.DB2SimpleDataSource ds = new com.ibm.db2.jcc.DB2SimpleDataSource();
// set connection properties
ds.setServerName("AC-PC");
ds.setPortNumber(50000);
ds.setDatabaseName("sample");
ds.setDriverType(4);
java.sql.Connection con = ds.getConnection("db2admin", "db2admin");
// execute a query
String query = "CALL DB2ADMIN.TEST('12', ?)";
java.sql.CallableStatement stmt = con.prepareCall(query);
stmt.registerOutParameter (1, Types.STRUCT);
stmt.execute();

but i have the following error:
ERRORCODE=-4228, SQLSTATE=null
This error is raised by following java statement:

Quote:

stmt.registerOutParameter (1, Types.STRUCT);

Is java.sql.Types.STRUCT not supported by IBM Driver?