public CFSecurityHostNodeBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey 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 ClusterId = PKey.getRequiredClusterId();
long HostNodeId = PKey.getRequiredHostNodeId();
String sql =
"SELECT * FROM "
+ schema.getLowerDbSchemaName()
+ ".sp_lock_hostnode( ?, ?, ?, ?, ?"
+ ", "
+ "?"
+ ", "
+ "?"
+ " )";
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++, ClusterId);
stmtLockBuffByPKey.setLong(argIdx++, HostNodeId);
resultSet = stmtLockBuffByPKey.executeQuery();
if (resultSet.next()) {
CFSecurityHostNodeBuff buff = unpackHostNodeResultSetToBuff(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 deleteHostNodeByIdIdx(
CFSecurityAuthorization Authorization, long argClusterId, long argHostNodeId) {
CFSecurityHostNodePKey key = schema.getFactoryHostNode().newPKey();
key.setRequiredClusterId(argClusterId);
key.setRequiredHostNodeId(argHostNodeId);
deleteHostNodeByIdIdx(Authorization, key);
}
public CFSecurityHostNodeBuff lockDerived(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey PKey) {
final String S_ProcName = "CFAccRamHostNode.readDerived";
CFSecurityHostNodePKey key = schema.getFactoryHostNode().newPKey();
key.setRequiredClusterId(PKey.getRequiredClusterId());
key.setRequiredHostNodeId(PKey.getRequiredHostNodeId());
CFSecurityHostNodeBuff buff;
if (dictByPKey.containsKey(key)) {
buff = dictByPKey.get(key);
} else {
buff = null;
}
return (buff);
}
public CFSecurityHostNodeBuff readDerivedByIdIdx(
CFSecurityAuthorization Authorization, long ClusterId, long HostNodeId) {
final String S_ProcName = "CFBamRamHostNode.readDerivedByIdIdx() ";
CFSecurityHostNodePKey key = schema.getFactoryHostNode().newPKey();
key.setRequiredClusterId(ClusterId);
key.setRequiredHostNodeId(HostNodeId);
CFSecurityHostNodeBuff buff;
if (dictByPKey.containsKey(key)) {
buff = dictByPKey.get(key);
} else {
buff = null;
}
return (buff);
}
public void deleteHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "CFAccRamHostNodeTable.deleteHostNode() ";
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(Buff.getRequiredHostNodeId());
CFSecurityHostNodeBuff existing = dictByPKey.get(pkey);
if (existing == null) {
return;
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "deleteHostNode", pkey);
}
CFSecurityHostNodeByClusterIdxKey keyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
keyClusterIdx.setRequiredClusterId(existing.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey keyUDescrIdx = schema.getFactoryHostNode().newUDescrIdxKey();
keyUDescrIdx.setRequiredClusterId(existing.getRequiredClusterId());
keyUDescrIdx.setRequiredDescription(existing.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey keyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
keyHostNameIdx.setRequiredClusterId(existing.getRequiredClusterId());
keyHostNameIdx.setRequiredHostName(existing.getRequiredHostName());
// Validate reverse foreign keys
// Delete is valid
schema
.getTableService()
.deleteServiceByHostIdx(
Authorization, Buff.getRequiredClusterId(), Buff.getRequiredHostNodeId());
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdict;
dictByPKey.remove(pkey);
subdict = dictByClusterIdx.get(keyClusterIdx);
subdict.remove(pkey);
dictByUDescrIdx.remove(keyUDescrIdx);
dictByHostNameIdx.remove(keyHostNameIdx);
}
public void deleteHostNodeByIdIdx(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey argKey) {
CFSecurityHostNodeBuff cur;
LinkedList<CFSecurityHostNodeBuff> matchSet = new LinkedList<CFSecurityHostNodeBuff>();
Iterator<CFSecurityHostNodeBuff> values = dictByPKey.values().iterator();
while (values.hasNext()) {
cur = values.next();
if (argKey.equals(cur)) {
matchSet.add(cur);
}
}
Iterator<CFSecurityHostNodeBuff> iterMatch = matchSet.iterator();
while (iterMatch.hasNext()) {
cur = iterMatch.next();
deleteHostNode(Authorization, cur);
}
}
public void deleteHostNodeByIdIdx(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey argKey) {
deleteHostNodeByIdIdx(
Authorization, argKey.getRequiredClusterId(), argKey.getRequiredHostNodeId());
}
public CFSecurityHostNodeBuff lockBuff(
CFSecurityAuthorization Authorization, CFSecurityHostNodePKey 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 ClusterId = PKey.getRequiredClusterId();
long HostNodeId = PKey.getRequiredHostNodeId();
String sql = "{ call sp_lock_hostnode( ?, ?, ?, ?, ?" + ", " + "?" + ", " + "?" + " ) }";
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++, ClusterId);
stmtLockBuffByPKey.setLong(argIdx++, HostNodeId);
stmtLockBuffByPKey.execute();
boolean moreResults = true;
resultSet = null;
while (resultSet == null) {
try {
moreResults = stmtLockBuffByPKey.getMoreResults();
} catch (SQLException e) {
throw CFLib.getDefaultExceptionFactory().newDbException(getClass(), S_ProcName, e);
}
if (moreResults) {
try {
resultSet = stmtLockBuffByPKey.getResultSet();
} catch (SQLException e) {
}
} else if (-1 == stmtLockBuffByPKey.getUpdateCount()) {
break;
}
}
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;
}
}
}
public void createHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
final String S_ProcName = "createHostNode";
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(
((CFAccRamClusterTable) schema.getTableCluster())
.nextHostNodeIdGen(Authorization, Buff.getRequiredClusterId()));
Buff.setRequiredClusterId(pkey.getRequiredClusterId());
Buff.setRequiredHostNodeId(pkey.getRequiredHostNodeId());
CFSecurityHostNodeByClusterIdxKey keyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
keyClusterIdx.setRequiredClusterId(Buff.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey keyUDescrIdx = schema.getFactoryHostNode().newUDescrIdxKey();
keyUDescrIdx.setRequiredClusterId(Buff.getRequiredClusterId());
keyUDescrIdx.setRequiredDescription(Buff.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey keyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
keyHostNameIdx.setRequiredClusterId(Buff.getRequiredClusterId());
keyHostNameIdx.setRequiredHostName(Buff.getRequiredHostName());
// Validate unique indexes
if (dictByPKey.containsKey(pkey)) {
throw CFLib.getDefaultExceptionFactory()
.newPrimaryKeyNotNewException(getClass(), S_ProcName, pkey);
}
if (dictByUDescrIdx.containsKey(keyUDescrIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, "HostNodeUDescrIdx", keyUDescrIdx);
}
if (dictByHostNameIdx.containsKey(keyHostNameIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, "HostNodeUHostNameIdx", keyHostNameIdx);
}
// Validate foreign keys
{
boolean allNull = true;
allNull = false;
if (!allNull) {
if (null
== schema
.getTableCluster()
.readDerivedByIdIdx(Authorization, Buff.getRequiredClusterId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), S_ProcName, "Container", "HostNodeCluster", "Cluster", null);
}
}
}
// Proceed with adding the new record
dictByPKey.put(pkey, Buff);
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdictClusterIdx;
if (dictByClusterIdx.containsKey(keyClusterIdx)) {
subdictClusterIdx = dictByClusterIdx.get(keyClusterIdx);
} else {
subdictClusterIdx = new HashMap<CFSecurityHostNodePKey, CFSecurityHostNodeBuff>();
dictByClusterIdx.put(keyClusterIdx, subdictClusterIdx);
}
subdictClusterIdx.put(pkey, Buff);
dictByUDescrIdx.put(keyUDescrIdx, Buff);
dictByHostNameIdx.put(keyHostNameIdx, Buff);
}
public void updateHostNode(CFSecurityAuthorization Authorization, CFSecurityHostNodeBuff Buff) {
CFSecurityHostNodePKey pkey = schema.getFactoryHostNode().newPKey();
pkey.setRequiredClusterId(Buff.getRequiredClusterId());
pkey.setRequiredHostNodeId(Buff.getRequiredHostNodeId());
CFSecurityHostNodeBuff existing = dictByPKey.get(pkey);
if (existing == null) {
throw CFLib.getDefaultExceptionFactory()
.newStaleCacheDetectedException(
getClass(), "updateHostNode", "Existing record not found", "HostNode", pkey);
}
if (existing.getRequiredRevision() != Buff.getRequiredRevision()) {
throw CFLib.getDefaultExceptionFactory()
.newCollisionDetectedException(getClass(), "updateHostNode", pkey);
}
Buff.setRequiredRevision(Buff.getRequiredRevision() + 1);
CFSecurityHostNodeByClusterIdxKey existingKeyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
existingKeyClusterIdx.setRequiredClusterId(existing.getRequiredClusterId());
CFSecurityHostNodeByClusterIdxKey newKeyClusterIdx =
schema.getFactoryHostNode().newClusterIdxKey();
newKeyClusterIdx.setRequiredClusterId(Buff.getRequiredClusterId());
CFSecurityHostNodeByUDescrIdxKey existingKeyUDescrIdx =
schema.getFactoryHostNode().newUDescrIdxKey();
existingKeyUDescrIdx.setRequiredClusterId(existing.getRequiredClusterId());
existingKeyUDescrIdx.setRequiredDescription(existing.getRequiredDescription());
CFSecurityHostNodeByUDescrIdxKey newKeyUDescrIdx =
schema.getFactoryHostNode().newUDescrIdxKey();
newKeyUDescrIdx.setRequiredClusterId(Buff.getRequiredClusterId());
newKeyUDescrIdx.setRequiredDescription(Buff.getRequiredDescription());
CFSecurityHostNodeByHostNameIdxKey existingKeyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
existingKeyHostNameIdx.setRequiredClusterId(existing.getRequiredClusterId());
existingKeyHostNameIdx.setRequiredHostName(existing.getRequiredHostName());
CFSecurityHostNodeByHostNameIdxKey newKeyHostNameIdx =
schema.getFactoryHostNode().newHostNameIdxKey();
newKeyHostNameIdx.setRequiredClusterId(Buff.getRequiredClusterId());
newKeyHostNameIdx.setRequiredHostName(Buff.getRequiredHostName());
// Check unique indexes
if (!existingKeyUDescrIdx.equals(newKeyUDescrIdx)) {
if (dictByUDescrIdx.containsKey(newKeyUDescrIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), "updateHostNode", "HostNodeUDescrIdx", newKeyUDescrIdx);
}
}
if (!existingKeyHostNameIdx.equals(newKeyHostNameIdx)) {
if (dictByHostNameIdx.containsKey(newKeyHostNameIdx)) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), "updateHostNode", "HostNodeUHostNameIdx", newKeyHostNameIdx);
}
}
// Validate foreign keys
{
boolean allNull = true;
if (allNull) {
if (null
== schema
.getTableCluster()
.readDerivedByIdIdx(Authorization, Buff.getRequiredClusterId())) {
throw CFLib.getDefaultExceptionFactory()
.newUnresolvedRelationException(
getClass(), "updateHostNode", "Container", "HostNodeCluster", "Cluster", null);
}
}
}
// Update is valid
Map<CFSecurityHostNodePKey, CFSecurityHostNodeBuff> subdict;
dictByPKey.remove(pkey);
dictByPKey.put(pkey, Buff);
subdict = dictByClusterIdx.get(existingKeyClusterIdx);
if (subdict != null) {
subdict.remove(pkey);
}
if (dictByClusterIdx.containsKey(newKeyClusterIdx)) {
subdict = dictByClusterIdx.get(newKeyClusterIdx);
} else {
subdict = new HashMap<CFSecurityHostNodePKey, CFSecurityHostNodeBuff>();
dictByClusterIdx.put(newKeyClusterIdx, subdict);
}
subdict.put(pkey, Buff);
dictByUDescrIdx.remove(existingKeyUDescrIdx);
dictByUDescrIdx.put(newKeyUDescrIdx, Buff);
dictByHostNameIdx.remove(existingKeyHostNameIdx);
dictByHostNameIdx.put(newKeyHostNameIdx, Buff);
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFCrmXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
// Primary Key Attributes for Constant Enum support
String attrClusterId = null;
String attrHostNodeId = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstHostNodeLock");
CFCrmXMsgRqstHandler xmsgRqstHandler = (CFCrmXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFCrmSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// Instantiate a PKey buffer for the parsed information
CFSecurityHostNodePKey pkey =
((ICFCrmSchema) schemaObj.getBackingStore()).getFactoryHostNode().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("ClusterId")) {
if (attrClusterId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrClusterId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("HostNodeId")) {
if (attrHostNodeId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrHostNodeId = 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 ((attrClusterId == null) || (attrClusterId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ClusterId");
}
if ((attrHostNodeId == null) || (attrHostNodeId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "HostNodeId");
}
// Get current context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Convert string attributes to native Java types
// and apply the converted attributes to the editBuff.
long natClusterId;
natClusterId = Long.parseLong(attrClusterId);
pkey.setRequiredClusterId(natClusterId);
pkey.setRequiredClusterId(natClusterId);
long natHostNodeId;
natHostNodeId = Long.parseLong(attrHostNodeId);
pkey.setRequiredHostNodeId(natHostNodeId);
pkey.setRequiredHostNodeId(natHostNodeId);
// Lock the object
ICFCrmHostNodeObj locked =
((ICFCrmHostNodeObj) schemaObj.getHostNodeTableObj().lockHostNode(pkey));
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFCrmXMsgHostNodeMessageFormatter.formatHostNodeRspnLocked(
"\n\t\t\t", locked.getHostNodeBuff())
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
((CFCrmXMsgRqstHandler) getParser()).appendResponse(response);
} catch (RuntimeException e) {
CFCrmXMsgRqstHandler xmsgRqstHandler = ((CFCrmXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFCrmXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFCrmXMsgRqstHandler xmsgRqstHandler = ((CFCrmXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFCrmXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}