public CFSecurityISOCountryLanguageBuff[] readBuffByLanguageIdx(
CFSecurityAuthorization Authorization, short ISOLanguageId) {
final String S_ProcName = "readBuffByLanguageIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_iso_cntrylng_by_languageidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByLanguageIdx == null) {
stmtReadBuffByLanguageIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByLanguageIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByLanguageIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByLanguageIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByLanguageIdx.setShort(argIdx++, ISOLanguageId);
resultSet = stmtReadBuffByLanguageIdx.executeQuery();
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while (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;
}
}
}
public CFFreeSwitchFSSFProfileDomainBuff[] readDerivedByUNameIdx(
CFSecurityAuthorization Authorization,
long argTenantId,
long argFSSFProfileId,
String argName) {
final String S_ProcName = "readDerivedByUNameIdx";
String rqst =
CFFreeSwitchXMsgSchemaMessageFormatter.formatRqstXmlPreamble()
+ "\n"
+ "\t"
+ CFFreeSwitchXMsgFSSFProfileDomainMessageFormatter
.formatFSSFProfileDomainRqstReadByUNameIdx(
"\n\t\t\t", argTenantId, argFSSFProfileId, argName)
+ "\n"
+ CFFreeSwitchXMsgSchemaMessageFormatter.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();
@SuppressWarnings("unchecked")
List<ICFFreeSwitchFSSFProfileDomainObj> sortedList =
(List<ICFFreeSwitchFSSFProfileDomainObj>) sortedListObj;
CFFreeSwitchFSSFProfileDomainBuff arr[];
if (sortedList != null) {
int sz = sortedList.size();
arr = new CFFreeSwitchFSSFProfileDomainBuff[sz];
Iterator<ICFFreeSwitchFSSFProfileDomainObj> iter = sortedList.iterator();
ICFFreeSwitchFSSFProfileDomainObj cur;
for (int idx = 0; idx < sz; idx++) {
cur = (ICFFreeSwitchFSSFProfileDomainObj) iter.next();
arr[idx] = cur.getFSSFProfileDomainBuff();
}
} else {
arr = new CFFreeSwitchFSSFProfileDomainBuff[0];
}
return (arr);
}
public CFSecuritySecAppBuff[] readBuffByClusterIdx(
CFSecurityAuthorization Authorization, long ClusterId) {
final String S_ProcName = "readBuffByClusterIdx";
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtReadBuffByClusterIdx = null;
List<CFSecuritySecAppBuff> buffList = new LinkedList<CFSecuritySecAppBuff>();
try {
stmtReadBuffByClusterIdx =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_secappbyclusteridx( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " ); 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()) {
CFSecuritySecAppBuff buff = unpackSecAppResultSetToBuff(resultSet);
buffList.add(buff);
}
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
} catch (SQLException e) {
}
}
int idx = 0;
CFSecuritySecAppBuff[] retBuff = new CFSecuritySecAppBuff[buffList.size()];
Iterator<CFSecuritySecAppBuff> 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 CFSecuritySecAppBuff[] 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 {
CFSecuritySecAppBuff buff = null;
List<CFSecuritySecAppBuff> buffList = new LinkedList<CFSecuritySecAppBuff>();
stmtReadAllBuff =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_secappall( ?, ?, ?, ?, ?, ? ) ); 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 = unpackSecAppResultSetToBuff(resultSet);
buffList.add(buff);
}
} catch (SQLException e) {
// Oracle may return an invalid resultSet if the rowset is empty
}
}
int idx = 0;
CFSecuritySecAppBuff[] retBuff = new CFSecuritySecAppBuff[buffList.size()];
Iterator<CFSecuritySecAppBuff> 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;
}
}
}