Top "Resultset" questions

Getting the date from a ResultSet for use with java.time classes

Is there anyway to get a java.time (new in Java 8) compatible time class out of a ResultSet? I am …

java-8 resultset getdate java-time

Treating an SQL ResultSet like a Scala Stream

When I query a database and receive a (forward-only, read-only) ResultSet back, the ResultSet acts like a list of database …

scala stream resultset

Copying Java ResultSet

I have a java.sql.ResultSet object that I need to update. However the result set is not updatable. Unfortunately …

java jdbc resultset

how to reset the result set to the first row after looping through a while loop

My code has two loops, my outer loop should loop through all the rows of the inner loop for the …

java resultset

Reusing MyBatis ResultMap in multiple mapper.xml

I would like to re-use a specific from different *Mapper.xml files which all somehow read same objects. I have …

refactoring mybatis resultset mappers

Where to close a JDBC Connection while I want to return the ResultSet

It seems that the ResultSet will be automatically closed when I close the Connection. But I want to return the …

java jdbc connection resultset

Why should I call close() on a ResultSet and Connection instance?

When I don't need to use instances of those ResultSet and Connection anymore in my program, why should I call …

java jdbc connection resultset

Does reusing a Statement and Resultset release resources from its previous usage? Or do I have to explicitly close them before reuse?

Sample code: aStmt = aConn.prepareStatement(aQuery); aRset = aStmt.executeQuery(cQuery); while (cRset.next()) { //stuff to determine value of parm1 aStmt.…

java jdbc resultset

display resultset from oracle 10g stored procedure

I am using PL/SQL Developer and i have written a procedure to run a report and i need to …

oracle stored-procedures resultset plsqldeveloper

Implementations of RowSet, CachedRowSet etc

Until today I was working with ResultSet when handling results from queries. But today I read a little about RowSet …

java jdbc resultset rowset cachedrowset