RE: Does sapdb support multiple resultsets?

Hi, currently it is not possible to have more than one resultset with SAP DB. Maybe in future releases if dbprocs will have multiple resultsets.

Regards,
Marco
----------------------------------------------
Marco PASKAMP
SAP DB, SAP Labs Berlin

> -----Original Message-----
> From: Eduardo López [mailto:[email protected]]
> Sent: Mittwoch, 13. August 2003 16:51
> To: [email protected]
> Subject: Does sapdb support multiple resultsets?
> 
> 
> [...]
> 
> Statement stm;
> ResultSet rs;
> [...]
> this.stm = database.getJdbcConnection().createStatement();
> this.stm.setMaxRows(100);
> [...]
> boolean moreResults = this.stm.execute(sql);
> if (moreResults ) {
>    rs = this.stm.getResultSet();
> [...]
> moreResults  = !(!rs.getStatement().getMoreResults() &&
> (rs.getStatement().getUpdateCount() == -1)); // THE RESULT IS 
> EVER FALSE!!!
> while (moreResults) {
>      rs = rs.getStatement().getResultSet();
>     while (rs.next())
>     [...]
> }
> 
> 
> 
> 
> _______________________________________________
> sapdb.general mailing list
> [email protected]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>