Admin: 1 версия

2010-06-01T05:06:02Z

1 версия

в 17:44, 31 мая 2010

2010-05-31T17:44:27Z

Новая страница

== Check ResultSet Holdability ==

You can get the result set holdability in three ways.
<OL><LI>int Statement.getResultSetHoldability()</LI><LI>int DatabaseMetaData.getResultSetHoldability()</LI><LI>int Connection.getHoldability()</LI></OL>



<source lang="java">
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class Main {
public static void main(String[] args) throws Exception {
Connection conn = getConnection();
DatabaseMetaData dbMeta = conn.getMetaData();
if (dbMeta.supportsResultSetHoldability(ResultSet.HOLD_CURSORS_OVER_COMMIT)) {
System.out.println("this database hold cursors over commit");
} else if (dbMeta.supportsResultSetHoldability(ResultSet.CLOSE_CURSORS_AT_COMMIT)) {
System.out.println("this database close cursors at commit");
}
conn.close();
}
private static Connection getConnection() throws Exception {
Class.forName("org.hsqldb.jdbcDriver");
String url = "jdbc:hsqldb:mem:data/tutorial";
return DriverManager.getConnection(url, "sa", "");
}
}</source>



<pre class=codeResult>this database hold cursors over commit</pre>

== ResultSet Holdability ==

You may improve database performance by including the ResultSet holdability:
<OL><LI>java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT</LI><LI>java.sql.ResultSet.CLOSE_CURSORS_AT_COMMIT</LI></OL>
Set ResultSet Holdability Using the Connection Object



<source lang="java">
int holdability = java.sql.ResultSet.HOLD_CURSORS_OVER_COMMIT;
conn.setHoldability(holdability);</source>

← Предыдущая	Версия 05:06, 1 июня 2010
(нет различий)

Java Tutorial/Database/ResultSet Holdability - История изменений

Admin: 1 версия

в 17:44, 31 мая 2010