Package javax.sql.rowset

Examples of javax.sql.rowset.CachedRowSet.beforeFirst()


        assertEquals(3, crset.getInt(1));
        assertFalse(crset.next());

        // deep copy
        CachedRowSet copyCrset = crset.createCopy();
        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());
        copyCrset.execute();
        assertTrue(copyCrset.next());
View Full Code Here


        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());

        copyCrset.execute();
        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());

        copyCrset.setInt(1, 1);
View Full Code Here

        assertSame(crset.getMetaData(), jrs.getMetaData());
        assertSame(crset.getMetaData(), toCrset.getMetaData());
        assertNotSame(crset, toCrset);
        // check data
        int index = 0;
        toCrset.beforeFirst();
        crset.beforeFirst();
        while (toCrset.next() && crset.next()) {
            for (int i = 1; i <= crset.getMetaData().getColumnCount(); i++) {
                assertEquals(toCrset.getObject(i), crset.getObject(i));
            }
View Full Code Here

         * check data. The data order is not the same between RI and HY.
         */
        index = 0;
        rs = st.executeQuery("SELECT * FROM BOOKS");
        if ("true".equals(System.getProperty("Testing Harmony"))) {
            toCrset.beforeFirst();
            while (toCrset.next() && rs.next()) {
                index++;
                assertEquals(toCrset.getObject(14), rs.getObject(3));
            }
        } else {
View Full Code Here

        assertEquals(3, webRs.getInt(1));
        assertFalse(webRs.next());

        // deep copy
        CachedRowSet copyWebRs = webRs.createCopy();
        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());
        copyWebRs.execute();
        assertTrue(copyWebRs.next());
View Full Code Here

        webRs.beforeFirst();
        assertTrue(webRs.next());
        assertEquals(4, webRs.getInt(1));
        assertFalse(webRs.next());

        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());

        copyWebRs.execute();
View Full Code Here

        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());

        copyWebRs.execute();
        copyWebRs.beforeFirst();
        assertTrue(copyWebRs.next());
        assertEquals(3, copyWebRs.getInt(1));
        assertFalse(copyWebRs.next());

        copyWebRs.setInt(1, 1);
View Full Code Here

        crset.beforeFirst();
        jrs.addRowSet(crset, 1);
        assertTrue(crset.isLast());

        crset.first();
        crset2.beforeFirst();
        jrs.addRowSet(crset2, 1);
        assertTrue(crset2.isLast());
        assertTrue(crset.isFirst());

        jrs = newJoinRowSet();
View Full Code Here

        }

        crset2.absolute(6);
        crset2.deleteRow();

        crset2.beforeFirst();
        while (crset2.next()) {
            if (crset2.getInt(1) == 4) {
                assertTrue(crset2.rowDeleted());
            }
        }
View Full Code Here

        assertEquals(3, crset.getInt(1));
        assertFalse(crset.next());

        // deep copy
        CachedRowSet copyCrset = crset.createCopy();
        copyCrset.beforeFirst();
        assertTrue(copyCrset.next());
        assertEquals(3, copyCrset.getInt(1));
        assertFalse(copyCrset.next());
        copyCrset.execute();
        assertTrue(copyCrset.next());
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.