Package java.sql

Examples of java.sql.CallableStatement.execute()

112
113
114
115
116
117
118
119
120
121
122
        cStmt.setTimestamp(5, new Timestamp(pubDate.getTime()));
      }else{
        cStmt.setTimestamp(5, null);
      }
      cStmt.registerOutParameter(6,Types.INTEGER);
      cStmt.execute();
      id = cStmt.getInt(6);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
View Full Code Here
379
380
381
382
383
384
385
386
387
388
389
    Connection conn = null;
    try{           
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("call findAutoImportSubscription(?);");     
      cStmt.setInt(1,ageHour);
      cStmt.execute();
      ResultSet rs = cStmt.executeQuery();
      while(rs.next()){
        FeedSubscription feed = createFeedSubscriptionObject(rs);       
        feeds.add(feed);
      }   
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
      cStmt.setString(3,user.getFullname());
      cStmt.setString(4,user.getEmail());
      cStmt.setTimestamp(5,new Timestamp(user.getCreatedOn().getTime()));
      cStmt.setInt(6,user.getAccountStatus());
      cStmt.registerOutParameter(7,Types.INTEGER);
      cStmt.execute();
      userId = cStmt.getInt(7);
    }catch(Exception e){
      logger.error(e);
    }finally{
      try {     
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("{call createLink(?,?,?)}");
      cStmt.setString(1,link.getUrl());
      cStmt.setInt(2,link.getMimeTypeId());
      cStmt.registerOutParameter(3,Types.INTEGER);
      cStmt.execute();
      id = cStmt.getInt(3);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
View Full Code Here
228
229
230
231
232
233
234
235
236
237
238
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("{call hasForUser(?,?,?)}");
      cStmt.setInt(1,bookmark.getId());
      cStmt.setInt(2,user.getId());
      cStmt.registerOutParameter(3,Types.INTEGER);
      cStmt.execute();
      count = cStmt.getInt(3);
      if (count > 0) found = true;
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
    try {
      conn = dataSource.getConnection();
      cStmt = conn.prepareCall("{call getForUserCount(?,?)}");
      cStmt.setInt(1, user.getId());
      cStmt.registerOutParameter(2,Types.INTEGER);
      cStmt.execute();
      count = cStmt.getInt(2);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
View Full Code Here
359
360
361
362
363
364
365
366
367
368
369
      cStmt = conn.prepareCall("{call getForUserInTimeRangeCount(?,?,?,?)}");
      cStmt.setInt(1, user.getId());
      cStmt.setTimestamp(2,new Timestamp(start.getTime()));
      cStmt.setTimestamp(3,new Timestamp(end.getTime()));
      cStmt.registerOutParameter(4,Types.INTEGER);
      cStmt.execute();
      count = cStmt.getInt(4);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
      cStmt.setInt(1,folder.getUser().getId());
      cStmt.setString(2,folder.getName());
      cStmt.setString(3,folder.getDescription());
      cStmt.setTimestamp(4,new Timestamp(folder.getLastUpdated().getTime()));
      cStmt.registerOutParameter(5,Types.INTEGER);
      cStmt.execute();
      id = cStmt.getInt(5);
    } catch (Exception e) {
      logger.fatal(e);
    } finally{
      try {
View Full Code Here
337
338
339
340
341
342
343
344
345
346
347
        sSQL = "{call k_sp_count_thread_msgs(?,?)}";
        if (DebugFile.trace) DebugFile.writeln("CallableStatement.prepareCall(" + sSQL + ")");
        oCall = oConn.prepareCall(sSQL);
        oCall.setString(1, getString(DB.gu_thread_msg));
        oCall.registerOutParameter(2, Types.INTEGER);
        oCall.execute();
        nThreadMsgs = oCall.getInt(2);
        oCall.close();
    }

    if (bNewMsg) replace(DB.nu_thread_msgs, ++nThreadMsgs);
View Full Code Here
503
504
505
506
507
508
509
510
511
512
513
    } // fi

    sSQL = "{ call k_sp_del_newsmsg ('" + getString(DB.gu_msg) + "') }";
    if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall(" + sSQL + ")");
    oCall = oConn.prepareCall(sSQL);
    oCall.execute();
    oCall.close();

    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End NewsMessage.delete() : 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.