db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by KnutAndersHatlen
Date Mon, 05 Mar 2012 13:41:01 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The "DerbySQLroutines" page has been changed by KnutAndersHatlen:
http://wiki.apache.org/db-derby/DerbySQLroutines?action=diff&rev1=24&rev2=25

    CallableStatement cs = conn.prepareCall("{ call DRS2(?, ?)}");
    cs.setInt(1, p1);
    cs.setInt(2, p2);
-   cs.execute();
-   WORK IN PROGESS
+ 
+   boolean hasResults = cs.execute();
+ 
+   while (hasResults) {
+       ResultSet rs = cs.getResultSet();
+       while (rs.next()) {
+           // ....
+       }
+       rs.close();
+       hasResults = cs.getMoreResults();
+   }
  }}}
  Items to note:
  

Mime
View raw message