Package java.sql

Examples of java.sql.CallableStatement.executeQuery()

1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
      conn = dataSource.getConnection();
      stmt = conn.prepareCall("call reduceTag(?,?)");
      for(Tag t : tags){
        stmt.setInt(1,t.getId());
        stmt.setInt(2,user.getId());
        rs = stmt.executeQuery();
      }     
      while(rs.next()){
        Bookmark bm = BookmarkDBDao.createBookmarkObject2(rs);
        changeBookmarks.add(bm);
      }
View Full Code Here
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
      stmt = conn.prepareCall("call pageLinkTagSortByFreq(?,?,?,?)");
      stmt.setInt(1,link.getId());
      stmt.setInt(2,offset);
      stmt.setInt(3,count);
      stmt.registerOutParameter(4,Types.INTEGER);
      ResultSet rs = stmt.executeQuery();
      while(rs.next()){
        LinkTag linktag =createLinkTagObject(rs);
        tags.add(linktag);
        logger.debug("found: " + linktag);
      }
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
    //create a callable statement with hold cursor over commit using reflection.
    Method sh = conn.getClass().getMethod("prepareCall", PREP_STMT_PARAM);
    cs = (CallableStatement) (sh.invoke(conn, PREP_STMT_ARG));
    cs.setInt(1,1);
    rs = cs.executeQuery();

    System.out.println("do next() before commit");
    rs.next();
    System.out.println("look at first column's value: " + rs.getInt(1));
    conn.commit();
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
    {
        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);
        }
    }
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
        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
283
284
285
286
287
288
289
290
291
292
293
    {
        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
66
67
68
69
70
71
72
73
74
75
76
        }
        System.out.println("Stats:"+stats);
       
        for (int i=0; i<count; i++) {
            CallableStatement st = con.prepareCall(slowSql);
            ResultSet rs = st.executeQuery();
            rs.close();
            st.close();
        }
        System.out.println("Stats:"+stats);
        ConnectionPool pool = datasource.getPool();
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
        }
        System.out.println("Stats:"+stats);
       
        for (int i=0; i<count; i++) {
            CallableStatement st = con.prepareCall(slowSql);
            ResultSet rs = st.executeQuery();
            rs.close();
            st.close();
        }
        System.out.println("Stats:"+stats);
        assertEquals("Expecting to have received "+(2*count)+" notifications.",2*count, listener.notificationCount);
View Full Code Here
374
375
376
377
378
379
380
381
382
383
384
        res = statement.executeQuery(translatedQuery);
      }
      else
      {
        final PreparedStatement pstmt = (PreparedStatement) statement;
        res = pstmt.executeQuery();
      }
    }
    finally
    {
      currentRunningStatement = null;
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
            ResultSet rs = c.getResultSet();

            rs.next();
            assertEquals(value, 2);

            rs = c.executeQuery();

            rs.next();
            assertEquals(value, 2);
        } catch (Exception e) {
            assertTrue("unexpected error", false);
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.