List of usage examples for java.sql Types BIGINT
int BIGINT
To view the source code for java.sql Types BIGINT.
Click Source Link
The constant in the Java programming language, sometimes referred to as a type code, that identifies the generic SQL type BIGINT
.
From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxOracle.CFEnSyntaxOracleEnComplementTable.java
public void deleteEnComplementByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) { final String S_ProcName = "deleteEnComplementByScopeIdx"; ResultSet resultSet = null;/* w ww . j av a 2 s . c o m*/ try { Connection cnx = schema.getCnx(); String sql = "begin call " + schema.getLowerDbSchemaName() + ".dl_encomplbyscopeidx( ?, ?, ?, ?, ?" + ", " + "?" + " ); end"; if (stmtDeleteByScopeIdx == null) { stmtDeleteByScopeIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (argScopeId != null) { stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue()); } else { stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT); } int rowsUpdated = stmtDeleteByScopeIdx.executeUpdate(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxOracle.CFEnSyntaxOracleEnDeterminerTable.java
public void deleteEnDeterminerByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) { final String S_ProcName = "deleteEnDeterminerByScopeIdx"; ResultSet resultSet = null;/* w w w.ja v a 2s . com*/ try { Connection cnx = schema.getCnx(); String sql = "begin call " + schema.getLowerDbSchemaName() + ".dl_endeterbyscopeidx( ?, ?, ?, ?, ?" + ", " + "?" + " ); end"; if (stmtDeleteByScopeIdx == null) { stmtDeleteByScopeIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (argScopeId != null) { stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue()); } else { stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT); } int rowsUpdated = stmtDeleteByScopeIdx.executeUpdate(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxOracle.CFEnSyntaxOracleEnPrepositionTable.java
public void deleteEnPrepositionByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) { final String S_ProcName = "deleteEnPrepositionByScopeIdx"; ResultSet resultSet = null;/*from ww w . j a v a 2s . co m*/ try { Connection cnx = schema.getCnx(); String sql = "begin call " + schema.getLowerDbSchemaName() + ".dl_enprepbyscopeidx( ?, ?, ?, ?, ?" + ", " + "?" + " ); end"; if (stmtDeleteByScopeIdx == null) { stmtDeleteByScopeIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (argScopeId != null) { stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue()); } else { stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT); } int rowsUpdated = stmtDeleteByScopeIdx.executeUpdate(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfensyntax.v2_2.CFEnSyntaxOracle.CFEnSyntaxOracleEnIntensifierTable.java
public void deleteEnIntensifierByScopeIdx(CFEnSyntaxAuthorization Authorization, Long argScopeId) { final String S_ProcName = "deleteEnIntensifierByScopeIdx"; ResultSet resultSet = null;/*from w w w.j av a 2s . c o m*/ try { Connection cnx = schema.getCnx(); String sql = "begin call " + schema.getLowerDbSchemaName() + ".dl_enintensbyscopeidx( ?, ?, ?, ?, ?" + ", " + "?" + " ); end"; if (stmtDeleteByScopeIdx == null) { stmtDeleteByScopeIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtDeleteByScopeIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtDeleteByScopeIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (argScopeId != null) { stmtDeleteByScopeIdx.setLong(argIdx++, argScopeId.longValue()); } else { stmtDeleteByScopeIdx.setNull(argIdx++, java.sql.Types.BIGINT); } int rowsUpdated = stmtDeleteByScopeIdx.executeUpdate(); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlAccountTable.java
public void updateAccount(CFAccAuthorization Authorization, CFAccAccountBuff Buff) { final String S_ProcName = "updateAccount"; ResultSet resultSet = null;//from w ww. j a va 2 s .c o m try { long TenantId = Buff.getRequiredTenantId(); long Id = Buff.getRequiredId(); String AccountCode = Buff.getRequiredAccountCode(); String Description = Buff.getRequiredDescription(); short CurrencyId = Buff.getRequiredCurrencyId(); BigDecimal Balance = Buff.getRequiredBalance(); Long RollupTenantId = Buff.getOptionalRollupTenantId(); Long RollupAccountId = Buff.getOptionalRollupAccountId(); int Revision = Buff.getRequiredRevision(); Connection cnx = schema.getCnx(); String sql = "call " + schema.getLowerSchemaDbName() + ".sp_update_acct( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + ", " + "?" + " )"; if (stmtUpdateByPKey == null) { stmtUpdateByPKey = cnx.prepareStatement(sql); } int argIdx = 1; stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtUpdateByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtUpdateByPKey.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtUpdateByPKey.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); stmtUpdateByPKey.setString(argIdx++, "ACCT"); stmtUpdateByPKey.setLong(argIdx++, TenantId); stmtUpdateByPKey.setLong(argIdx++, Id); stmtUpdateByPKey.setString(argIdx++, AccountCode); stmtUpdateByPKey.setString(argIdx++, Description); stmtUpdateByPKey.setShort(argIdx++, CurrencyId); stmtUpdateByPKey.setBigDecimal(argIdx++, Balance); if (RollupTenantId != null) { stmtUpdateByPKey.setLong(argIdx++, RollupTenantId.longValue()); } else { stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.BIGINT); } if (RollupAccountId != null) { stmtUpdateByPKey.setLong(argIdx++, RollupAccountId.longValue()); } else { stmtUpdateByPKey.setNull(argIdx++, java.sql.Types.BIGINT); } stmtUpdateByPKey.setInt(argIdx++, Revision); try { resultSet = stmtUpdateByPKey.executeQuery(); } catch (SQLException e) { if (e.getErrorCode() != 1329) { throw e; } resultSet = null; } if ((resultSet != null) && resultSet.next()) { CFAccAccountBuff updatedBuff = unpackAccountResultSetToBuff(resultSet); if ((resultSet != null) && resultSet.next()) { resultSet.last(); throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response, " + resultSet.getRow() + " rows selected"); } Buff.setRequiredAccountCode(updatedBuff.getRequiredAccountCode()); Buff.setRequiredDescription(updatedBuff.getRequiredDescription()); Buff.setRequiredCurrencyId(updatedBuff.getRequiredCurrencyId()); Buff.setRequiredBalance(updatedBuff.getRequiredBalance()); Buff.setOptionalRollupTenantId(updatedBuff.getOptionalRollupTenantId()); Buff.setOptionalRollupAccountId(updatedBuff.getOptionalRollupAccountId()); Buff.setRequiredRevision(updatedBuff.getRequiredRevision()); } else { throw CFLib.getDefaultExceptionFactory().newRuntimeException(getClass(), S_ProcName, "Expected a single-record response, " + resultSet.getRow() + " rows selected"); } } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccOracle.CFAccOracleAccountConfigTable.java
public CFAccAccountConfigBuff[] readBuffByCustCtcLstIdx(CFAccAuthorization Authorization, Long CustContactListTenantId, Long CustContactListId) { final String S_ProcName = "readBuffByCustCtcLstIdx"; ResultSet resultSet = null;/*from w w w . j a va2 s .c om*/ Connection cnx = schema.getCnx(); CallableStatement stmtReadBuffByCustCtcLstIdx = null; List<CFAccAccountConfigBuff> buffList = new LinkedList<CFAccAccountConfigBuff>(); try { stmtReadBuffByCustCtcLstIdx = cnx.prepareCall("begin " + schema.getLowerSchemaDbName() + ".rd_acct_cfgbycustctclstidx( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ); end;"); int argIdx = 1; stmtReadBuffByCustCtcLstIdx.registerOutParameter(argIdx++, OracleTypes.CURSOR); stmtReadBuffByCustCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByCustCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtReadBuffByCustCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtReadBuffByCustCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByCustCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (CustContactListTenantId != null) { stmtReadBuffByCustCtcLstIdx.setLong(argIdx++, CustContactListTenantId.longValue()); } else { stmtReadBuffByCustCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } if (CustContactListId != null) { stmtReadBuffByCustCtcLstIdx.setLong(argIdx++, CustContactListId.longValue()); } else { stmtReadBuffByCustCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } stmtReadBuffByCustCtcLstIdx.execute(); resultSet = (ResultSet) stmtReadBuffByCustCtcLstIdx.getObject(1); if (resultSet != null) { try { while (resultSet.next()) { CFAccAccountConfigBuff buff = unpackAccountConfigResultSetToBuff(resultSet); buffList.add(buff); } try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } catch (SQLException e) { } } int idx = 0; CFAccAccountConfigBuff[] retBuff = new CFAccAccountConfigBuff[buffList.size()]; Iterator<CFAccAccountConfigBuff> iter = buffList.iterator(); while (iter.hasNext()) { retBuff[idx++] = iter.next(); } return (retBuff); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } if (stmtReadBuffByCustCtcLstIdx != null) { try { stmtReadBuffByCustCtcLstIdx.close(); } catch (SQLException e) { } stmtReadBuffByCustCtcLstIdx = null; } } }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccMySql.CFAccMySqlAccountConfigTable.java
public CFAccAccountConfigBuff[] readBuffByEmpCtcLstIdx(CFAccAuthorization Authorization, Long EmpContactListTenantId, Long EmpContactListId) { final String S_ProcName = "readBuffByEmpCtcLstIdx"; ResultSet resultSet = null;/*www . j ava 2 s .co m*/ try { Connection cnx = schema.getCnx(); String sql = "call " + schema.getLowerSchemaDbName() + ".sp_read_acct_cfg_by_empctclstidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )"; if (stmtReadBuffByEmpCtcLstIdx == null) { stmtReadBuffByEmpCtcLstIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtReadBuffByEmpCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByEmpCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtReadBuffByEmpCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtReadBuffByEmpCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByEmpCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (EmpContactListTenantId != null) { stmtReadBuffByEmpCtcLstIdx.setLong(argIdx++, EmpContactListTenantId.longValue()); } else { stmtReadBuffByEmpCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } if (EmpContactListId != null) { stmtReadBuffByEmpCtcLstIdx.setLong(argIdx++, EmpContactListId.longValue()); } else { stmtReadBuffByEmpCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } try { resultSet = stmtReadBuffByEmpCtcLstIdx.executeQuery(); } catch (SQLException e) { if (e.getErrorCode() != 1329) { throw e; } resultSet = null; } List<CFAccAccountConfigBuff> buffList = new LinkedList<CFAccAccountConfigBuff>(); while ((resultSet != null) && resultSet.next()) { CFAccAccountConfigBuff buff = unpackAccountConfigResultSetToBuff(resultSet); buffList.add(buff); } int idx = 0; CFAccAccountConfigBuff[] retBuff = new CFAccAccountConfigBuff[buffList.size()]; Iterator<CFAccAccountConfigBuff> iter = buffList.iterator(); while (iter.hasNext()) { retBuff[idx++] = iter.next(); } return (retBuff); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccDb2LUW.CFAccDb2LUWAccountConfigTable.java
public CFAccAccountConfigBuff[] readBuffByVendCtcLstIdx(CFAccAuthorization Authorization, Long VendContactListTenantId, Long VendContactListId) { final String S_ProcName = "readBuffByVendCtcLstIdx"; ResultSet resultSet = null;// w w w . j a v a 2 s . c o m try { Connection cnx = schema.getCnx(); final String sql = "CALL sp_read_acct_cfg_by_vendctclstidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )"; if (stmtReadBuffByVendCtcLstIdx == null) { stmtReadBuffByVendCtcLstIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByVendCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtReadBuffByVendCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (VendContactListTenantId != null) { stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, VendContactListTenantId.longValue()); } else { stmtReadBuffByVendCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } if (VendContactListId != null) { stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, VendContactListId.longValue()); } else { stmtReadBuffByVendCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } resultSet = stmtReadBuffByVendCtcLstIdx.executeQuery(); List<CFAccAccountConfigBuff> buffList = new LinkedList<CFAccAccountConfigBuff>(); while (resultSet.next()) { CFAccAccountConfigBuff buff = unpackAccountConfigResultSetToBuff(resultSet); buffList.add(buff); } int idx = 0; CFAccAccountConfigBuff[] retBuff = new CFAccAccountConfigBuff[buffList.size()]; Iterator<CFAccAccountConfigBuff> iter = buffList.iterator(); while (iter.hasNext()) { retBuff[idx++] = iter.next(); } return (retBuff); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }
From source file:com.mirth.connect.donkey.test.util.TestUtils.java
private static String typeToString(int sqlType) { switch (sqlType) { case Types.ARRAY: return "ARRAY"; case Types.BIGINT: return "BIGINT"; case Types.BINARY: return "BINARY"; case Types.BIT: return "BIT"; case Types.BLOB: return "BLOB"; case Types.BOOLEAN: return "BOOLEAN"; case Types.CHAR: return "CHAR"; case Types.CLOB: return "CLOB"; case Types.DATALINK: return "DATALINK"; case Types.DATE: return "DATE"; case Types.DECIMAL: return "DECIMAL"; case Types.DISTINCT: return "DISTINCT"; case Types.DOUBLE: return "DOUBLE"; case Types.FLOAT: return "FLOAT"; case Types.INTEGER: return "INTEGER"; case Types.JAVA_OBJECT: return "JAVA_OBJECT"; case Types.LONGNVARCHAR: return "LONGNVARCHAR"; case Types.LONGVARBINARY: return "LONGVARBINARY"; case Types.LONGVARCHAR: return "LONGVARCHAR"; case Types.NCHAR: return "NCHAR"; case Types.NCLOB: return "NCLOB"; case Types.NULL: return "NULL"; case Types.NUMERIC: return "NUMERIC"; case Types.NVARCHAR: return "NVARCHAR"; case Types.OTHER: return "OTHER"; case Types.REAL: return "REAL"; case Types.REF: return "REF"; case Types.ROWID: return "ROWID"; case Types.SMALLINT: return "SMALLINT"; case Types.SQLXML: return "SQLXML"; case Types.STRUCT: return "STRUCT"; case Types.TIME: return "TIME"; case Types.TIMESTAMP: return "TIMESTAMP"; case Types.TINYINT: return "TINYINT"; case Types.VARBINARY: return "VARBINARY"; case Types.VARCHAR: return "VARCHAR"; default://from ww w .j av a 2s . c om return "UNKNOWN"; } }
From source file:net.sourceforge.msscodefactory.cfacc.v2_0.CFAccPgSql.CFAccPgSqlAccountConfigTable.java
public CFAccAccountConfigBuff[] readBuffByVendCtcLstIdx(CFAccAuthorization Authorization, Long VendContactListTenantId, Long VendContactListId) { final String S_ProcName = "readBuffByVendCtcLstIdx"; ResultSet resultSet = null;/* www.j a v a 2s .co m*/ try { Connection cnx = schema.getCnx(); String sql = "SELECT * FROM " + schema.getLowerSchemaDbName() + ".sp_read_acct_cfg_by_vendctclstidx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )"; if (stmtReadBuffByVendCtcLstIdx == null) { stmtReadBuffByVendCtcLstIdx = cnx.prepareStatement(sql); } int argIdx = 1; stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByVendCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString()); stmtReadBuffByVendCtcLstIdx.setString(argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString()); stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId()); stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId()); if (VendContactListTenantId != null) { stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, VendContactListTenantId.longValue()); } else { stmtReadBuffByVendCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } if (VendContactListId != null) { stmtReadBuffByVendCtcLstIdx.setLong(argIdx++, VendContactListId.longValue()); } else { stmtReadBuffByVendCtcLstIdx.setNull(argIdx++, java.sql.Types.BIGINT); } resultSet = stmtReadBuffByVendCtcLstIdx.executeQuery(); List<CFAccAccountConfigBuff> buffList = new LinkedList<CFAccAccountConfigBuff>(); while (resultSet.next()) { CFAccAccountConfigBuff buff = unpackAccountConfigResultSetToBuff(resultSet); buffList.add(buff); } int idx = 0; CFAccAccountConfigBuff[] retBuff = new CFAccAccountConfigBuff[buffList.size()]; Iterator<CFAccAccountConfigBuff> iter = buffList.iterator(); while (iter.hasNext()) { retBuff[idx++] = iter.next(); } return (retBuff); } catch (SQLException e) { throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e); } finally { if (resultSet != null) { try { resultSet.close(); } catch (SQLException e) { } resultSet = null; } } }