Examples of java.sql.Statement.closeOnCompletion()

java.sql.Statement.closeOnCompletion()

Specifies that this {@code Statement} will be closed when all itsdependent result sets are closed. If execution of the {@code Statement}does not produce any result sets, this method has no effect.

Note: Multiple calls to {@code closeOnCompletion} donot toggle the effect on this {@code Statement}. However, a call to {@code closeOnCompletion} does effect both the subsequent execution ofstatements, and statements that currently have open, dependent, result sets. @throws SQLException if this method is called on a closed{@code Statement} @since 1.7

  }


  public static boolean getStandardConformingStrings(Connection con) throws SQLException {


    Statement stmt = con.createStatement();
    stmt.closeOnCompletion();


    ResultSet rs = stmt.executeQuery("SHOW standard_conforming_strings");
    if (rs.next()) {
      return rs.getBoolean(1);
    }

     * Test the behavior of closeOnCompletion with a single result set
     */
    public void testSingleResultSet() throws SQLException
    {
        Statement stmt = _conn.createStatement();
        stmt.closeOnCompletion();


        ResultSet rs = stmt.executeQuery(TestUtil.selectSQL("table1", "*"));
        rs.close();
        assertTrue(stmt.isClosed());
    }

     * Test the behavior of closeOnCompletion with a multiple result sets
     */
    public void testMultipleResultSet() throws SQLException
    {
        Statement stmt = _conn.createStatement();
        stmt.closeOnCompletion();


        stmt.execute(TestUtil.selectSQL("table1", "*") + ";" + 
                     TestUtil.selectSQL("table1", "*") + ";");
        ResultSet rs = stmt.getResultSet();
        rs.close();

     * closeOnCompletion has no effect (spec)  
     */
    public void testNoResultSet() throws SQLException
    {
        Statement stmt = _conn.createStatement();
        stmt.closeOnCompletion();


        stmt.executeUpdate(TestUtil.insertSQL("table1", "1"));
        assertFalse(stmt.isClosed());
    }
}

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.