public void forgetSecDeviceByUserIdx(UUID SecUserId) {
if (indexByUserIdx == null) {
return;
}
CFSecuritySecDeviceByUserIdxKey key =
((ICFSecuritySchema) schema.getBackingStore()).getFactorySecDevice().newUserIdxKey();
key.setRequiredSecUserId(SecUserId);
if (indexByUserIdx.containsKey(key)) {
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj> mapUserIdx = indexByUserIdx.get(key);
if (mapUserIdx != null) {
List<ICFSecuritySecDeviceObj> toForget = new LinkedList<ICFSecuritySecDeviceObj>();
ICFSecuritySecDeviceObj cur = null;
Iterator<ICFSecuritySecDeviceObj> iter = mapUserIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByUserIdx.remove(key);
}
}
public CFSecuritySecDeviceBuff[] readBuffByUserIdx(
CFSecurityAuthorization Authorization, UUID SecUserId) {
final String S_ProcName = "readBuffByUserIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_read_secdev_by_useridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByUserIdx == null) {
stmtReadBuffByUserIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUserIdx.setString(argIdx++, SecUserId.toString());
try {
resultSet = stmtReadBuffByUserIdx.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecuritySecDeviceBuff> buffList = new LinkedList<CFSecuritySecDeviceBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecuritySecDeviceBuff buff = unpackSecDeviceResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecuritySecDeviceBuff[] retBuff = new CFSecuritySecDeviceBuff[buffList.size()];
Iterator<CFSecuritySecDeviceBuff> 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;
}
}
}
public void forgetISOCountryCurrencyByCurrencyIdx(short ISOCurrencyId) {
if (indexByCurrencyIdx == null) {
return;
}
CFSecurityISOCountryCurrencyByCurrencyIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newCurrencyIdxKey();
key.setRequiredISOCurrencyId(ISOCurrencyId);
if (indexByCurrencyIdx.containsKey(key)) {
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj> mapCurrencyIdx =
indexByCurrencyIdx.get(key);
if (mapCurrencyIdx != null) {
List<ICFSecurityISOCountryCurrencyObj> toForget =
new LinkedList<ICFSecurityISOCountryCurrencyObj>();
ICFSecurityISOCountryCurrencyObj cur = null;
Iterator<ICFSecurityISOCountryCurrencyObj> iter = mapCurrencyIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByCurrencyIdx.remove(key);
}
}
public void deleteSecDeviceByUserIdx(UUID SecUserId) {
CFSecuritySecDeviceByUserIdxKey key =
((ICFSecuritySchema) schema.getBackingStore()).getFactorySecDevice().newUserIdxKey();
key.setRequiredSecUserId(SecUserId);
if (indexByUserIdx == null) {
indexByUserIdx =
new HashMap<
CFSecuritySecDeviceByUserIdxKey,
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj>>();
}
if (indexByUserIdx.containsKey(key)) {
Map<CFSecuritySecDevicePKey, ICFSecuritySecDeviceObj> dict = indexByUserIdx.get(key);
((ICFSecuritySchema) schema.getBackingStore())
.getTableSecDevice()
.deleteSecDeviceByUserIdx(schema.getAuthorization(), SecUserId);
Iterator<ICFSecuritySecDeviceObj> iter = dict.values().iterator();
ICFSecuritySecDeviceObj obj;
List<ICFSecuritySecDeviceObj> toForget = new LinkedList<ICFSecuritySecDeviceObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByUserIdx.remove(key);
} else {
((ICFSecuritySchema) schema.getBackingStore())
.getTableSecDevice()
.deleteSecDeviceByUserIdx(schema.getAuthorization(), SecUserId);
}
}
public void deleteTaxByTenantIdx(long TenantId) {
CFAccTaxByTenantIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newTenantIdxKey();
key.setRequiredTenantId(TenantId);
if (indexByTenantIdx == null) {
indexByTenantIdx = new HashMap<CFAccTaxByTenantIdxKey, Map<CFAccTaxPKey, ICFAccTaxObj>>();
}
if (indexByTenantIdx.containsKey(key)) {
Map<CFAccTaxPKey, ICFAccTaxObj> dict = indexByTenantIdx.get(key);
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.deleteTaxByTenantIdx(schema.getAuthorization(), TenantId);
Iterator<ICFAccTaxObj> iter = dict.values().iterator();
ICFAccTaxObj obj;
List<ICFAccTaxObj> toForget = new LinkedList<ICFAccTaxObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByTenantIdx.remove(key);
} else {
((ICFAccSchema) schema.getBackingStore())
.getTableTax()
.deleteTaxByTenantIdx(schema.getAuthorization(), TenantId);
}
}
public void forgetDomainBySubDomIdx(long TenantId, long SubDomainOfId) {
if (indexBySubDomIdx == null) {
return;
}
CFInternetDomainBySubDomIdxKey key =
((ICFBamSchema) schema.getBackingStore()).getFactoryDomain().newSubDomIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredSubDomainOfId(SubDomainOfId);
if (indexBySubDomIdx.containsKey(key)) {
Map<CFInternetDomainBasePKey, ICFInternetDomainObj> mapSubDomIdx = indexBySubDomIdx.get(key);
if (mapSubDomIdx != null) {
List<ICFInternetDomainObj> toForget = new LinkedList<ICFInternetDomainObj>();
ICFInternetDomainObj cur = null;
Iterator<ICFInternetDomainObj> iter = mapSubDomIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexBySubDomIdx.remove(key);
}
}
public void forgetTaxByTenantIdx(long TenantId) {
if (indexByTenantIdx == null) {
return;
}
CFAccTaxByTenantIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryTax().newTenantIdxKey();
key.setRequiredTenantId(TenantId);
if (indexByTenantIdx.containsKey(key)) {
Map<CFAccTaxPKey, ICFAccTaxObj> mapTenantIdx = indexByTenantIdx.get(key);
if (mapTenantIdx != null) {
List<ICFAccTaxObj> toForget = new LinkedList<ICFAccTaxObj>();
ICFAccTaxObj cur = null;
Iterator<ICFAccTaxObj> iter = mapTenantIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByTenantIdx.remove(key);
}
}
public void forgetClearTopDepByContTblIdx(long TenantId, long ContTableId) {
if (indexByContTblIdx == null) {
return;
}
CFBamClearTopDepByContTblIdxKey key =
schema.getBackingStore().getFactoryClearTopDep().newContTblIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredContTableId(ContTableId);
if (indexByContTblIdx.containsKey(key)) {
Map<CFBamScopePKey, ICFBamClearTopDepObj> mapContTblIdx = indexByContTblIdx.get(key);
if (mapContTblIdx != null) {
List<ICFBamClearTopDepObj> toForget = new LinkedList<ICFBamClearTopDepObj>();
ICFBamClearTopDepObj cur = null;
Iterator<ICFBamClearTopDepObj> iter = mapContTblIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByContTblIdx.remove(key);
}
}
public void deleteClearTopDepByContTblIdx(long TenantId, long ContTableId) {
CFBamClearTopDepByContTblIdxKey key =
schema.getBackingStore().getFactoryClearTopDep().newContTblIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredContTableId(ContTableId);
if (indexByContTblIdx == null) {
indexByContTblIdx =
new HashMap<CFBamClearTopDepByContTblIdxKey, Map<CFBamScopePKey, ICFBamClearTopDepObj>>();
}
if (indexByContTblIdx.containsKey(key)) {
Map<CFBamScopePKey, ICFBamClearTopDepObj> dict = indexByContTblIdx.get(key);
schema
.getBackingStore()
.getTableClearTopDep()
.deleteClearTopDepByContTblIdx(schema.getAuthorization(), TenantId, ContTableId);
Iterator<ICFBamClearTopDepObj> iter = dict.values().iterator();
ICFBamClearTopDepObj obj;
List<ICFBamClearTopDepObj> toForget = new LinkedList<ICFBamClearTopDepObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByContTblIdx.remove(key);
} else {
schema
.getBackingStore()
.getTableClearTopDep()
.deleteClearTopDepByContTblIdx(schema.getAuthorization(), TenantId, ContTableId);
}
}
public void forgetSecGroupIncludeByIncludeIdx(long ClusterId, int IncludeGroupId) {
if (indexByIncludeIdx == null) {
return;
}
CFSecuritySecGroupIncludeByIncludeIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactorySecGroupInclude()
.newIncludeIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredIncludeGroupId(IncludeGroupId);
if (indexByIncludeIdx.containsKey(key)) {
Map<CFSecuritySecGroupIncludePKey, ICFSecuritySecGroupIncludeObj> mapIncludeIdx =
indexByIncludeIdx.get(key);
if (mapIncludeIdx != null) {
List<ICFSecuritySecGroupIncludeObj> toForget =
new LinkedList<ICFSecuritySecGroupIncludeObj>();
ICFSecuritySecGroupIncludeObj cur = null;
Iterator<ICFSecuritySecGroupIncludeObj> iter = mapIncludeIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByIncludeIdx.remove(key);
}
}
public CFSecurityISOCountryLanguageBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call " + schema.getLowerDbSchemaName() + ".sp_read_iso_cntrylng_all( ?, ?, ?, ?, ? )";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
try {
resultSet = stmtReadAllBuff.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOCountryLanguageBuff[] retBuff =
new CFSecurityISOCountryLanguageBuff[buffList.size()];
Iterator<CFSecurityISOCountryLanguageBuff> 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;
}
}
}
private boolean calculateWithValidValues() {
Iterator it = metaProperties.iterator();
while (it.hasNext()) {
MetaProperty m = (MetaProperty) it.next();
if (m.hasValidValues()) return true;
}
return false;
}
public CFSecurityISOTimezoneBuff[] readBuffByOffsetIdx(
CFSecurityAuthorization Authorization, short TZHourOffset, short TZMinOffset) {
final String S_ProcName = "readBuffByOffsetIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_isotz_by_offsetidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByOffsetIdx == null) {
stmtReadBuffByOffsetIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZHourOffset);
stmtReadBuffByOffsetIdx.setShort(argIdx++, TZMinOffset);
resultSet = stmtReadBuffByOffsetIdx.executeQuery();
List<CFSecurityISOTimezoneBuff> buffList = new LinkedList<CFSecurityISOTimezoneBuff>();
while (resultSet.next()) {
CFSecurityISOTimezoneBuff buff = unpackISOTimezoneResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOTimezoneBuff[] retBuff = new CFSecurityISOTimezoneBuff[buffList.size()];
Iterator<CFSecurityISOTimezoneBuff> 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;
}
}
}
public CFCrmMemoDataBuff[] readBuffByMemoDataCtcIdx(
CFSecurityAuthorization Authorization, long TenantId, long ContactId) {
final String S_ProcName = "readBuffByMemoDataCtcIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_memodata_by_memodatactcidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) }";
if (stmtReadBuffByMemoDataCtcIdx == null) {
stmtReadBuffByMemoDataCtcIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, TenantId);
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, ContactId);
resultSet = stmtReadBuffByMemoDataCtcIdx.executeQuery();
List<CFCrmMemoDataBuff> buffList = new LinkedList<CFCrmMemoDataBuff>();
if (resultSet != null) {
while (resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
buffList.add(buff);
}
}
int idx = 0;
CFCrmMemoDataBuff[] retBuff = new CFCrmMemoDataBuff[buffList.size()];
Iterator<CFCrmMemoDataBuff> 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;
}
}
}
public CFSecurityTSecGroupBuff[] readBuffByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
final String S_ProcName = "readBuffByTenantVisIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tsecgrp_by_tenantvisidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtReadBuffByTenantVisIdx == null) {
stmtReadBuffByTenantVisIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByTenantVisIdx.setLong(argIdx++, TenantId);
if (IsVisible) {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "Y");
} else {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "N");
}
resultSet = stmtReadBuffByTenantVisIdx.executeQuery();
List<CFSecurityTSecGroupBuff> buffList = new LinkedList<CFSecurityTSecGroupBuff>();
while (resultSet.next()) {
CFSecurityTSecGroupBuff buff = unpackTSecGroupResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityTSecGroupBuff[] retBuff = new CFSecurityTSecGroupBuff[buffList.size()];
Iterator<CFSecurityTSecGroupBuff> 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;
}
}
}
public CFSecurityISOLanguageBuff[] readBuffByCode2Idx(
CFSecurityAuthorization Authorization, String ISO6391Code) {
final String S_ProcName = "readBuffByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_iso_lang_by_code2idx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtReadBuffByCode2Idx == null) {
stmtReadBuffByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (ISO6391Code != null) {
stmtReadBuffByCode2Idx.setString(argIdx++, ISO6391Code);
} else {
stmtReadBuffByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
resultSet = stmtReadBuffByCode2Idx.executeQuery();
List<CFSecurityISOLanguageBuff> buffList = new LinkedList<CFSecurityISOLanguageBuff>();
while (resultSet.next()) {
CFSecurityISOLanguageBuff buff = unpackISOLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOLanguageBuff[] retBuff = new CFSecurityISOLanguageBuff[buffList.size()];
Iterator<CFSecurityISOLanguageBuff> 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;
}
}
}
public CFBamAccessFrequencyBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_accfreq_all( ?, ?, ?, ?, ? )";
if (stmtReadAllBuff == null) {
stmtReadAllBuff = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
resultSet = stmtReadAllBuff.executeQuery();
List<CFBamAccessFrequencyBuff> buffList = new LinkedList<CFBamAccessFrequencyBuff>();
while (resultSet.next()) {
CFBamAccessFrequencyBuff buff = unpackAccessFrequencyResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFBamAccessFrequencyBuff[] retBuff = new CFBamAccessFrequencyBuff[buffList.size()];
Iterator<CFBamAccessFrequencyBuff> 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;
}
}
}
public void minimizeMemory() {
allSecDevice = null;
indexByUserIdx = null;
List<ICFSecuritySecDeviceObj> toForget = new LinkedList<ICFSecuritySecDeviceObj>();
ICFSecuritySecDeviceObj cur = null;
Iterator<ICFSecuritySecDeviceObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void minimizeMemory() {
allTax = null;
indexByTenantIdx = null;
indexByUNameIdx = null;
List<ICFAccTaxObj> toForget = new LinkedList<ICFAccTaxObj>();
ICFAccTaxObj cur = null;
Iterator<ICFAccTaxObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void minimizeMemory() {
allDataScope = null;
indexByUNameIdx = null;
List<ICFBamDataScopeObj> toForget = new LinkedList<ICFBamDataScopeObj>();
ICFBamDataScopeObj cur = null;
Iterator<ICFBamDataScopeObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
if (cur.getEdit() == null) {
toForget.add(cur);
}
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void minimizeMemory() {
allISOCountry = null;
indexByISOCodeIdx = null;
indexByNameIdx = null;
List<ICFSecurityISOCountryObj> toForget = new LinkedList<ICFSecurityISOCountryObj>();
ICFSecurityISOCountryObj cur = null;
Iterator<ICFSecurityISOCountryObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
if (cur.getEdit() == null) {
toForget.add(cur);
}
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void minimizeMemory() {
allMemo = null;
indexByTenantIdx = null;
indexByMemoContactIdx = null;
indexByUDescrIdx = null;
List<ICFCrmMemoObj> toForget = new LinkedList<ICFCrmMemoObj>();
ICFCrmMemoObj cur = null;
Iterator<ICFCrmMemoObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
if (cur.getEdit() == null) {
toForget.add(cur);
}
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void minimizeMemory() {
allSecGroupInclude = null;
indexByClusterIdx = null;
indexByGroupIdx = null;
indexByIncludeIdx = null;
indexByUIncludeIdx = null;
List<ICFSecuritySecGroupIncludeObj> toForget = new LinkedList<ICFSecuritySecGroupIncludeObj>();
ICFSecuritySecGroupIncludeObj cur = null;
Iterator<ICFSecuritySecGroupIncludeObj> iter = members.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
if (cur.getEdit() == null) {
toForget.add(cur);
}
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget();
}
}
public void deleteSecGroupIncludeByIncludeIdx(long ClusterId, int IncludeGroupId) {
CFSecuritySecGroupIncludeByIncludeIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactorySecGroupInclude()
.newIncludeIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredIncludeGroupId(IncludeGroupId);
if (indexByIncludeIdx == null) {
indexByIncludeIdx =
new HashMap<
CFSecuritySecGroupIncludeByIncludeIdxKey,
Map<CFSecuritySecGroupIncludePKey, ICFSecuritySecGroupIncludeObj>>();
}
if (indexByIncludeIdx.containsKey(key)) {
Map<CFSecuritySecGroupIncludePKey, ICFSecuritySecGroupIncludeObj> dict =
indexByIncludeIdx.get(key);
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.deleteSecGroupIncludeByIncludeIdx(schema.getAuthorization(), ClusterId, IncludeGroupId);
Iterator<ICFSecuritySecGroupIncludeObj> iter = dict.values().iterator();
ICFSecuritySecGroupIncludeObj obj;
List<ICFSecuritySecGroupIncludeObj> toForget =
new LinkedList<ICFSecuritySecGroupIncludeObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByIncludeIdx.remove(key);
} else {
((ICFInternetSchema) schema.getBackingStore())
.getTableSecGroupInclude()
.deleteSecGroupIncludeByIncludeIdx(schema.getAuthorization(), ClusterId, IncludeGroupId);
}
}
public void deleteISOCountryCurrencyByCurrencyIdx(short ISOCurrencyId) {
CFSecurityISOCountryCurrencyByCurrencyIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newCurrencyIdxKey();
key.setRequiredISOCurrencyId(ISOCurrencyId);
if (indexByCurrencyIdx == null) {
indexByCurrencyIdx =
new HashMap<
CFSecurityISOCountryCurrencyByCurrencyIdxKey,
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj>>();
}
if (indexByCurrencyIdx.containsKey(key)) {
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj> dict =
indexByCurrencyIdx.get(key);
((ICFInternetSchema) schema.getBackingStore())
.getTableISOCountryCurrency()
.deleteISOCountryCurrencyByCurrencyIdx(schema.getAuthorization(), ISOCurrencyId);
Iterator<ICFSecurityISOCountryCurrencyObj> iter = dict.values().iterator();
ICFSecurityISOCountryCurrencyObj obj;
List<ICFSecurityISOCountryCurrencyObj> toForget =
new LinkedList<ICFSecurityISOCountryCurrencyObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByCurrencyIdx.remove(key);
} else {
((ICFInternetSchema) schema.getBackingStore())
.getTableISOCountryCurrency()
.deleteISOCountryCurrencyByCurrencyIdx(schema.getAuthorization(), ISOCurrencyId);
}
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFBamXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
String attrTenantId = null;
String attrScopeId = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstTimestampTypeReadByScopeIdx");
CFBamXMsgRqstHandler xmsgRqstHandler = (CFBamXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFBamSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Extract Attributes
numAttrs = attrs.getLength();
for (idxAttr = 0; idxAttr < numAttrs; idxAttr++) {
attrLocalName = attrs.getLocalName(idxAttr);
if (attrLocalName.equals("Id")) {
if (attrId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("TenantId")) {
if (attrTenantId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrTenantId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("ScopeId")) {
if (attrScopeId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrScopeId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("schemaLocation")) {
// ignored
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnrecognizedAttributeException(
getClass(), S_ProcName, getParser().getLocationInfo(), attrLocalName);
}
}
// Ensure that required attributes have values
if ((attrTenantId == null) || (attrTenantId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "TenantId");
}
if ((attrScopeId == null) || (attrScopeId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ScopeId");
}
// Save named attributes to context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Convert string attributes to native Java types
// and apply the converted attributes to the editBuff.
long natTenantId;
natTenantId = Long.parseLong(attrTenantId);
long natScopeId;
natScopeId = Long.parseLong(attrScopeId);
// Read the objects
List<ICFBamTimestampTypeObj> list =
schemaObj.getTimestampTypeTableObj().readTimestampTypeByScopeIdx(natTenantId, natScopeId);
String responseOpening =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgValueMessageFormatter.formatValueRspnListOpenTag();
xmsgRqstHandler.appendResponse(responseOpening);
Iterator<ICFBamTimestampTypeObj> iter = list.iterator();
ICFBamTimestampTypeObj cur;
String subxml;
while (iter.hasNext()) {
cur = iter.next();
subxml =
CFBamXMsgValueMessageFormatter.formatValueRspnDerivedRec("\n\t\t", cur.getValueBuff());
xmsgRqstHandler.appendResponse(subxml);
}
String responseClosing =
"\n"
+ "\t"
+ CFBamXMsgValueMessageFormatter.formatValueRspnListCloseTag()
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.appendResponse(responseClosing);
} catch (RuntimeException e) {
CFBamXMsgRqstHandler xmsgRqstHandler = ((CFBamXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFBamXMsgRqstHandler xmsgRqstHandler = ((CFBamXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}
public CFBamDataScopeBuff[] readAllDerived(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllDerived";
String rqst =
CFBamXMsgSchemaMessageFormatter.formatRqstXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgDataScopeMessageFormatter.formatDataScopeRqstReadAll("\n\t\t\t")
+ "\n"
+ CFBamXMsgSchemaMessageFormatter.formatRqstXmlPostamble();
try {
schema.getCFTipClientHandler().issueAppRequest(rqst);
} catch (BadPaddingException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught BadPaddingException - " + e.getMessage(), e);
} catch (IllegalBlockSizeException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught IllegalBlockSizeException - " + e.getMessage(), e);
} catch (InvalidKeyException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught InvalidKeyException - " + e.getMessage(), e);
} catch (NoSuchAlgorithmException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught NoSuchAlgorithmException - " + e.getMessage(), e);
} catch (InvalidAlgorithmParameterException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Caught InvalidAlgorithmParameterException - " + e.getMessage(),
e);
} catch (NoSuchPaddingException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "Caught NoSuchPaddingException - " + e.getMessage(), e);
}
ICFTipResponseHandler responseHandler = schema.getCFTipClientHandler().getResponseHandler();
CFLibRuntimeException exceptionRaised = responseHandler.getExceptionRaised();
if (exceptionRaised != null) {
throw exceptionRaised;
}
Object sortedListObj = responseHandler.getListOfObjects();
if (sortedListObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "responseHandler.getListOfObjects");
}
@SuppressWarnings("unchecked")
List<ICFBamDataScopeObj> sortedList = (List<ICFBamDataScopeObj>) sortedListObj;
int sz = sortedList.size();
CFBamDataScopeBuff arr[] = new CFBamDataScopeBuff[sz];
Iterator<ICFBamDataScopeObj> iter = sortedList.iterator();
ICFBamDataScopeObj cur;
for (int idx = 0; idx < sz; idx++) {
cur = (ICFBamDataScopeObj) iter.next();
arr[idx] = cur.getDataScopeBuff();
}
return (arr);
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFAccXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstProjectBaseReadAll");
CFAccXMsgRqstHandler xmsgRqstHandler = (CFAccXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFAccSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Extract Attributes
numAttrs = attrs.getLength();
for (idxAttr = 0; idxAttr < numAttrs; idxAttr++) {
attrLocalName = attrs.getLocalName(idxAttr);
if (attrLocalName.equals("Id")) {
if (attrId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("schemaLocation")) {
// ignored
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnrecognizedAttributeException(
getClass(), S_ProcName, getParser().getLocationInfo(), attrLocalName);
}
}
// Save named attributes to context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Read the objects and prepare the response XML
List<ICFInternetProjectBaseObj> list =
schemaObj.getProjectBaseTableObj().readAllProjectBase(true);
String responseOpening =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgProjectBaseMessageFormatter.formatProjectBaseRspnListOpenTag();
xmsgRqstHandler.appendResponse(responseOpening);
Iterator<ICFInternetProjectBaseObj> iter = list.iterator();
ICFInternetProjectBaseObj cur;
String subxml;
while (iter.hasNext()) {
cur = iter.next();
subxml =
CFAccXMsgProjectBaseMessageFormatter.formatProjectBaseRspnDerivedRec(
"\n\t\t", cur.getProjectBaseBuff());
xmsgRqstHandler.appendResponse(subxml);
}
String responseClosing =
"\n"
+ "\t"
+ CFAccXMsgProjectBaseMessageFormatter.formatProjectBaseRspnListCloseTag()
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.appendResponse(responseClosing);
} catch (RuntimeException e) {
CFAccXMsgRqstHandler xmsgRqstHandler = ((CFAccXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFAccXMsgRqstHandler xmsgRqstHandler = ((CFAccXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}
public CFSecurityAuditActionBuff[] readAllBuff(CFSecurityAuthorization Authorization) {
final String S_ProcName = "readAllBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtReadAllBuff = null;
try {
CFSecurityAuditActionBuff buff = null;
List<CFSecurityAuditActionBuff> buffList = new LinkedList<CFSecurityAuditActionBuff>();
stmtReadAllBuff =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_auditactionall( ?, ?, ?, ?, ?, ? ) ); end;");
int argIdx = 1;
stmtReadAllBuff.registerOutParameter(argIdx++, OracleTypes.CURSOR);
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadAllBuff.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadAllBuff.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadAllBuff.execute();
resultSet = (ResultSet) stmtReadAllBuff.getObject(1);
if (resultSet != null) {
try {
while (resultSet.next()) {
buff = unpackAuditActionResultSetToBuff(resultSet);
buffList.add(buff);
}
} catch (SQLException e) {
// Oracle may return an invalid resultSet if the rowset is empty
}
}
int idx = 0;
CFSecurityAuditActionBuff[] retBuff = new CFSecurityAuditActionBuff[buffList.size()];
Iterator<CFSecurityAuditActionBuff> 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 (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
}
}
public CFSecuritySecGroupBuff[] readBuffByClusterIdx(
CFSecurityAuthorization Authorization, long ClusterId) {
final String S_ProcName = "readBuffByClusterIdx";
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtReadBuffByClusterIdx = null;
List<CFSecuritySecGroupBuff> buffList = new LinkedList<CFSecuritySecGroupBuff>();
try {
stmtReadBuffByClusterIdx =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_secgrpbyclusteridx( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " ); end;");
int argIdx = 1;
stmtReadBuffByClusterIdx.registerOutParameter(argIdx++, OracleTypes.CURSOR);
stmtReadBuffByClusterIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByClusterIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByClusterIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByClusterIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByClusterIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByClusterIdx.setLong(argIdx++, ClusterId);
stmtReadBuffByClusterIdx.execute();
resultSet = (ResultSet) stmtReadBuffByClusterIdx.getObject(1);
if (resultSet != null) {
try {
while (resultSet.next()) {
CFSecuritySecGroupBuff buff = unpackSecGroupResultSetToBuff(resultSet);
buffList.add(buff);
}
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
} catch (SQLException e) {
}
}
int idx = 0;
CFSecuritySecGroupBuff[] retBuff = new CFSecuritySecGroupBuff[buffList.size()];
Iterator<CFSecuritySecGroupBuff> 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 (stmtReadBuffByClusterIdx != null) {
try {
stmtReadBuffByClusterIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByClusterIdx = null;
}
}
}