1. Optimal update in resultset on Sybase IQ stackoverflow.comIm looking to rewrite code that update a table on a Sybase IQ database v14 that does the following:
|
2. How to split a resultset in Java into chunks (500 rows each) without looping? stackoverflow.comI 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.comI'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.comHi, 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}"); ... |