public CFSecurityISOCountryLanguageBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguagePKey PKey) {
final String S_ProcName = "lockBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOCountryId = PKey.getRequiredISOCountryId();
short ISOLanguageId = PKey.getRequiredISOLanguageId();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_lock_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtLockBuffByPKey == null) {
stmtLockBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
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.setShort(argIdx++, ISOCountryId);
stmtLockBuffByPKey.setShort(argIdx++, ISOLanguageId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOCountryLanguageBuff buff = unpackISOCountryLanguageResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
return (buff);
} else {
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;
}
}
}
public void deleteISOCountryLanguageByIdIdx(
CFSecurityAuthorization Authorization, short argISOCountryId, short argISOLanguageId) {
final String S_ProcName = "deleteISOCountryLanguageByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng_by_ididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByIdIdx == null) {
stmtDeleteByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByIdIdx.setShort(argIdx++, argISOCountryId);
stmtDeleteByIdIdx.setShort(argIdx++, argISOLanguageId);
resultSet = stmtDeleteByIdIdx.executeQuery();
if (resultSet.next()) {
boolean deleteFlag = resultSet.getBoolean(1);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
} else {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Expected 1 record result set to be returned by delete, not 0 rows");
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
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 void deleteSecAppByIdIdx(
CFSecurityAuthorization Authorization, long argClusterId, int argSecAppId) {
final String S_ProcName = "deleteSecAppByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"begin call "
+ schema.getLowerDbSchemaName()
+ ".dl_secappbyididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ); end";
if (stmtDeleteByIdIdx == null) {
stmtDeleteByIdIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByIdIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIdIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByIdIdx.setLong(argIdx++, argClusterId);
stmtDeleteByIdIdx.setInt(argIdx++, argSecAppId);
int rowsUpdated = stmtDeleteByIdIdx.executeUpdate();
} 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 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;
}
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
final String S_ProcName = "releasePreparedStatements";
S_sqlSelectISOCountryLanguageDistinctClassCode = null;
S_sqlSelectISOCountryLanguageBuff = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
}
stmtReadBuffByPKey = null;
}
if (stmtReadBuffAll != null) {
try {
stmtReadBuffAll.close();
} catch (SQLException e) {
}
stmtReadBuffAll = null;
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
}
stmtLockBuffByPKey = null;
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
}
stmtCreateByPKey = null;
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
}
stmtUpdateByPKey = null;
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
}
stmtDeleteByPKey = null;
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByCountryIdx != null) {
try {
stmtDeleteByCountryIdx.close();
} catch (SQLException e) {
}
stmtDeleteByCountryIdx = null;
}
if (stmtDeleteByLanguageIdx != null) {
try {
stmtDeleteByLanguageIdx.close();
} catch (SQLException e) {
}
stmtDeleteByLanguageIdx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
}
stmtReadAllBuff = null;
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByCountryIdx != null) {
try {
stmtReadBuffByCountryIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByCountryIdx = null;
}
if (stmtReadBuffByLanguageIdx != null) {
try {
stmtReadBuffByLanguageIdx.close();
} catch (SQLException e) {
}
stmtReadBuffByLanguageIdx = null;
}
}
/**
* Release the prepared statements.
*
* <p>When the schema changes connections, the prepared statements have to be released because
* they contain connection-specific information for most databases.
*/
public void releasePreparedStatements() {
final String S_ProcName = "releasePreparedStatements";
S_sqlSelectSecAppBuff = null;
S_sqlSelectSecAppDistinctClassCode = null;
if (stmtReadBuffByPKey != null) {
try {
stmtReadBuffByPKey.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtReadBuffByPKey = null;
}
}
if (stmtLockBuffByPKey != null) {
try {
stmtLockBuffByPKey.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtLockBuffByPKey = null;
}
}
if (stmtCreateByPKey != null) {
try {
stmtCreateByPKey.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtCreateByPKey = null;
}
}
if (stmtUpdateByPKey != null) {
try {
stmtUpdateByPKey.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtUpdateByPKey = null;
}
}
if (stmtDeleteByPKey != null) {
try {
stmtDeleteByPKey.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtDeleteByPKey = null;
}
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByClusterIdx != null) {
try {
stmtDeleteByClusterIdx.close();
} catch (SQLException e) {
}
stmtDeleteByClusterIdx = null;
}
if (stmtDeleteByUJEEMountIdx != null) {
try {
stmtDeleteByUJEEMountIdx.close();
} catch (SQLException e) {
}
stmtDeleteByUJEEMountIdx = null;
}
if (stmtReadAllBuff != null) {
try {
stmtReadAllBuff.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
stmtReadAllBuff = null;
}
}
if (stmtReadBuffByIdIdx != null) {
try {
stmtReadBuffByIdIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtReadBuffByIdIdx = null;
}
if (stmtReadBuffByClusterIdx != null) {
try {
stmtReadBuffByClusterIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtReadBuffByClusterIdx = null;
}
if (stmtReadBuffByUJEEMountIdx != null) {
try {
stmtReadBuffByUJEEMountIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtReadBuffByUJEEMountIdx = null;
}
if (stmtDeleteByIdIdx != null) {
try {
stmtDeleteByIdIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtDeleteByIdIdx = null;
}
if (stmtDeleteByClusterIdx != null) {
try {
stmtDeleteByClusterIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtDeleteByClusterIdx = null;
}
if (stmtDeleteByUJEEMountIdx != null) {
try {
stmtDeleteByUJEEMountIdx.close();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
stmtDeleteByUJEEMountIdx = null;
}
}
