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 void deleteTSecGroupByIdIdx(
CFSecurityAuthorization Authorization, CFSecurityTSecGroupPKey argKey) {
deleteTSecGroupByIdIdx(
Authorization, argKey.getRequiredTenantId(), argKey.getRequiredTSecGroupId());
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFBamXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
// Primary Key Attributes for Constant Enum support
String attrTenantId = null;
String attrTSecGroupId = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstTSecGroupRead");
CFBamXMsgRqstHandler xmsgRqstHandler = (CFBamXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFBamSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Instantiate a PKey buffer for the parsed information
CFSecurityTSecGroupPKey pkey =
((ICFBamSchema) schemaObj.getBackingStore()).getFactoryTSecGroup().newPKey();
// 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("TenantId")) {
if (attrTenantId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrTenantId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("TSecGroupId")) {
if (attrTSecGroupId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrTSecGroupId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("schemaLocation")) {
// ignored
} else {
throw CFLib.getDefaultExceptionFactory()
.newUnrecognizedAttributeException(
getClass(), S_ProcName, getParser().getLocationInfo(), attrLocalName);
}
}
// Ensure that required attributes have values
if ((attrTenantId == null) || (attrTenantId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "TenantId");
}
if ((attrTSecGroupId == null) || (attrTSecGroupId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "TSecGroupId");
}
// Get current context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Convert string attributes to native Java types
// and apply the converted attributes to the editBuff.
long natTenantId;
natTenantId = Long.parseLong(attrTenantId);
pkey.setRequiredTenantId(natTenantId);
pkey.setRequiredTenantId(natTenantId);
int natTSecGroupId;
natTSecGroupId = Integer.parseInt(attrTSecGroupId);
pkey.setRequiredTSecGroupId(natTSecGroupId);
pkey.setRequiredTSecGroupId(natTSecGroupId);
// Read the object and prepare the XML response
ICFBamTSecGroupObj read =
((ICFBamTSecGroupObj) schemaObj.getTSecGroupTableObj().readTSecGroup(pkey, true));
if (read != null) {
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgTSecGroupMessageFormatter.formatTSecGroupRspnSingleOpenTag()
+ CFBamXMsgTSecGroupMessageFormatter.formatTSecGroupRspnDerivedRec(
"\n\t\t", read.getTSecGroupBuff())
+ "\n"
+ "\t"
+ CFBamXMsgTSecGroupMessageFormatter.formatTSecGroupRspnSingleCloseTag()
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.appendResponse(response);
} else {
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgSchemaMessageFormatter.formatRspnNoDataFound()
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.appendResponse(response);
}
} catch (RuntimeException e) {
CFBamXMsgRqstHandler xmsgRqstHandler = ((CFBamXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFBamXMsgRqstHandler xmsgRqstHandler = ((CFBamXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFBamXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}