Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

432
433
434
435
436
437
438
439
440
441
442
    try
    {
      stmt = c.prepareCall("{ call sp_helpindex ? }");
      stmt.setString(1, oi.getSimpleName());
      rs = stmt.executeQuery();
    }
    catch (java.sql.SQLException e)
    {
      s_log.error("getTableConstraints: Unexpected exception - " + e.getMessage(), e);
      // no indexes, i guess.
View Full Code Here
504
505
506
507
508
509
510
511
512
513
514
    try
    {
      stmt = c.prepareCall("{ call sp_helptrigger ? }");
      stmt.setString(1, oi.getSimpleName());
      rs = stmt.executeQuery();
    }
    catch (java.sql.SQLException e)
    {
      s_log.error("generateCreateTriggersScript: Unexpected exception - " + e.getMessage(), e);
      // no triggers, i guess.
View Full Code Here
542
543
544
545
546
547
548
549
550
551
552
    try
    {
      stmt = c.prepareCall("{ call sp_helprotect ? }");
      stmt.setString(1, MssqlIntrospector.getFixedVersionedObjectName(oi.getSimpleName()));
      rs = stmt.executeQuery();
    }
    catch (java.sql.SQLException e)
    {
      s_log.error("generatePermissionsScript: Unexpected exception - " + e.getMessage(), e);
      // no permissions, i guess.
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
    {
        CallableStatement cs =
            getConnection().prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 0);
        try {
            cs.executeQuery();
            fail("executeQuery() didn't fail.");
        } catch (SQLException sqle) {
            assertNoResultSetFromExecuteQuery(sqle);
        }
        cs.close();
View Full Code Here
266
267
268
269
270
271
272
273
274
275
276
        throws SQLException
    {
        CallableStatement cs =
            getConnection().prepareCall("CALL RETRIEVE_DYNAMIC_RESULTS(?)");
        cs.setInt(1, 1);
        ResultSet rs = cs.executeQuery();
        assertNotNull("executeQuery() returned null.", rs);
        assertTrue("Result set has no data.", rs.next());
        rs.close();
        cs.close();
    }
View Full Code Here
285
286
287
288
289
290
291
292
293
294
295
    {
        CallableStatement cs =
            getConnection().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
379
380
381
382
383
384
385
386
387
388
389
      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
402
403
404
405
406
407
408
409
410
411
412
      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
50
51
52
53
54
55
56
57
58
59
60
            em.getTransaction().commit();

            cs = connection.prepareCall("{call GetSearchedCourses(?, ?)}");
            cs.setString(1, searchKey);
            cs.setInt(2, 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
64
65
66
67
68
69
70
71
72
73
74
                    eM.getTransaction().commit();
                   
                   
                    cs = connection.prepareCall("{call GetSemanticCourses(?)}");
                    cs.setInt(1, 1);
                    ResultSet rs = cs.executeQuery();

            while (rs.next()) {
                String courseid = rs.getString("courseid");
                System.out.println("courseID" + ": " + courseid);
            }
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.