Package javax.sql.rowset

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

864
865
866
867
868
869
870
871
872
873
874
    public void testAutoCommit_False() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();

        jrs.setAutoCommit(false);
        assertFalse(jrs.getAutoCommit());
        assertTrue(jrs.absolute(3));
        jrs.updateString(2, "update3");
View Full Code Here
256
257
258
259
260
261
262
263
264
265
266
        assertEquals(DERBY_URL, jrs.getUrl());
        assertNull(jrs.getUsername());
        assertNull(jrs.getPassword());

        jrs.execute();

        // after execute
        assertEquals(ResultSet.TYPE_SCROLL_INSENSITIVE, jrs.getType());
        assertTrue(jrs.getEscapeProcessing());
View Full Code Here
297
298
299
300
301
302
303
304
305
306
307
    public void testCursorMove() throws Exception {
        insertMoreData(6);
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();

        jrs.beforeFirst();
        assertTrue(jrs.isBeforeFirst());
        assertTrue(jrs.next());
        assertTrue(jrs.first());
View Full Code Here
338
339
340
341
342
343
344
345
346
347
348
    public void testExecute() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setUrl("bad url");

        try {
            jrs.execute();
            fail("Should SQLException");
        } catch (SQLException e) {
            // expected, No suitable driver
        }
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
            // expected, No suitable driver
        }

        jrs = newJdbcRowSet();
        try {
            jrs.execute();
            fail("should throw NullPointerException");
        } catch (NullPointerException e) {
            // expected
        }
        jrs.setUrl(DERBY_URL);
View Full Code Here
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
    public void testAfterClose() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.setUrl(DERBY_URL);
        jrs.execute();
        jrs.close();

        try {
            jrs.absolute(1);
            fail("Should throw NullPointerException");
View Full Code Here
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
            fail("Shuld throw NullPointerException since jrs has not been executed.");
        } catch (NullPointerException e) {
            // Expected.
        }

        jrs.execute();
        assertTrue(jrs.absolute(4));
        assertEquals(4, jrs.getInt(1));

        // Inserts a new row.
        jrs.moveToInsertRow();
View Full Code Here
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
            fail("Shuld throw NullPointerException since jrs has not been executed.");
        } catch (NullPointerException e) {
            // Expected.
        }

        jrs.execute();
        assertTrue(jrs.absolute(4));
        assertEquals(4, jrs.getInt(1));

        // Inserts a new row.
        jrs.moveToInsertRow();
View Full Code Here
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
        // Reconnect
        jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();
        assertTrue(jrs.last());
        assertEquals(
                "Since the insert action was roll back, so the last row is 5, not 6.",
                5, jrs.getInt(1));

View Full Code Here
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
     */
    public void testRollbackException() throws Exception {
        JdbcRowSet jrs = newJdbcRowSet();
        jrs.setUrl(DERBY_URL);
        jrs.setCommand("SELECT * FROM USER_INFO");
        jrs.execute();

        // Tests if jrs has the same behaviour with connection when commit in
        // auto-commit mode.
        boolean hasRollbackException = true;

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.