Examples of javax.sql.rowset.JdbcRowSet.commit()

javax.sql.rowset.JdbcRowSet.commit()
Each JdbcRowSet contains a Connection object from the ResultSet or JDBC properties passed to it's constructors. This method wraps the Connection commit method to allow flexible auto commit or non auto commit transactional control support.
Makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by this Connection object. This method should be used only when auto-commit mode has been disabled. @throws SQLException if a database access error occurs or thisConnection object within this JdbcRowSet is in auto-commit mode @see java.sql.Connection#setAutoCommit

        jrs.setAutoCommit(false);
        assertFalse(jrs.getAutoCommit());
        assertTrue(jrs.absolute(3));
        jrs.updateString(2, "update3");
        jrs.updateRow();
        jrs.commit();
        jrs.rollback();


        /*
         * TODO why throw NullPointerException after call rollback()?
         */

View Full Code Here

        }
        jrs.close();


        // after close
        try {
            jrs.commit();
            fail("should throw NullPointerException");
        } catch (NullPointerException e) {
            // expected
        }
        try {

View Full Code Here

        } catch (NullPointerException e) {
            // expected
        }


        try {
            jrs.commit();
            fail("Should throw NullPointerException");
        } catch (NullPointerException e) {
            // expected
        }

View Full Code Here

        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");


        try {
            jrs.commit();
            fail("Shuld throw NullPointerException since jrs has not been executed.");
        } catch (NullPointerException e) {
            // Expected.
        }

View Full Code Here

        }


        try {
            assertTrue(jrs.getAutoCommit());
            jrs.setAutoCommit(true);
            jrs.commit();
            // The behaviour of jrs should be same with the connection.


            if (hasCommitException) {
                fail("Should throw SQLException");
            }

View Full Code Here

        jrs.moveToCurrentRow();
        assertTrue(jrs.absolute(6));
        assertEquals(6, jrs.getInt(1));


        // Commits
        jrs.commit();
        assertTrue(jrs.absolute(6));
        assertEquals(6, jrs.getInt(1));
        jrs.commit();
        jrs.close();
    }

View Full Code Here


        // Commits
        jrs.commit();
        assertTrue(jrs.absolute(6));
        assertEquals(6, jrs.getInt(1));
        jrs.commit();
        jrs.close();
    }


    /**
     * @test javax.sql.rowset.JdbcRowTest.rollback()

View Full Code Here

TOP

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.