Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

49
50
51
52
53
54
55
56
57
58
59
            em.getTransaction().commit();

            cs = connection.prepareCall("{call GetSemanticCourses(?)}");
            cs.setInt(1, userID);
            ResultSet rs = cs.executeQuery();

            courseList = new ArrayList<Integer>();
            while (rs.next()) {
                String courseid = rs.getString("courseid");
                courseList.add(new Integer(Integer.parseInt(courseid)));
View Full Code Here
239
240
241
242
243
244
245
246
247
248
249
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 0);
        try {
            cs.executeQuery();
            fail("executeQuery() didn't fail.");
        } catch (SQLException sqle) {
            assertNoResultSetFromExecuteQuery(sqle);
        }
    }
View Full Code Here
258
259
260
261
262
263
264
265
266
267
268
        throws SQLException
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 1);
        ResultSet rs = cs.executeQuery();
        assertNotNull("executeQuery() returned null.", rs);
        assertSame(cs, rs.getStatement());
        JDBC.assertDrainResultsHasData(rs);
    }
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 2);
        try {
            cs.executeQuery();
            fail("executeQuery() didn't fail.");
        } catch (SQLException sqle) {
            assertMultipleResultsFromExecuteQuery(sqle);
        }
    }
View Full Code Here
378
379
380
381
382
383
384
385
386
387
388
      System.out.println("Standard parsing/execution: " + elapsedTime
          + " ms");

      storedProc = this.conn.prepareCall("{call testSpParse(?)}");
      storedProc.setString(1, "abc");
      this.rs = storedProc.executeQuery();

      assertTrue(this.rs.next());
      assertTrue(this.rs.getInt(1) == 1);

      Properties props = new Properties();
View Full Code Here
401
402
403
404
405
406
407
408
409
410
411
      System.out.println("Cached parse stage: " + elapsedTime + " ms");

      storedProc = cachedSpConn.prepareCall("{call testSpParse(?)}");
      storedProc.setString(1, "abc");
      this.rs = storedProc.executeQuery();

      assertTrue(this.rs.next());
      assertTrue(this.rs.getInt(1) == 1);

    }
View Full Code Here
237
238
239
240
241
242
243
244
245
246
247
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 0);
        try {
            cs.executeQuery();
            fail("executeQuery() didn't fail.");
        } catch (SQLException sqle) {
            assertNoResultSetFromExecuteQuery(sqle);
        }
    }
View Full Code Here
256
257
258
259
260
261
262
263
264
265
266
        throws SQLException
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 1);
        ResultSet rs = cs.executeQuery();
        assertNotNull("executeQuery() returned null.", rs);
        assertSame(cs, rs.getStatement());
        JDBC.assertDrainResultsHasData(rs);
    }
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
    {
        CallableStatement cs =
            prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 2);
        try {
            cs.executeQuery();
            fail("executeQuery() didn't fail.");
        } catch (SQLException sqle) {
            assertMultipleResultsFromExecuteQuery(sqle);
        }
    }
View Full Code Here
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
    {
        createTableT1();
        CallableStatement callStmt = prepareCall(
                "select * from t1",
                ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = callStmt.executeQuery();
        assertEquals("FAIL - wrong result set type",
                ResultSet.TYPE_FORWARD_ONLY, callStmt.getResultSetType());
        assertEquals("FAIL - wrong result set concurrency",
                ResultSet.CONCUR_UPDATABLE, callStmt.getResultSetConcurrency());
        assertTrue("FAIL - statement should return a row", rs.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.