List of usage examples for java.sql CallableStatement close
void close() throws SQLException;
Statement
object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleURLProtocolTable.java
public void deleteURLProtocol(CFAccAuthorization Authorization, CFAccURLProtocolBuff Buff) { final String S_ProcName = "deleteURLProtocol"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {//from w ww .j a va 2s . c o m short URLProtocolId = Buff.getRequiredURLProtocolId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerSchemaDbName() + ".dl_urlproto( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setShort(argIdx++, URLProtocolId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_0.CFAstOracle.CFAstOracleURLProtocolTable.java
public void deleteURLProtocol(CFAstAuthorization Authorization, CFAstURLProtocolBuff Buff) { final String S_ProcName = "deleteURLProtocol"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {//from w w w. j a v a2 s. c o m short URLProtocolId = Buff.getRequiredURLProtocolId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerSchemaDbName() + ".dl_urlproto( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setShort(argIdx++, URLProtocolId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_1.CFAstOracle.CFAstOracleURLProtocolTable.java
public void deleteURLProtocol(CFAstAuthorization Authorization, CFAstURLProtocolBuff Buff) { final String S_ProcName = "deleteURLProtocol"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {// ww w . ja v a 2 s. com short URLProtocolId = Buff.getRequiredURLProtocolId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerDbSchemaName() + ".dl_urlproto( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setShort(argIdx++, URLProtocolId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_4.CFAsteriskOracle.CFAsteriskOracleTldTable.java
public void deleteTld(CFSecurityAuthorization Authorization, CFInternetTldBuff Buff) { final String S_ProcName = "deleteTld"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {//w ww .ja va 2 s .c o m long TenantId = Buff.getRequiredTenantId(); long TldId = Buff.getRequiredTldId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerDbSchemaName() + ".dl_tlddef( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, TenantId); stmtDeleteByPKey.setLong(argIdx++, TldId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:com.ing.connector.newbus.WPendingOverridesImpl.java
/** * This method will query the database and create an Odd string that * represents the collection of agent overrides. *///from w ww . j a va 2 s. c o m public WResult getObject(WObjectKeys keys) { String policyId = keys.getStringKey(1); String agentSystemSource = keys.getStringKey(2); //JFG2.0 String companyId = keys.getStringKey(3); //JFG4.0 String agentParm = keys.getStringKey(4); //CSST400 String driverSystemSource = getDriver().getSystemSource(); //JFG2.0 String driverTableType = getDriver().getTableType(); //DIL3.0 String databaseName = "scldbali"; //DIL3.0 String procedureName = null; //DIL3.0 String userType = keys.getStringKey(5); String agentName; com.ing.connector.Registrar.logInfoMessage("wpendingoverridesimpl - userType" + userType); WResult result = new WResult(); WCollection collection = new WCollection("com.ing.connector.model.WAgentOverrideExt"); result.setModelObject(collection); if (!agentSystemSource.equals(driverSystemSource)) //JFG2.0 { result.setStatus(WResult.OBJECT_NOT_FOUND); return result; } if (userType != null && userType.equalsIgnoreCase("internalUser")) databaseName = LookUp.getInstance().getStringProperty("Connector.History.Database"); ; // March 2004 deleted int connNo = line Connection con = getConnection(); // March 2004 removed param if (driverTableType.equals(TABLETYPECOPY)) //DIL3.0 { //DIL3.0 procedureName = "bali_WAgentOverrides_get_p"; //DIL3.0 } //DIL3.0 else //DIL3.0 { //DIL3.0 //databaseName = "scldpt"; //RL-004454 RSD procedureName = "bali_WAgentOverridesImpl"; //DIL3.0 } //DIL3.0 com.ing.connector.Registrar.logInfoMessage("wpendingoverridesimpl - databaseName" + databaseName); com.ing.connector.Registrar.logInfoMessage("wpendingoverridesimpl - procedureName" + procedureName); try { Statement stmt = con.createStatement(); //DIL3.0 stmt.execute("use " + "scldpt"); stmt.execute("use " + databaseName); Registrar.logInfoMessage("exec " + procedureName + " " + policyId + "," + agentParm); //DIL3.0 CallableStatement cstmt = con.prepareCall("{call bali_WAgentOverridesImpl(?)}"); CallableStatement cstmt = con.prepareCall("{call " + procedureName + "(?,?)}"); //CSST400 cstmt.setString(1, policyId); cstmt.setString(2, agentParm); //CSST400 ResultSet rs = cstmt.executeQuery(); WDateIsoFormat isoFormat = new WDateIsoFormat(); while (rs.next()) { WAgentOverrideExt single = new WAgentOverrideExt(getDriverName(), getImplTypeName()); single.setAgentId(rs.getString("agent_number")); agentName = new String(rs.getString("agent_name")); //RL-009402 - SXL - START String formattedAgentName = WStringUtil.formatAgentName(agentName); single.setFormattedAgentName(formattedAgentName); if (StringUtils.countMatches(agentName, ",") == 2) { String lastName = agentName.substring(0, agentName.indexOf(",")).trim(); String firstName = (agentName.substring(agentName.indexOf(",") + 1, agentName.lastIndexOf(","))) .trim(); String middleName = (agentName.substring(agentName.lastIndexOf(",") + 1)).trim(); single.setLastName(lastName); single.setFirstName(firstName); single.setMiddleName(middleName); } else { //RL-009402 - SXL - END int i = agentName.indexOf(','); if (i != -1) { single.setLastName(agentName.substring(0, i).trim()); single.setFirstName(agentName.substring(i + 1).trim()); } else { single.setLastName(agentName); } } single.setOverridePercent(rs.getDouble("commission_split")); single.setContractType(rs.getString("agent_contract_typ")); single.setOverrideId(rs.getString("ovr_agent_number")); //CSST400 single.setOverrideAgentName(rs.getString("ovr_agent_name")); // KLN/02/13/07//RL-001655 single.setLevel(rs.getString("Hierarchy_Type")); //RL-005642 LXJ added collection.addElement(single); } rs.close(); cstmt.close(); stmt.close(); result.setModelObject(collection); if (collection.size() == 0) { result.setStatus(WResult.OBJECT_NOT_FOUND); } } catch (SQLException sqle) { result.setException(sqle); com.ing.connector.Registrar.logError(getClass().getName() + ": " + sqle.getMessage()); } catch (Exception exc) { result.setException(exc); com.ing.connector.Registrar.logError(getClass().getName() + ": " + exc.getMessage()); } releaseConnection(con); //March 2004 changed param from connNo to con return result; }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleTldTable.java
public void deleteTld(CFAccAuthorization Authorization, CFAccTldBuff Buff) { final String S_ProcName = "deleteTld"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {//from ww w . ja va 2s. c om long TenantId = Buff.getRequiredTenantId(); long TLDId = Buff.getRequiredTLDId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerSchemaDbName() + ".dl_tlddef( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, TenantId); stmtDeleteByPKey.setLong(argIdx++, TLDId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_0.CFAstOracle.CFAstOracleTldTable.java
public void deleteTld(CFAstAuthorization Authorization, CFAstTldBuff Buff) { final String S_ProcName = "deleteTld"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {/*from w w w.j ava2s. co m*/ long TenantId = Buff.getRequiredTenantId(); long TLDId = Buff.getRequiredTLDId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerSchemaDbName() + ".dl_tlddef( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, TenantId); stmtDeleteByPKey.setLong(argIdx++, TLDId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_1.CFAstOracle.CFAstOracleTldTable.java
public void deleteTld(CFAstAuthorization Authorization, CFAstTldBuff Buff) { final String S_ProcName = "deleteTld"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {//from w w w . j av a2 s. c o m long TenantId = Buff.getRequiredTenantId(); long TldId = Buff.getRequiredTldId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerDbSchemaName() + ".dl_tlddef( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, TenantId); stmtDeleteByPKey.setLong(argIdx++, TldId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_4.CFAsteriskOracle.CFAsteriskOracleSecGroupTable.java
public void deleteSecGroup(CFSecurityAuthorization Authorization, CFSecuritySecGroupBuff Buff) { final String S_ProcName = "deleteSecGroup"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {// w w w . j a va 2 s.c o m long ClusterId = Buff.getRequiredClusterId(); int SecGroupId = Buff.getRequiredSecGroupId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerDbSchemaName() + ".dl_secgrp( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, ClusterId); stmtDeleteByPKey.setInt(argIdx++, SecGroupId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }
From source file:net.sourceforge.msscodefactory.cfasterisk.v2_4.CFAsteriskOracle.CFAsteriskOracleSecAppTable.java
public void deleteSecApp(CFSecurityAuthorization Authorization, CFSecuritySecAppBuff Buff) { final String S_ProcName = "deleteSecApp"; Connection cnx = schema.getCnx(); CallableStatement stmtDeleteByPKey = null; try {/* w ww .j a va2 s . c o m*/ long ClusterId = Buff.getRequiredClusterId(); int SecAppId = Buff.getRequiredSecAppId(); stmtDeleteByPKey = cnx.prepareCall("begin " + schema.getLowerDbSchemaName() + ".dl_secapp( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtDeleteByPKey.setLong(argIdx++, ClusterId); stmtDeleteByPKey.setInt(argIdx++, SecAppId); stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision()); ; stmtDeleteByPKey.execute(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (stmtDeleteByPKey != null) { try { stmtDeleteByPKey.close(); } catch (SQLException e) { } stmtDeleteByPKey = null; } } }