resultset « sybase « Java Database Q&A





1. Optimal update in resultset on Sybase IQ    stackoverflow.com

Im looking to rewrite code that update a table on a Sybase IQ database v14 that does the following:

  1. selects all the records in the table and extracts some data to file
  2. updates ...

2. How to split a resultset in Java into chunks (500 rows each) without looping?    stackoverflow.com

I have a query which returns millions of records which are held in a result set. I have to process (insert/update) these records. Instead of inserting all the record at ...

3. Error scrolling Sybase resultset    dbforums.com

4. Error scrolling Sybase resultset    dbforums.com

I'm calling a stored proc on Sybase. When trying to move to the first row in the resultset the following Exception is generated: java.sql.SQLException: JZ0R0: ResultSet has already been closed. at com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(Erro rMessage.java:436) at com.sybase.jdbc2.jdbc.SybResultSet.checkResultSet( SybResultSet.java:1479) at com.sybase.jdbc2.jdbc.SybResultSet.next(SybResultS et.java:112) at nl.boek123.jspbeans.ContingentBean.contingentInlez en(ContingentBean.java:317) at nl.boek123.jspbeans.ContingentBean.getContingentDa ta(ContingentBean.java:149) at java.lang.reflect.Method.invoke(Native Method) at com.sssw.srv.jsp.AgoJspHelper.invokeGetter(AgoJspH elper.java:265) at com.sssw.srv.jsp.AgoJspHelper.getBeanProperty(AgoJ spHelper.java:193) at com.sssw.gen.jsp.contingent_jsp_575758508._jspServ ice(contingent_jsp_575758508.java:492) at com.sssw.srv.jsp.AgoHttpJspPage.service(AgoHttpJsp Page.java:92) at ...

5. Obtain ResultSet from Sybase stored procedure    forums.oracle.com

Hi, I want to obtain a ResultSet from a Sybase stored procedure, but I'm not sure how to go about it. I'm guessing it's something along the following lines, but if anyone has experience in the area and can confirm this to be the case or has an alternative to propose, that would be very helpful. CallableStatement cs = con.prepareCall("{call sp_sampleprocedure}"); ...