jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Stored Procedure CachedRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Stored Procedure CachedRowSet" Watch "Stored Procedure CachedRowSet" New topic

Stored Procedure CachedRowSet

J. Alenis

Joined: Jul 12, 2004
Posts: 16
Is there a possibility to put a Stored Procedure into a CachedRowSet?

I tried with:

crs.setCommand("Call DB.STORPROC(?,?,'aa>''111111111111''')");

and I get:

com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -313, SQLSTATE: 07004, SQLERRMC: null
at com.ibm.db2.jcc.c.yc.d(yc.java:1257)
at com.ibm.db2.jcc.a.db.l(db.java:365)
at com.ibm.db2.jcc.a.db.e(db.java:101)
at com.ibm.db2.jcc.a.r.e(r.java:108)
at com.ibm.db2.jcc.a.sb.i(sb.java:191)
at com.ibm.db2.jcc.c.yc.o(yc.java:1225)
at com.ibm.db2.jcc.c.zc.d(zc.java:2315)
at com.ibm.db2.jcc.c.zc.S(zc.java:557)
at com.ibm.db2.jcc.c.zc.executeUpdate(zc.java:540)
at com.sun.rowset.internal.CachedRowSetReader.readData(Unknown Source)
at com.sun.rowset.CachedRowSetImpl.execute(Unknown Source)
at be.minfin.rdc.test.DisconnectedExample.main(DisconnectedExample.java:40)

Can anyone help me?
[ August 18, 2004: Message edited by: J. Alenis ]
Have you checked out Aspose?
subject: Stored Procedure CachedRowSet
It's not a secret anymore!