public CFSecurityISOCountryBuff[] 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 sp_read_iso_cntry_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<CFSecurityISOCountryBuff> buffList = new LinkedList<CFSecurityISOCountryBuff>();
if (resultSet != null) {
while (resultSet.next()) {
CFSecurityISOCountryBuff buff = unpackISOCountryResultSetToBuff(resultSet);
buffList.add(buff);
}
}
int idx = 0;
CFSecurityISOCountryBuff[] retBuff = new CFSecurityISOCountryBuff[buffList.size()];
Iterator<CFSecurityISOCountryBuff> 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 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 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;
}
}
}
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);
}