db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Hill <Thomas.K.H...@t-online.de>
Subject Returning java.sql.ResultSets from Java procedures
Date Sun, 04 Mar 2012 23:03:43 GMT
Hi,
can someone please share an example how the Client side application code to call
procedure looks like when I want my stored procedure to return TWO resultsets?
The derby Wiki (extract see below) says 'WORK IN PROGRESS' in the section where
documentation on this had been started.

CallableStatement cs = conn.prepareCall("{ call DRS2(?, ?)}");
  cs.setInt(1, p1);
  cs.setInt(2, p2);
  cs.execute();
  WORK IN PROGESS 


Mime
View raw message