public void setSwingDataCollection(Collection<ICFSecurityISOCountryObj> value) {
final String S_ProcName = "setSwingDataCollection";
swingDataCollection = value;
if (swingDataCollection == null) {
arrayOfISOCountry = new ICFSecurityISOCountryObj[0];
} else {
int len = value.size();
arrayOfISOCountry = new ICFSecurityISOCountryObj[len];
Iterator<ICFSecurityISOCountryObj> iter = swingDataCollection.iterator();
int idx = 0;
while (iter.hasNext() && (idx < len)) {
arrayOfISOCountry[idx++] = iter.next();
}
if (idx < len) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Collection iterator did not fully populate the array copy");
}
if (iter.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Collection iterator had left over items when done populating array copy");
}
Arrays.sort(arrayOfISOCountry, compareISOCountryByQualName);
}
PickerTableModel tblDataModel = getDataModel();
if (tblDataModel != null) {
tblDataModel.fireTableDataChanged();
}
}
public void deleteMemoByMemoContactIdx(long TenantId, long ContactId) {
CFCrmMemoByMemoContactIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryMemo().newMemoContactIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredContactId(ContactId);
if (indexByMemoContactIdx == null) {
indexByMemoContactIdx =
new HashMap<CFCrmMemoByMemoContactIdxKey, Map<CFCrmMemoPKey, ICFCrmMemoObj>>();
}
if (indexByMemoContactIdx.containsKey(key)) {
Map<CFCrmMemoPKey, ICFCrmMemoObj> dict = indexByMemoContactIdx.get(key);
((ICFAccSchema) schema.getBackingStore())
.getTableMemo()
.deleteMemoByMemoContactIdx(schema.getAuthorization(), TenantId, ContactId);
Iterator<ICFCrmMemoObj> iter = dict.values().iterator();
ICFCrmMemoObj obj;
List<ICFCrmMemoObj> toForget = new LinkedList<ICFCrmMemoObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByMemoContactIdx.remove(key);
} else {
((ICFAccSchema) schema.getBackingStore())
.getTableMemo()
.deleteMemoByMemoContactIdx(schema.getAuthorization(), TenantId, ContactId);
}
}
public CFSecuritySecFormBuff[] readBuffByClusterIdx(
CFSecurityAuthorization Authorization, long ClusterId) {
final String S_ProcName = "readBuffByClusterIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_read_secform_by_clusteridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByClusterIdx == null) {
stmtReadBuffByClusterIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
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);
try {
resultSet = stmtReadBuffByClusterIdx.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecuritySecFormBuff> buffList = new LinkedList<CFSecuritySecFormBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecuritySecFormBuff buff = unpackSecFormResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecuritySecFormBuff[] retBuff = new CFSecuritySecFormBuff[buffList.size()];
Iterator<CFSecuritySecFormBuff> 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 forgetTSecGroupMemberByUserIdx(UUID SecUserId) {
if (indexByUserIdx == null) {
return;
}
CFSecurityTSecGroupMemberByUserIdxKey key =
((ICFBamSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newUserIdxKey();
key.setRequiredSecUserId(SecUserId);
if (indexByUserIdx.containsKey(key)) {
Map<CFSecurityTSecGroupMemberPKey, ICFSecurityTSecGroupMemberObj> mapUserIdx =
indexByUserIdx.get(key);
if (mapUserIdx != null) {
List<ICFSecurityTSecGroupMemberObj> toForget =
new LinkedList<ICFSecurityTSecGroupMemberObj>();
ICFSecurityTSecGroupMemberObj cur = null;
Iterator<ICFSecurityTSecGroupMemberObj> 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 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 ListIterator<ICFLibAnyObj> enumerateDetails(MssCFGenContext genContext) {
final String S_ProcName = "CFBamMssCFIterateNumberTypeRef.enumerateDetails() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext.getGenDef()");
}
List<ICFLibAnyObj> list = new LinkedList<ICFLibAnyObj>();
if (genDef instanceof ICFBamNumberTypeObj) {
Iterator<ICFBamTableColObj> elements =
((ICFBamNumberTypeObj) genDef).getOptionalChildrenRef().iterator();
while (elements.hasNext()) {
list.add(elements.next());
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "genContext.getGenDef()", genDef, "ICFBamNumberTypeObj");
}
return (list.listIterator());
}
public List<ICFCrmMemoObj> readAllMemo(boolean forceRead) {
final String S_ProcName = "readAllMemo";
if ((allMemo == null) || forceRead) {
Map<CFCrmMemoPKey, ICFCrmMemoObj> map = new HashMap<CFCrmMemoPKey, ICFCrmMemoObj>();
allMemo = map;
CFCrmMemoBuff[] buffList =
((ICFAccSchema) schema.getBackingStore())
.getTableMemo()
.readAllDerived(schema.getAuthorization());
CFCrmMemoBuff buff;
ICFCrmMemoObj obj;
for (int idx = 0; idx < buffList.length; idx++) {
buff = buffList[idx];
obj = newInstance();
obj.setPKey(((ICFAccSchema) schema.getBackingStore()).getFactoryMemo().newPKey());
obj.setBuff(buff);
ICFCrmMemoObj realized = (ICFCrmMemoObj) obj.realize();
}
}
Comparator<ICFCrmMemoObj> cmp =
new Comparator<ICFCrmMemoObj>() {
public int compare(ICFCrmMemoObj lhs, ICFCrmMemoObj rhs) {
if (lhs == null) {
if (rhs == null) {
return (0);
} else {
return (-1);
}
} else if (rhs == null) {
return (1);
} else {
CFCrmMemoPKey lhsPKey = lhs.getPKey();
CFCrmMemoPKey rhsPKey = rhs.getPKey();
int ret = lhsPKey.compareTo(rhsPKey);
return (ret);
}
}
};
int len = allMemo.size();
ICFCrmMemoObj arr[] = new ICFCrmMemoObj[len];
Iterator<ICFCrmMemoObj> valIter = allMemo.values().iterator();
int idx = 0;
while ((idx < len) && valIter.hasNext()) {
arr[idx++] = valIter.next();
}
if (idx < len) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentUnderflowException(getClass(), S_ProcName, 0, "idx", idx, len);
} else if (valIter.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentOverflowException(getClass(), S_ProcName, 0, "idx", idx, len);
}
Arrays.sort(arr, cmp);
ArrayList<ICFCrmMemoObj> arrayList = new ArrayList<ICFCrmMemoObj>(len);
for (idx = 0; idx < len; idx++) {
arrayList.add(arr[idx]);
}
List<ICFCrmMemoObj> sortedList = arrayList;
return (sortedList);
}
public void forgetMemoByMemoContactIdx(long TenantId, long ContactId) {
if (indexByMemoContactIdx == null) {
return;
}
CFCrmMemoByMemoContactIdxKey key =
((ICFAccSchema) schema.getBackingStore()).getFactoryMemo().newMemoContactIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredContactId(ContactId);
if (indexByMemoContactIdx.containsKey(key)) {
Map<CFCrmMemoPKey, ICFCrmMemoObj> mapMemoContactIdx = indexByMemoContactIdx.get(key);
if (mapMemoContactIdx != null) {
List<ICFCrmMemoObj> toForget = new LinkedList<ICFCrmMemoObj>();
ICFCrmMemoObj cur = null;
Iterator<ICFCrmMemoObj> iter = mapMemoContactIdx.values().iterator();
while (iter.hasNext()) {
cur = iter.next();
toForget.add(cur);
}
iter = toForget.iterator();
while (iter.hasNext()) {
cur = iter.next();
cur.forget(true);
}
}
indexByMemoContactIdx.remove(key);
}
}
public ListIterator<ICFLibAnyObj> enumerateDetails(MssCFGenContext genContext) {
final String S_ProcName = "CFAsteriskMssCFIterateHostNodeConfFile.enumerateDetails() ";
if (genContext == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext");
}
ICFLibAnyObj genDef = genContext.getGenDef();
if (genDef == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 1, "genContext.getGenDef()");
}
List<ICFLibAnyObj> list = new LinkedList<ICFLibAnyObj>();
if (genDef instanceof ICFAsteriskHostNodeObj) {
Iterator<ICFAsteriskConfigurationFileObj> elements =
((ICFAsteriskHostNodeObj) genDef).getOptionalComponentsConfFile().iterator();
while (elements.hasNext()) {
list.add(elements.next());
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(), S_ProcName, "genContext.getGenDef()", genDef, "ICFAsteriskHostNodeObj");
}
return (list.listIterator());
}
public CFSecuritySecGroupFormBuff[] readDerivedByFormIdx(
CFSecurityAuthorization Authorization, long ClusterId, int SecFormId) {
final String S_ProcName = "CFInternetRamSecGroupForm.readDerivedByFormIdx";
CFSecuritySecGroupFormByFormIdxKey key = schema.getFactorySecGroupForm().newFormIdxKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredSecFormId(SecFormId);
CFSecuritySecGroupFormBuff[] recArray;
if (dictByFormIdx.containsKey(key)) {
Map<CFSecuritySecGroupFormPKey, CFSecuritySecGroupFormBuff> subdictFormIdx =
dictByFormIdx.get(key);
recArray = new CFSecuritySecGroupFormBuff[subdictFormIdx.size()];
Iterator<CFSecuritySecGroupFormBuff> iter = subdictFormIdx.values().iterator();
int idx = 0;
while (iter.hasNext()) {
recArray[idx++] = iter.next();
}
} else {
Map<CFSecuritySecGroupFormPKey, CFSecuritySecGroupFormBuff> subdictFormIdx =
new HashMap<CFSecuritySecGroupFormPKey, CFSecuritySecGroupFormBuff>();
dictByFormIdx.put(key, subdictFormIdx);
recArray = new CFSecuritySecGroupFormBuff[0];
}
return (recArray);
}
public CFDbTestNumberDefBuff[] readAllDerived(CFSecurityAuthorization Authorization) {
final String S_ProcName = "CFDbTestRamNumberDef.readAllDerived";
CFDbTestNumberDefBuff[] retList = new CFDbTestNumberDefBuff[dictByPKey.values().size()];
Iterator<CFDbTestNumberDefBuff> iter = dictByPKey.values().iterator();
int idx = 0;
while (iter.hasNext()) {
retList[idx++] = iter.next();
}
return (retList);
}
public CFSecurityTSecGroupBuff[] 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 =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_tsecgrp_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<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 CFSecurityISOTimezoneBuff[] readBuffByOffsetIdx(
CFSecurityAuthorization Authorization, short TZHourOffset, short TZMinOffset) {
final String S_ProcName = "readBuffByOffsetIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call 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>();
if (resultSet != null) {
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 void minimizeMemory() {
allISOCountryCurrency = null;
indexByCountryIdx = null;
indexByCurrencyIdx = null;
List<ICFSecurityISOCountryCurrencyObj> toForget =
new LinkedList<ICFSecurityISOCountryCurrencyObj>();
ICFSecurityISOCountryCurrencyObj cur = null;
Iterator<ICFSecurityISOCountryCurrencyObj> 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() {
allTSecGroupMember = null;
indexByTenantIdx = null;
indexByGroupIdx = null;
indexByUserIdx = null;
indexByUUserIdx = null;
List<ICFSecurityTSecGroupMemberObj> toForget = new LinkedList<ICFSecurityTSecGroupMemberObj>();
ICFSecurityTSecGroupMemberObj cur = null;
Iterator<ICFSecurityTSecGroupMemberObj> 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 deleteNumberDefByNextIdx(
CFSecurityAuthorization Authorization, CFDbTestValueByNextIdxKey argKey) {
final String S_ProcName = "deleteNumberDefByNextIdx";
CFDbTestNumberDefBuff cur;
LinkedList<CFDbTestNumberDefBuff> matchSet = new LinkedList<CFDbTestNumberDefBuff>();
Iterator<CFDbTestNumberDefBuff> values = dictByPKey.values().iterator();
while (values.hasNext()) {
cur = values.next();
if (argKey.equals(cur)) {
matchSet.add(cur);
}
}
Iterator<CFDbTestNumberDefBuff> iterMatch = matchSet.iterator();
while (iterMatch.hasNext()) {
cur = iterMatch.next();
String subClassCode = cur.getClassCode();
if ("NUMD".equals(subClassCode)) {
schema.getTableNumberDef().deleteNumberDef(Authorization, cur);
} else if ("NUMC".equals(subClassCode)) {
schema.getTableNumberCol().deleteNumberCol(Authorization, (CFDbTestNumberColBuff) cur);
} else if ("NUMT".equals(subClassCode)) {
schema.getTableNumberType().deleteNumberType(Authorization, (CFDbTestNumberTypeBuff) cur);
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnsupportedClassException(
getClass(),
S_ProcName,
"subClassCode",
cur,
"Instance of or subclass of NumberDef must not be \"" + subClassCode + "\"");
}
}
}
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 deleteTSecGroupMemberByGroupIdx(long TenantId, int TSecGroupId) {
CFSecurityTSecGroupMemberByGroupIdxKey key =
((ICFBamSchema) schema.getBackingStore()).getFactoryTSecGroupMember().newGroupIdxKey();
key.setRequiredTenantId(TenantId);
key.setRequiredTSecGroupId(TSecGroupId);
if (indexByGroupIdx == null) {
indexByGroupIdx =
new HashMap<
CFSecurityTSecGroupMemberByGroupIdxKey,
Map<CFSecurityTSecGroupMemberPKey, ICFSecurityTSecGroupMemberObj>>();
}
if (indexByGroupIdx.containsKey(key)) {
Map<CFSecurityTSecGroupMemberPKey, ICFSecurityTSecGroupMemberObj> dict =
indexByGroupIdx.get(key);
((ICFBamSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.deleteTSecGroupMemberByGroupIdx(schema.getAuthorization(), TenantId, TSecGroupId);
Iterator<ICFSecurityTSecGroupMemberObj> iter = dict.values().iterator();
ICFSecurityTSecGroupMemberObj obj;
List<ICFSecurityTSecGroupMemberObj> toForget =
new LinkedList<ICFSecurityTSecGroupMemberObj>();
while (iter.hasNext()) {
obj = iter.next();
toForget.add(obj);
}
iter = toForget.iterator();
while (iter.hasNext()) {
obj = iter.next();
obj.forget(true);
}
indexByGroupIdx.remove(key);
} else {
((ICFBamSchema) schema.getBackingStore())
.getTableTSecGroupMember()
.deleteTSecGroupMemberByGroupIdx(schema.getAuthorization(), TenantId, TSecGroupId);
}
}
public CFDbTestReqMinMaxValueBuff[] readDerivedByTenantIdx(
CFSecurityAuthorization Authorization, long TenantId) {
final String S_ProcName = "CFDbTestRamReqMinMaxValue.readDerivedByTenantIdx";
CFDbTestReqMinMaxValueByTenantIdxKey key = schema.getFactoryReqMinMaxValue().newTenantIdxKey();
key.setRequiredTenantId(TenantId);
CFDbTestReqMinMaxValueBuff[] recArray;
if (dictByTenantIdx.containsKey(key)) {
Map<CFDbTestReqMinMaxValuePKey, CFDbTestReqMinMaxValueBuff> subdictTenantIdx =
dictByTenantIdx.get(key);
recArray = new CFDbTestReqMinMaxValueBuff[subdictTenantIdx.size()];
Iterator<CFDbTestReqMinMaxValueBuff> iter = subdictTenantIdx.values().iterator();
int idx = 0;
while (iter.hasNext()) {
recArray[idx++] = iter.next();
}
} else {
Map<CFDbTestReqMinMaxValuePKey, CFDbTestReqMinMaxValueBuff> subdictTenantIdx =
new HashMap<CFDbTestReqMinMaxValuePKey, CFDbTestReqMinMaxValueBuff>();
dictByTenantIdx.put(key, subdictTenantIdx);
recArray = new CFDbTestReqMinMaxValueBuff[0];
}
return (recArray);
}
public void deleteSecGroupFormByUFormIdx(
CFSecurityAuthorization Authorization, CFSecuritySecGroupFormByUFormIdxKey argKey) {
CFSecuritySecGroupFormBuff cur;
LinkedList<CFSecuritySecGroupFormBuff> matchSet = new LinkedList<CFSecuritySecGroupFormBuff>();
Iterator<CFSecuritySecGroupFormBuff> values = dictByPKey.values().iterator();
while (values.hasNext()) {
cur = values.next();
if (argKey.equals(cur)) {
matchSet.add(cur);
}
}
Iterator<CFSecuritySecGroupFormBuff> iterMatch = matchSet.iterator();
while (iterMatch.hasNext()) {
cur = iterMatch.next();
deleteSecGroupForm(Authorization, cur);
}
}
public void deleteReqMinMaxValueByTenantIdx(
CFSecurityAuthorization Authorization, CFDbTestReqMinMaxValueByTenantIdxKey argKey) {
CFDbTestReqMinMaxValueBuff cur;
LinkedList<CFDbTestReqMinMaxValueBuff> matchSet = new LinkedList<CFDbTestReqMinMaxValueBuff>();
Iterator<CFDbTestReqMinMaxValueBuff> values = dictByPKey.values().iterator();
while (values.hasNext()) {
cur = values.next();
if (argKey.equals(cur)) {
matchSet.add(cur);
}
}
Iterator<CFDbTestReqMinMaxValueBuff> iterMatch = matchSet.iterator();
while (iterMatch.hasNext()) {
cur = iterMatch.next();
deleteReqMinMaxValue(Authorization, cur);
}
}
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 CFInternetRealProjectBuff[] readDerivedByTenantIdx(
CFSecurityAuthorization Authorization, long argTenantId) {
final String S_ProcName = "readDerivedByTenantIdx";
String rqst =
CFAccXMsgSchemaMessageFormatter.formatRqstXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgRealProjectMessageFormatter.formatRealProjectRqstReadByTenantIdx(
"\n\t\t\t", argTenantId)
+ "\n"
+ CFAccXMsgSchemaMessageFormatter.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<ICFInternetDomainBaseObj> sortedList = (List<ICFInternetDomainBaseObj>) sortedListObj;
int sz = sortedList.size();
CFInternetRealProjectBuff arr[] = new CFInternetRealProjectBuff[sz];
Iterator<ICFInternetDomainBaseObj> iter = sortedList.iterator();
ICFInternetRealProjectObj cur;
for (int idx = 0; idx < sz; idx++) {
cur = (ICFInternetRealProjectObj) iter.next();
arr[idx] = cur.getRealProjectBuff();
}
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 List<ICFSecurityISOCountryCurrencyObj> readISOCountryCurrencyByCurrencyIdx(
short ISOCurrencyId, boolean forceRead) {
final String S_ProcName = "readISOCountryCurrencyByCurrencyIdx";
CFSecurityISOCountryCurrencyByCurrencyIdxKey key =
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newCurrencyIdxKey();
key.setRequiredISOCurrencyId(ISOCurrencyId);
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj> dict;
if (indexByCurrencyIdx == null) {
indexByCurrencyIdx =
new HashMap<
CFSecurityISOCountryCurrencyByCurrencyIdxKey,
Map<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj>>();
}
if ((!forceRead) && indexByCurrencyIdx.containsKey(key)) {
dict = indexByCurrencyIdx.get(key);
} else {
dict = new HashMap<CFSecurityISOCountryCurrencyPKey, ICFSecurityISOCountryCurrencyObj>();
// Allow other threads to dirty-read while we're loading
indexByCurrencyIdx.put(key, dict);
ICFSecurityISOCountryCurrencyObj obj;
CFSecurityISOCountryCurrencyBuff[] buffList =
((ICFInternetSchema) schema.getBackingStore())
.getTableISOCountryCurrency()
.readDerivedByCurrencyIdx(schema.getAuthorization(), ISOCurrencyId);
CFSecurityISOCountryCurrencyBuff buff;
for (int idx = 0; idx < buffList.length; idx++) {
buff = buffList[idx];
obj = schema.getISOCountryCurrencyTableObj().newInstance();
obj.setPKey(
((ICFInternetSchema) schema.getBackingStore())
.getFactoryISOCountryCurrency()
.newPKey());
obj.setBuff(buff);
ICFSecurityISOCountryCurrencyObj realized =
(ICFSecurityISOCountryCurrencyObj) obj.realize();
}
}
Comparator<ICFSecurityISOCountryCurrencyObj> cmp =
new Comparator<ICFSecurityISOCountryCurrencyObj>() {
public int compare(
ICFSecurityISOCountryCurrencyObj lhs, ICFSecurityISOCountryCurrencyObj rhs) {
if (lhs == null) {
if (rhs == null) {
return (0);
} else {
return (-1);
}
} else if (rhs == null) {
return (1);
} else {
CFSecurityISOCountryCurrencyPKey lhsPKey = lhs.getPKey();
CFSecurityISOCountryCurrencyPKey rhsPKey = rhs.getPKey();
int ret = lhsPKey.compareTo(rhsPKey);
return (ret);
}
}
};
int len = dict.size();
ICFSecurityISOCountryCurrencyObj arr[] = new ICFSecurityISOCountryCurrencyObj[len];
Iterator<ICFSecurityISOCountryCurrencyObj> valIter = dict.values().iterator();
int idx = 0;
while ((idx < len) && valIter.hasNext()) {
arr[idx++] = valIter.next();
}
if (idx < len) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentUnderflowException(getClass(), S_ProcName, 0, "idx", idx, len);
} else if (valIter.hasNext()) {
throw CFLib.getDefaultExceptionFactory()
.newArgumentOverflowException(getClass(), S_ProcName, 0, "idx", idx, len);
}
Arrays.sort(arr, cmp);
ArrayList<ICFSecurityISOCountryCurrencyObj> arrayList =
new ArrayList<ICFSecurityISOCountryCurrencyObj>(len);
for (idx = 0; idx < len; idx++) {
arrayList.add(arr[idx]);
}
List<ICFSecurityISOCountryCurrencyObj> sortedList = arrayList;
return (sortedList);
}
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;
}
}
}
public CFSecuritySecGroupBuff[] 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 {
CFSecuritySecGroupBuff buff = null;
List<CFSecuritySecGroupBuff> buffList = new LinkedList<CFSecuritySecGroupBuff>();
stmtReadAllBuff =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_secgrpall( ?, ?, ?, ?, ?, ? ) ); 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 = unpackSecGroupResultSetToBuff(resultSet);
buffList.add(buff);
}
} catch (SQLException e) {
// Oracle may return an invalid resultSet if the rowset is empty
}
}
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 (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
}
}