Package javax.sql.rowset

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

1383
1384
1385
1386
1387
1388
1389
1390
1391
1392
1393
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();

        // Deletes the 4th row.
        jrs.absolute(4);
        jrs.deleteRow();
        try {
            jrs.getInt(1);
            fail("Should throw SQLException " + "since no current row.");
        } catch (SQLException e) {
View Full Code Here
1403
1404
1405
1406
1407
1408
1409
1410
1411
1412
1413
        assertEquals(3, index);

        jrs.setShowDeleted(true);
        assertTrue(jrs.getShowDeleted());

        jrs.absolute(3);
        jrs.deleteRow();
        jrs.first();
        index = 0;
        while (jrs.next()) {
            index++;
View Full Code Here
702
703
704
705
706
707
708
709
710
711
712
        jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        assertTrue(jrs.absolute(7));
        jrs.moveToInsertRow();
        jrs.updateInt(1, 8);
        jrs.updateString(2, "insert8");
        jrs.insertRow();
        jrs.moveToInsertRow();
View Full Code Here
753
754
755
756
757
758
759
760
761
762
763
        } catch (SQLException e) {
            // expected
        }
        jrs.moveToCurrentRow();

        assertTrue(jrs.absolute(3));
        jrs.updateString(2, "update3");
        jrs.updateRow();
        assertTrue(jrs.rowUpdated());
        assertEquals("update3", jrs.getString(2));
        jrs.cancelRowUpdates();
View Full Code Here
827
828
829
830
831
832
833
834
835
836
837
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

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

        // after rollback, resultset is closed
View Full Code Here
842
843
844
845
846
847
848
849
850
851
852
        } catch (NullPointerException e) {
            // expected
        }

        try {
            jrs.absolute(1);
            fail("should throw exception");
        } catch (NullPointerException e) {
            // expected
        }
View Full Code Here
868
869
870
871
872
873
874
875
876
877
878
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        jrs.setAutoCommit(false);
        assertFalse(jrs.getAutoCommit());
        assertTrue(jrs.absolute(3));
        jrs.updateString(2, "update3");
        jrs.updateRow();
        jrs.commit();
        jrs.rollback();
View Full Code Here
878
879
880
881
882
883
884
885
886
887
888
        /*
         * TODO why throw NullPointerException after call rollback()?
         */
        try {
            jrs.absolute(1);
            fail("should throw exception");
        } catch (NullPointerException e) {
            // expected
        }

View Full Code Here
924
925
926
927
928
929
930
931
932
933
934
    }

    public void testConstructor() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();
        try {
            jrs.absolute(3);
            fail("should throw SQLException");
        } catch (SQLException e) {
            // expected
        }
        jrs.addRowSetListener(new Listener());
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    public void testBeforeInitial() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();

        // move cursor
        try {
            jrs.absolute(1);
            fail("Should throw SQLException");
        } catch (SQLException e) {
            // expected, Invalid state
        }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.