Geek Answers Handbook

JDBC: default persistence of ResultSet

Is there a default value for holding the ResultSet if Connection.setHoldability() never called or holdings are never specified when creating the statement?

I could not find anything in the JDBC api docs - is this a specific implementation?

Thanks.

+4
source share
2 answers

“The default hold property for a ResultSet object is the implementation defined. The default holdability of the ResultSet objects returned by the main data source can be determined using the APIs provided by JDBC 3.0.

Refer to this link for reference.

+4
source

The default hold is implementation-specific, but you can get the default hold by calling the getResultSetHoldability method in DatabaseMetaData to connect.

For more information, see section 6.1.9 in the Oracle / Sun JDBC docs: http://download.oracle.com/javase/1.4.2/docs/guide/jdbc/getstart/resultset.html

+4
source

More articles:


All Articles