Examples of java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets()

java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets()

Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable. When a SQLException occurs while autocommit is true, it is vendor specific whether the JDBC driver responds with a commit operation, a rollback operation, or by doing neither a commit nor a rollback. A potential result of this difference is in whether or not holdable ResultSets are closed. @return true if so; false otherwise @exception SQLException if a database access error occurs @since 1.6

            System.out.println
                ("FAIL: supportsStoredFunctionsUsingCallSyntax() " +
                 "should return true");
        }


        if (met.autoCommitFailureClosesAllResultSets()) {
            System.out.println
                ("FAIL: autoCommitFailureClosesAllResultSets() " +
                 "should return false");
        }

     */
    private static void testAutoCommitFailure(Connection con)
        throws SQLException
    {
        DatabaseMetaData dmd = con.getMetaData();
        boolean shouldBeClosed = dmd.autoCommitFailureClosesAllResultSets();


        con.setAutoCommit(true);


        Statement s1 =
            con.createStatement(ResultSet.TYPE_FORWARD_ONLY,

            System.out.println
                ("FAIL: supportsStoredFunctionsUsingCallSyntax() " +
                 "should return true");
        }


        if (met.autoCommitFailureClosesAllResultSets()) {
            System.out.println
                ("FAIL: autoCommitFailureClosesAllResultSets() " +
                 "should return false");
        }

     */
    private static void testAutoCommitFailure(Connection con)
        throws SQLException
    {
        DatabaseMetaData dmd = con.getMetaData();
        boolean shouldBeClosed = dmd.autoCommitFailureClosesAllResultSets();


        con.setAutoCommit(true);


        Statement s1 =
            con.createStatement(ResultSet.TYPE_FORWARD_ONLY,

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.