Package java.sql

Examples of java.sql.CallableStatement.execute()

547
548
549
550
551
552
553
554
555
556
557
  public static boolean delete(JDCConnection oConn, String sMeetingGUID) throws SQLException {
    boolean bRetVal;

    CallableStatement oCall = oConn.prepareCall("{call k_sp_del_meeting ('" + sMeetingGUID + "')}");
    bRetVal = oCall.execute();
    oCall.close();

    return bRetVal;
  } // delete
View Full Code Here
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
            sSQL = aStatements[s];
            if (sSQL.length() > 0) {
              if (null!=oStrLog) oStrLog.append(sSQL + "\n");
              try {
                oCall = oConn.prepareCall(sSQL);
                oCall.execute();
                oCall.close();
                oCall = null;
              }
              catch (SQLException sqle) {
                iErrors++;
View Full Code Here
2075
2076
2077
2078
2079
2080
2081
2082
2083
2084
2085
    while (oRSet.next()) {

      try {
           sAlterSql = oRSet.getString(1);
           oCall = oConn.prepareCall(sAlterSql);
           oCall.execute();
           oCall.close();

           if (null!=oStrLog) oStrLog.append(sAlterSql+"\n");
      }
      catch (SQLException sqle) {
View Full Code Here
360
361
362
363
364
365
366
367
368
369
370
        oCall = oConn.prepareCall("{ call " + sProc + "(?,?,?)}");
        oCall.setString(1, sList);
        oCall.setString(2, sParm);
        oCall.registerOutParameter(3, java.sql.Types.SMALLINT);
        oCall.execute();
        bBlocked = (oCall.getShort(3)!=(short)0);
        oCall.close();
    }

    if (DebugFile.trace) {
View Full Code Here
943
944
945
946
947
948
949
950
951
952
953
      else {
        oCall = oConn.prepareCall("{ call k_sp_del_mime_msg(?) }");

        for (int d=0; d<iDeleted; d++) {
          oCall.setString(1, oDeleted.getString(0,d));
          oCall.execute();
        } // next
        oCall.close();
        oCall=null;
      }
View Full Code Here
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
      else {
        oCall = oConn.prepareCall("{ call k_sp_del_mime_msg(?) }");

        for (int d=0; d<iDeleted; d++) {
          oCall.setString(1, oDeleted.getString(0,d));
          oCall.execute();
        } // next
        oCall.close();
        oCall=null;
      }
View Full Code Here
319
320
321
322
323
324
325
326
327
328
329
      case JDCConnection.DBMS_MSSQL:
      case JDCConnection.DBMS_ORACLE:
        oCall = oConn.prepareCall("{call k_get_domain_id (?,?)}");
        oCall.setString(1, sDomainNm);
        oCall.registerOutParameter(2, java.sql.Types.INTEGER);
        oCall.execute();
        iDomainId = oCall.getInt(2);
        oCall.close();
        oCall = null;
        break;
View Full Code Here
345
346
347
348
349
350
351
352
353
354
355
        bRetVal = true;
        break;
      default:
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_group ('" + sGroupGUID + "') })");
        CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_group ('" + sGroupGUID + "') }");
        bRetVal = oCall.execute();
        oCall.close();
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
1873
1874
1875
1876
1877
1878
1879
1880
1881
1882
1883
        oStmt.close();
      }
      else {
        oCall = oConn.prepareCall("{ call k_sp_del_mime_msg(?) }");
        oCall.setString(1, sMimeMsgId);
        oCall.execute();
        oCall.close();
      }

      if (DebugFile.trace) {
        DebugFile.decIdent();
View Full Code Here
1932
1933
1934
1935
1936
1937
1938
1939
1940
1941
1942
          break;
        default:
          CallableStatement oCall = oConn.prepareCall("{ call k_sp_get_mime_msg(?,?) }");
          oCall.setString(1, sMsgId);
          oCall.registerOutParameter(2, Types.CHAR);
          oCall.execute();
          sMsgGuid = oCall.getString(2);
          if (sMsgGuid!=null) sMsgGuid = sMsgGuid.trim();
          oCall.close();
          oCall = null;
      }
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.