Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

This solution gives forward only ResultSet objects. Is there any way to get scrollable ResultSets?

April 26, 2017forward gives objects ResultSet resultsets scrollable solution

0

Posted

This solution gives forward only ResultSet objects. Is there any way to get scrollable ResultSets?

1 Answer

0

Posted

I’m using the Oracle thin driver to update a batch of records using a prepared statement, addBatch() and executeBatch(). All of the updates go through fine and the data is updated correctly, but all of the updateCounts returned are “-2”. I haven’t been able to find any documentation for the thin driver, so I don’t know if this return code is something I should be worried about, or if I should just ignore it. Location: http://www.jguru.com/faq/view.jsp?EID=525335 Created: Oct 19, 2001 Author: Joe Sam Shirah (http://www.jguru.com/guru/viewbio.jsp?EID=42100) Question originally posed by Tim Duggan (http://www.jguru.com/guru/viewbio.jsp?EID=506387 From the JDK 1.3 Statement.executeBatch() API documentation: “A value of -2 — indicates that the command was processed successfully but that the number of rows affected is unknown.” See the documentation and Batch Update Facility for more information. I have a Stored procedure, which consists of the following: • Creating a Temp Table • Inserting