public void updateISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "updateISOCountryLanguage";
ResultSet resultSet = null;
try {
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"select * from "
+ schema.getLowerDbSchemaName()
+ ".sp_update_iso_cntrylng( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtUpdateByPKey == null) {
stmtUpdateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "ISCL");
stmtUpdateByPKey.setShort(argIdx++, ISOCountryId);
stmtUpdateByPKey.setShort(argIdx++, ISOLanguageId);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOCountryLanguageBuff updatedBuff =
unpackISOCountryLanguageResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecuritySecAppBuff readBuffByUJEEMountIdx(
CFSecurityAuthorization Authorization, long ClusterId, String JEEMountName) {
final String S_ProcName = "readBuffByUJEEMountIdx";
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtReadBuffByUJEEMountIdx = null;
try {
stmtReadBuffByUJEEMountIdx =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".rd_secappbyujeemountidx( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ); end;");
int argIdx = 1;
stmtReadBuffByUJEEMountIdx.registerOutParameter(argIdx++, OracleTypes.CURSOR);
stmtReadBuffByUJEEMountIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUJEEMountIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUJEEMountIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUJEEMountIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUJEEMountIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUJEEMountIdx.setLong(argIdx++, ClusterId);
stmtReadBuffByUJEEMountIdx.setString(argIdx++, JEEMountName);
stmtReadBuffByUJEEMountIdx.execute();
resultSet = (ResultSet) stmtReadBuffByUJEEMountIdx.getObject(1);
if (resultSet == null) {
return (null);
}
try {
if (resultSet.next()) {
CFSecuritySecAppBuff buff = unpackSecAppResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, "
+ resultSet.getRow()
+ " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
if (stmtReadBuffByUJEEMountIdx != null) {
try {
stmtReadBuffByUJEEMountIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByUJEEMountIdx = null;
}
}
}
public void updateSecApp(CFSecurityAuthorization Authorization, CFSecuritySecAppBuff Buff) {
final String S_ProcName = "updateSecApp";
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtUpdateByPKey = null;
List<CFSecuritySecAppBuff> buffList = new LinkedList<CFSecuritySecAppBuff>();
try {
long ClusterId = Buff.getRequiredClusterId();
int SecAppId = Buff.getRequiredSecAppId();
String JEEMountName = Buff.getRequiredJEEMountName();
int Revision = Buff.getRequiredRevision();
stmtUpdateByPKey =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".upd_secapp( ?, ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "? ); end;");
int argIdx = 1;
stmtUpdateByPKey.registerOutParameter(argIdx++, OracleTypes.CURSOR);
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtUpdateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtUpdateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtUpdateByPKey.setString(argIdx++, "SAPP");
stmtUpdateByPKey.setLong(argIdx++, ClusterId);
stmtUpdateByPKey.setInt(argIdx++, SecAppId);
stmtUpdateByPKey.setString(argIdx++, JEEMountName);
stmtUpdateByPKey.setInt(argIdx++, Revision);
stmtUpdateByPKey.execute();
resultSet = (ResultSet) stmtUpdateByPKey.getObject(1);
if (resultSet != null) {
try {
if (resultSet.next()) {
CFSecuritySecAppBuff updatedBuff = unpackSecAppResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, "
+ resultSet.getRow()
+ " rows selected");
}
Buff.setRequiredJEEMountName(updatedBuff.getRequiredJEEMountName());
Buff.setRequiredRevision(updatedBuff.getRequiredRevision());
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected a single-record response, " + resultSet.getRow() + " rows selected");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "upd_secapp() did not return a valid result cursor");
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(), S_ProcName, "upd_secapp() did not return a result cursor");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
}
stmtUpdateByPKey = null;
}
}
}
public CFSecuritySecAppBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecuritySecAppPKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
Connection cnx = schema.getCnx();
CallableStatement stmtLockBuffByPKey = null;
try {
long ClusterId = PKey.getRequiredClusterId();
int SecAppId = PKey.getRequiredSecAppId();
stmtLockBuffByPKey =
cnx.prepareCall(
"begin "
+ schema.getLowerDbSchemaName()
+ ".lck_secapp( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ); end;");
int argIdx = 1;
stmtLockBuffByPKey.registerOutParameter(argIdx++, OracleTypes.CURSOR);
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtLockBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtLockBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtLockBuffByPKey.setLong(argIdx++, ClusterId);
stmtLockBuffByPKey.setInt(argIdx++, SecAppId);
stmtLockBuffByPKey.execute();
resultSet = (ResultSet) stmtLockBuffByPKey.getObject(1);
if (resultSet == null) {
return (null);
}
try {
if (resultSet.next()) {
CFSecuritySecAppBuff buff = unpackSecAppResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, "
+ resultSet.getRow()
+ " rows selected");
}
return (buff);
} else {
return (null);
}
} catch (SQLException e) {
return (null);
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
}
stmtLockBuffByPKey = null;
}
}
}