Forums Register Login

Stored Procedure CachedRowSet

+Pie Number of slices to send: Send
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 ]
ice is for people that are not already cool. Chill with this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1873 times.
Similar Threads
Eclispe + Hibernate + DB2 version 9
HibernateTransactionManager Error
Exception in update
CachedRowSet - Stored Procedure
Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 18, 2024 20:20:22.