public void updateServiceType(
CFSecurityAuthorization Authorization, CFSecurityServiceTypeBuff Buff) {
final String S_ProcName = "updateServiceType";
ResultSet resultSet = null;
try {
int ServiceTypeId = Buff.getRequiredServiceTypeId();
String Description = Buff.getRequiredDescription();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql = "exec sp_update_svctype ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?";
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++, "SVCT");
stmtUpdateByPKey.setInt(argIdx++, ServiceTypeId);
stmtUpdateByPKey.setString(argIdx++, Description);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityServiceTypeBuff updatedBuff = unpackServiceTypeResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredDescription(updatedBuff.getRequiredDescription());
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 CFSecurityTSecGroupBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityTSecGroupPKey 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();
long TenantId = PKey.getRequiredTenantId();
int TSecGroupId = PKey.getRequiredTSecGroupId();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_lock_tsecgrp( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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.setLong(argIdx++, TenantId);
stmtLockBuffByPKey.setInt(argIdx++, TSecGroupId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityTSecGroupBuff buff = unpackTSecGroupResultSetToBuff(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 CFSecuritySecDeviceBuff[] readBuffByUserIdx(
CFSecurityAuthorization Authorization, UUID SecUserId) {
final String S_ProcName = "readBuffByUserIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_read_secdev_by_useridx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByUserIdx == null) {
stmtReadBuffByUserIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUserIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUserIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUserIdx.setString(argIdx++, SecUserId.toString());
try {
resultSet = stmtReadBuffByUserIdx.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecuritySecDeviceBuff> buffList = new LinkedList<CFSecuritySecDeviceBuff>();
while ((resultSet != null) && resultSet.next()) {
CFSecuritySecDeviceBuff buff = unpackSecDeviceResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecuritySecDeviceBuff[] retBuff = new CFSecuritySecDeviceBuff[buffList.size()];
Iterator<CFSecuritySecDeviceBuff> 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;
}
}
}
/* return status codes for account/device */
public static int[] getStatusCodes(String accountID, String deviceID) throws DBException {
/* account-id specified? */
if (StringTools.isBlank(accountID)) {
return new int[0];
}
/* device-id specified? */
if (StringTools.isBlank(deviceID)) {
deviceID = ALL_DEVICES;
}
/* select */
// DBSelect: SELECT statucCode FROM StatusCode WHERE (accountID='acct') AND (deviceID='*') ORDER
// BY statucCode
DBSelect<StatusCode> dsel = new DBSelect<StatusCode>(StatusCode.getFactory());
dsel.setSelectedFields(StatusCode.FLD_statusCode);
DBWhere dwh = dsel.createDBWhere();
dsel.setWhere(
dwh.WHERE_(
dwh.AND(
dwh.EQ(StatusCode.FLD_accountID, accountID),
dwh.EQ(StatusCode.FLD_deviceID, deviceID))));
dsel.setOrderByFields(StatusCode.FLD_statusCode);
/* get list */
java.util.List<Integer> codeList = new Vector<Integer>();
Statement stmt = null;
ResultSet rs = null;
try {
stmt = DBConnection.getDefaultConnection().execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
int code = rs.getInt(StatusCode.FLD_statusCode);
codeList.add(new Integer(code));
}
} catch (SQLException sqe) {
throw new DBException("Getting StatusCode List", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
}
/* return array of status codes */
int codeListInt[] = new int[codeList.size()];
for (int i = 0; i < codeListInt.length; i++) {
codeListInt[i] = codeList.get(i).intValue();
}
return codeListInt;
}
public void deleteISOTimezone(
CFSecurityAuthorization Authorization, CFSecurityISOTimezoneBuff Buff) {
final String S_ProcName = "deleteISOTimezone";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOTimezoneId = Buff.getRequiredISOTimezoneId();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_isotz( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setShort(argIdx++, ISOTimezoneId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
resultSet = stmtDeleteByPKey.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 void deleteTSecGroupByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
final String S_ProcName = "deleteTSecGroupByTenantVisIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_delete_tsecgrp_by_tenantvisidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtDeleteByTenantVisIdx == null) {
stmtDeleteByTenantVisIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByTenantVisIdx.setLong(argIdx++, TenantId);
if (IsVisible) {
stmtDeleteByTenantVisIdx.setString(argIdx++, "Y");
} else {
stmtDeleteByTenantVisIdx.setString(argIdx++, "N");
}
Object stuff = null;
boolean moreResults = stmtDeleteByTenantVisIdx.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByTenantVisIdx.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByTenantVisIdx.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByTenantVisIdx.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFInternetTopDomainBuff readBuffByNameIdx(
CFSecurityAuthorization Authorization, long TenantId, long TldId, String Name) {
final String S_ProcName = "readBuffByNameIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql =
"CALL sp_read_tdomdef_by_nameidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByNameIdx == null) {
stmtReadBuffByNameIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByNameIdx.setLong(argIdx++, TenantId);
stmtReadBuffByNameIdx.setLong(argIdx++, TldId);
stmtReadBuffByNameIdx.setString(argIdx++, Name);
resultSet = stmtReadBuffByNameIdx.executeQuery();
if (resultSet.next()) {
CFInternetTopDomainBuff buff = unpackTopDomainResultSetToBuff(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) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmContactTagBuff readBuff(
CFSecurityAuthorization Authorization, CFCrmContactTagPKey PKey) {
final String S_ProcName = "readBuff";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long TenantId = PKey.getRequiredTenantId();
long ContactId = PKey.getRequiredContactId();
long TagId = PKey.getRequiredTagId();
String sql =
"{ call sp_read_ctc_tag( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " ) }";
if (stmtReadBuffByPKey == null) {
stmtReadBuffByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByPKey.setLong(argIdx++, TenantId);
stmtReadBuffByPKey.setLong(argIdx++, ContactId);
stmtReadBuffByPKey.setLong(argIdx++, TagId);
resultSet = stmtReadBuffByPKey.executeQuery();
if ((resultSet != null) && resultSet.next()) {
CFCrmContactTagBuff buff = unpackContactTagResultSetToBuff(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) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFSecurityISOCountryLanguageBuff[] 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 " + schema.getLowerDbSchemaName() + ".sp_read_iso_cntrylng_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());
try {
resultSet = stmtReadAllBuff.executeQuery();
} catch (SQLException e) {
if (e.getErrorCode() != 1329) {
throw e;
}
resultSet = null;
}
List<CFSecurityISOCountryLanguageBuff> buffList =
new LinkedList<CFSecurityISOCountryLanguageBuff>();
while ((resultSet != null) && 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 deleteTopDomain(CFSecurityAuthorization Authorization, CFInternetTopDomainBuff Buff) {
final String S_ProcName = "deleteTopDomain";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
long TenantId = Buff.getRequiredTenantId();
long Id = Buff.getRequiredId();
final String sql =
"CALL sp_delete_tdomdef( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + ", " + "?" + " )";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setLong(argIdx++, TenantId);
stmtDeleteByPKey.setLong(argIdx++, Id);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
resultSet = stmtDeleteByPKey.executeQuery();
if (resultSet.next()) {
int deleteFlag = resultSet.getInt(1);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
} 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 void deleteTSecGroupByUNameIdx(
CFSecurityAuthorization Authorization, long argTenantId, String argName) {
final String S_ProcName = "deleteTSecGroupByUNameIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_tsecgrp_by_unameidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) as DeletedFlag";
if (stmtDeleteByUNameIdx == null) {
stmtDeleteByUNameIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByUNameIdx.setLong(argIdx++, argTenantId);
stmtDeleteByUNameIdx.setString(argIdx++, argName);
resultSet = stmtDeleteByUNameIdx.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 void deleteURLProtocolByIsSecureIdx(
CFSecurityAuthorization Authorization, boolean argIsSecure) {
final String S_ProcName = "deleteURLProtocolByIsSecureIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql =
"CALL sp_delete_urlproto_by_issecureidx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtDeleteByIsSecureIdx == null) {
stmtDeleteByIsSecureIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByIsSecureIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIsSecureIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByIsSecureIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByIsSecureIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByIsSecureIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (argIsSecure) {
stmtDeleteByIsSecureIdx.setString(argIdx++, "Y");
} else {
stmtDeleteByIsSecureIdx.setString(argIdx++, "N");
}
resultSet = stmtDeleteByIsSecureIdx.executeQuery();
if (resultSet.next()) {
int deleteFlag = resultSet.getInt(1);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
} 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 CFSecurityISOCountryCurrencyBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityISOCountryCurrencyPKey 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 ISOCurrencyId = PKey.getRequiredISOCurrencyId();
final String sql =
"CALL sp_lock_iso_cntryccy( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
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++, ISOCurrencyId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityISOCountryCurrencyBuff buff = unpackISOCountryCurrencyResultSetToBuff(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) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public void deleteISOTimezoneByOffsetIdx(
CFSecurityAuthorization Authorization, short argTZHourOffset, short argTZMinOffset) {
final String S_ProcName = "deleteISOTimezoneByOffsetIdx";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_delete_isotz_by_offsetidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtDeleteByOffsetIdx == null) {
stmtDeleteByOffsetIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByOffsetIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByOffsetIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByOffsetIdx.setShort(argIdx++, argTZHourOffset);
stmtDeleteByOffsetIdx.setShort(argIdx++, argTZMinOffset);
Object stuff = null;
boolean moreResults = stmtDeleteByOffsetIdx.execute();
while (stuff == null) {
try {
moreResults = stmtDeleteByOffsetIdx.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
stuff = stmtDeleteByOffsetIdx.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtDeleteByOffsetIdx.getUpdateCount()) {
break;
}
}
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
public CFCrmMemoDataBuff[] readBuffByMemoDataCtcIdx(
CFSecurityAuthorization Authorization, long TenantId, long ContactId) {
final String S_ProcName = "readBuffByMemoDataCtcIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_memodata_by_memodatactcidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ) }";
if (stmtReadBuffByMemoDataCtcIdx == null) {
stmtReadBuffByMemoDataCtcIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByMemoDataCtcIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByMemoDataCtcIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, TenantId);
stmtReadBuffByMemoDataCtcIdx.setLong(argIdx++, ContactId);
resultSet = stmtReadBuffByMemoDataCtcIdx.executeQuery();
List<CFCrmMemoDataBuff> buffList = new LinkedList<CFCrmMemoDataBuff>();
if (resultSet != null) {
while (resultSet.next()) {
CFCrmMemoDataBuff buff = unpackMemoDataResultSetToBuff(resultSet);
buffList.add(buff);
}
}
int idx = 0;
CFCrmMemoDataBuff[] retBuff = new CFCrmMemoDataBuff[buffList.size()];
Iterator<CFCrmMemoDataBuff> 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 =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".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>();
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 CFSecurityTSecGroupBuff readBuffByUNameIdx(
CFSecurityAuthorization Authorization, long TenantId, String Name) {
final String S_ProcName = "readBuffByUNameIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_read_tsecgrp_by_unameidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtReadBuffByUNameIdx == null) {
stmtReadBuffByUNameIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUNameIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUNameIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUNameIdx.setLong(argIdx++, TenantId);
stmtReadBuffByUNameIdx.setString(argIdx++, Name);
resultSet = stmtReadBuffByUNameIdx.executeQuery();
if (resultSet.next()) {
CFSecurityTSecGroupBuff buff = unpackTSecGroupResultSetToBuff(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 CFSecurityTSecGroupBuff[] readBuffByTenantVisIdx(
CFSecurityAuthorization Authorization, long TenantId, boolean IsVisible) {
final String S_ProcName = "readBuffByTenantVisIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql = "exec sp_read_tsecgrp_by_tenantvisidx ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?";
if (stmtReadBuffByTenantVisIdx == null) {
stmtReadBuffByTenantVisIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByTenantVisIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByTenantVisIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByTenantVisIdx.setLong(argIdx++, TenantId);
if (IsVisible) {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "Y");
} else {
stmtReadBuffByTenantVisIdx.setString(argIdx++, "N");
}
resultSet = stmtReadBuffByTenantVisIdx.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 CFSecurityISOLanguageBuff[] readBuffByCode2Idx(
CFSecurityAuthorization Authorization, String ISO6391Code) {
final String S_ProcName = "readBuffByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
final String sql = "CALL sp_read_iso_lang_by_code2idx( ?, ?, ?, ?, ?" + ", " + "?" + " )";
if (stmtReadBuffByCode2Idx == null) {
stmtReadBuffByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (ISO6391Code != null) {
stmtReadBuffByCode2Idx.setString(argIdx++, ISO6391Code);
} else {
stmtReadBuffByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
resultSet = stmtReadBuffByCode2Idx.executeQuery();
List<CFSecurityISOLanguageBuff> buffList = new LinkedList<CFSecurityISOLanguageBuff>();
while (resultSet.next()) {
CFSecurityISOLanguageBuff buff = unpackISOLanguageResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFSecurityISOLanguageBuff[] retBuff = new CFSecurityISOLanguageBuff[buffList.size()];
Iterator<CFSecurityISOLanguageBuff> 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 deleteISOCountryLanguage(
CFSecurityAuthorization Authorization, CFSecurityISOCountryLanguageBuff Buff) {
final String S_ProcName = "deleteISOCountryLanguage";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
short ISOCountryId = Buff.getRequiredISOCountryId();
short ISOLanguageId = Buff.getRequiredISOLanguageId();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_cntrylng( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtDeleteByPKey == null) {
stmtDeleteByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByPKey.setShort(argIdx++, ISOCountryId);
stmtDeleteByPKey.setShort(argIdx++, ISOLanguageId);
stmtDeleteByPKey.setInt(argIdx++, Buff.getRequiredRevision());
;
stmtDeleteByPKey.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 CFSecurityHostNodeBuff readBuffByUDescrIdx(
CFSecurityAuthorization Authorization, long ClusterId, String Description) {
final String S_ProcName = "readBuffByUDescrIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"{ call sp_read_hostnode_by_udescridx( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
if (stmtReadBuffByUDescrIdx == null) {
stmtReadBuffByUDescrIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtReadBuffByUDescrIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtReadBuffByUDescrIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtReadBuffByUDescrIdx.setLong(argIdx++, ClusterId);
stmtReadBuffByUDescrIdx.setString(argIdx++, Description);
resultSet = stmtReadBuffByUDescrIdx.executeQuery();
if ((resultSet != null) && resultSet.next()) {
CFSecurityHostNodeBuff buff = unpackHostNodeResultSetToBuff(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) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
} finally {
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
}
resultSet = null;
}
}
}
/* return list of all Devices within the specified DeviceGroup (NOT SCALABLE BEYOND A FEW HUNDRED GROUPS) */
public static java.util.List<String> getUsersForGroup(String acctId, String groupId)
throws DBException {
/* valid account/groupId? */
if (StringTools.isBlank(acctId)) {
return null;
} else if (StringTools.isBlank(groupId)) {
return null;
}
/* get db selector */
DBSelect dsel = GroupList._getUserListSelect(acctId, groupId);
if (dsel == null) {
return null;
}
/* read users for group */
java.util.List<String> usrList = new Vector<String>();
DBConnection dbc = null;
Statement stmt = null;
ResultSet rs = null;
try {
dbc = DBConnection.getDefaultConnection();
stmt = dbc.execute(dsel.toString());
rs = stmt.getResultSet();
while (rs.next()) {
String usrId = rs.getString(GroupList.FLD_userID);
usrList.add(usrId);
}
} catch (SQLException sqe) {
throw new DBException("Get Group GroupeList", sqe);
} finally {
if (rs != null) {
try {
rs.close();
} catch (Throwable t) {
}
}
if (stmt != null) {
try {
stmt.close();
} catch (Throwable t) {
}
}
DBConnection.release(dbc);
}
/* return list */
return usrList;
}
public void deleteSecFormByUJEEServletIdx(
CFSecurityAuthorization Authorization,
long argClusterId,
int argSecAppId,
String argJEEServletMapName) {
final String S_ProcName = "deleteSecFormByUJEEServletIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_secform_by_ujeeservletidx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
if (stmtDeleteByUJEEServletIdx == null) {
stmtDeleteByUJEEServletIdx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByUJEEServletIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUJEEServletIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByUJEEServletIdx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByUJEEServletIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByUJEEServletIdx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtDeleteByUJEEServletIdx.setLong(argIdx++, argClusterId);
stmtDeleteByUJEEServletIdx.setInt(argIdx++, argSecAppId);
stmtDeleteByUJEEServletIdx.setString(argIdx++, argJEEServletMapName);
stmtDeleteByUJEEServletIdx.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 CFBamAccessFrequencyBuff[] 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();
final String sql = "CALL sp_read_accfreq_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<CFBamAccessFrequencyBuff> buffList = new LinkedList<CFBamAccessFrequencyBuff>();
while (resultSet.next()) {
CFBamAccessFrequencyBuff buff = unpackAccessFrequencyResultSetToBuff(resultSet);
buffList.add(buff);
}
int idx = 0;
CFBamAccessFrequencyBuff[] retBuff = new CFBamAccessFrequencyBuff[buffList.size()];
Iterator<CFBamAccessFrequencyBuff> 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 deleteISOLanguageByCode2Idx(
CFSecurityAuthorization Authorization, String argISO6391Code) {
final String S_ProcName = "deleteISOLanguageByCode2Idx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"call "
+ schema.getLowerDbSchemaName()
+ ".sp_delete_iso_lang_by_code2idx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ " )";
if (stmtDeleteByCode2Idx == null) {
stmtDeleteByCode2Idx = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtDeleteByCode2Idx.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtDeleteByCode2Idx.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
if (argISO6391Code != null) {
stmtDeleteByCode2Idx.setString(argIdx++, argISO6391Code);
} else {
stmtDeleteByCode2Idx.setNull(argIdx++, java.sql.Types.VARCHAR);
}
stmtDeleteByCode2Idx.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 deleteSecGroupByIdIdx(
CFSecurityAuthorization Authorization, long argClusterId, int argSecGroupId) {
final String S_ProcName = "deleteSecGroupByIdIdx";
ResultSet resultSet = null;
try {
Connection cnx = schema.getCnx();
String sql =
"begin call "
+ schema.getLowerDbSchemaName()
+ ".dl_secgrpbyididx( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " ); 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++, argSecGroupId);
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;
}
}
}
/**
* Gets the instances of <CODE>Template</CODE> that have an ID that is already in the database.
*
* @return An <CODE>ArrayList</CODE> containing the instances of <CODE>Template</CODE> already in
* the database.
* @throws java.sql.SQLException Thrown on sql exception.
*/
public ArrayList findTemplatesInDatabase() throws java.sql.SQLException {
ArrayList templatesInDatabase = new ArrayList();
Connection oracleConnection = getDataSource().getConnection();
try {
Statement query = oracleConnection.createStatement();
try {
StringBuffer sql = new StringBuffer("SELECT TMPL_ID FROM ");
sql.append(MPSBrowserView.SCHEMA);
sql.append(".TEMPLATE WHERE TMPL_ID IN (");
ArrayList templates = getTemplates();
int templateCount = templates.size();
for (int i = 0; i < templateCount; i++) {
if (i > 0) sql.append(", ");
sql.append("'");
sql.append(((Template) templates.get(i)).getID());
sql.append("'");
}
sql.append(")");
ResultSet result = query.executeQuery(sql.toString());
try {
while (result.next()) {
String templateID = result.getString("TMPL_ID");
for (int i = 0; i < templateCount; i++) {
Template currentTemplate = (Template) templates.get(i);
if (templateID.equals(currentTemplate.getID())) {
templatesInDatabase.add(currentTemplate);
currentTemplate.setInDatabase(true);
}
}
}
} finally {
result.close();
}
} finally {
query.close();
}
} finally {
oracleConnection.close();
}
return templatesInDatabase;
}
public void updateISOCountry(
CFSecurityAuthorization Authorization, CFSecurityISOCountryBuff Buff) {
final String S_ProcName = "updateISOCountry";
ResultSet resultSet = null;
try {
short Id = Buff.getRequiredId();
String ISOCode = Buff.getRequiredISOCode();
String Name = Buff.getRequiredName();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"exec sp_update_iso_cntry ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?";
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++, "ISOC");
stmtUpdateByPKey.setShort(argIdx++, Id);
stmtUpdateByPKey.setString(argIdx++, ISOCode);
stmtUpdateByPKey.setString(argIdx++, Name);
stmtUpdateByPKey.setInt(argIdx++, Revision);
stmtUpdateByPKey.execute();
boolean moreResults = true;
resultSet = null;
while (resultSet == null) {
try {
moreResults = stmtUpdateByPKey.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
resultSet = stmtUpdateByPKey.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtUpdateByPKey.getUpdateCount()) {
break;
}
}
if (resultSet == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "resultSet");
}
if (resultSet.next()) {
CFSecurityISOCountryBuff updatedBuff = unpackISOCountryResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredISOCode(updatedBuff.getRequiredISOCode());
Buff.setRequiredName(updatedBuff.getRequiredName());
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 void createAccessSecurity(CFBamAuthorization Authorization, CFBamAccessSecurityBuff Buff) {
final String S_ProcName = "createAccessSecurity";
if (!schema.isTransactionOpen()) {
throw CFLib.getDefaultExceptionFactory()
.newUsageException(getClass(), S_ProcName, "Transaction not open");
}
ResultSet resultSet = null;
try {
short Id = Buff.getRequiredId();
String Name = Buff.getRequiredName();
Connection cnx = schema.getCnx();
final String sql = "CALL sp_create_accsec( ?, ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " )";
if (stmtCreateByPKey == null) {
stmtCreateByPKey = cnx.prepareStatement(sql);
}
int argIdx = 1;
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtCreateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecUserId().toString());
stmtCreateByPKey.setString(
argIdx++, (Authorization == null) ? "" : Authorization.getSecSessionId().toString());
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecClusterId());
stmtCreateByPKey.setLong(
argIdx++, (Authorization == null) ? 0 : Authorization.getSecTenantId());
stmtCreateByPKey.setString(argIdx++, "ASEC");
stmtCreateByPKey.setShort(argIdx++, Id);
stmtCreateByPKey.setString(argIdx++, Name);
resultSet = stmtCreateByPKey.executeQuery();
if (resultSet.next()) {
CFBamAccessSecurityBuff createdBuff = unpackAccessSecurityResultSetToBuff(resultSet);
if (resultSet.next()) {
resultSet.last();
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(
getClass(),
S_ProcName,
"Did not expect multi-record response, " + resultSet.getRow() + " rows selected");
}
Buff.setRequiredId(createdBuff.getRequiredId());
Buff.setRequiredName(createdBuff.getRequiredName());
Buff.setRequiredRevision(createdBuff.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 void updateTSecGroup(CFSecurityAuthorization Authorization, CFSecurityTSecGroupBuff Buff) {
final String S_ProcName = "updateTSecGroup";
ResultSet resultSet = null;
try {
long TenantId = Buff.getRequiredTenantId();
int TSecGroupId = Buff.getRequiredTSecGroupId();
String Name = Buff.getRequiredName();
int Revision = Buff.getRequiredRevision();
Connection cnx = schema.getCnx();
String sql =
"select * from "
+ schema.getLowerDbSchemaName()
+ ".sp_update_tsecgrp( ?, ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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++, "TGRP");
stmtUpdateByPKey.setLong(argIdx++, TenantId);
stmtUpdateByPKey.setInt(argIdx++, TSecGroupId);
stmtUpdateByPKey.setString(argIdx++, Name);
stmtUpdateByPKey.setInt(argIdx++, Revision);
resultSet = stmtUpdateByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityTSecGroupBuff updatedBuff = unpackTSecGroupResultSetToBuff(resultSet);
if (resultSet.next()) {
throw CFLib.getDefaultExceptionFactory()
.newRuntimeException(getClass(), S_ProcName, "Did not expect multi-record response");
}
Buff.setRequiredName(updatedBuff.getRequiredName());
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;
}
}
}