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;
}
}
}
protected CFSecurityServiceTypeBuff unpackServiceTypeResultSetToBuff(ResultSet resultSet)
throws SQLException {
final String S_ProcName = "unpackServiceTypeResultSetToBuff";
int idxcol = 1;
CFSecurityServiceTypeBuff buff = schema.getFactoryServiceType().newBuff();
{
String colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedByUserId(null);
} else {
buff.setCreatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setCreatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setCreatedAt(null);
} else {
buff.setCreatedAt(CFSecuritySybaseSchema.convertTimestampString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedByUserId(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedByUserId(null);
} else {
buff.setUpdatedByUserId(UUID.fromString(colString));
}
idxcol++;
colString = resultSet.getString(idxcol);
if (resultSet.wasNull()) {
buff.setUpdatedAt(null);
} else if ((colString == null) || (colString.length() <= 0)) {
buff.setUpdatedAt(null);
} else {
buff.setUpdatedAt(CFSecuritySybaseSchema.convertTimestampString(colString));
}
idxcol++;
}
buff.setRequiredServiceTypeId(resultSet.getInt(idxcol));
idxcol++;
buff.setRequiredDescription(resultSet.getString(idxcol));
idxcol++;
buff.setRequiredRevision(resultSet.getInt(idxcol));
return (buff);
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
CFAccXMsgSchemaMessageFormatter schemaFormatter = null;
try {
// Common XML Attributes
String attrId = null;
String attrRevision = null;
// ServiceType Attributes
String attrServiceTypeId = null;
String attrDescription = null;
String attrCreatedAt = null;
String attrCreatedBy = null;
String attrUpdatedAt = null;
String attrUpdatedBy = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("RqstServiceTypeUpdate");
CFAccXMsgRqstHandler xmsgRqstHandler = (CFAccXMsgRqstHandler) getParser();
if (xmsgRqstHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
ICFAccSchemaObj schemaObj = xmsgRqstHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// 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("Revision")) {
if (attrRevision != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrRevision = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedAt")) {
if (attrCreatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedBy")) {
if (attrCreatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedAt")) {
if (attrUpdatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedBy")) {
if (attrUpdatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("ServiceTypeId")) {
if (attrServiceTypeId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrServiceTypeId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("Description")) {
if (attrDescription != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrDescription = 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 ((attrServiceTypeId == null) || (attrServiceTypeId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ServiceTypeId");
}
if (attrDescription == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "Description");
}
if ((attrRevision == null) || (attrRevision.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "Revision");
}
if ((attrCreatedAt == null) || (attrCreatedAt.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "CreatedAt");
}
if ((attrCreatedBy == null) || (attrCreatedBy.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "CreatedBy");
}
if ((attrUpdatedAt == null) || (attrUpdatedAt.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "UpdatedAt");
}
if ((attrUpdatedBy == null) || (attrUpdatedBy.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "UpdatedBy");
}
// Save named attributes to context
CFLibXmlCoreContext curContext = getParser().getCurContext();
// Instantiate a PKey buffer for the parsed information
CFSecurityServiceTypePKey pkey =
((ICFAccSchema) schemaObj.getBackingStore()).getFactoryServiceType().newPKey();
int natServiceTypeId;
natServiceTypeId = Integer.parseInt(attrServiceTypeId);
pkey.setRequiredServiceTypeId(natServiceTypeId);
// Read the instance
ICFAccServiceTypeObj origBuff =
((ICFAccServiceTypeObj) schemaObj.getServiceTypeTableObj().readServiceType(pkey));
if (origBuff == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(
getClass(), S_ProcName, 0, "getServiceTypeTableObj().readServiceType()");
} else {
// Edit the instance
ICFAccServiceTypeEditObj editBuff = (ICFAccServiceTypeEditObj) origBuff.beginEdit();
CFSecurityServiceTypeBuff dataBuff = editBuff.getServiceTypeBuff();
// Convert string attributes to native Java types
// and apply the converted attributes to the editBuff.
String natDescription = attrDescription;
dataBuff.setRequiredDescription(natDescription);
int natRevision = Integer.parseInt(attrRevision);
dataBuff.setRequiredRevision(natRevision);
UUID createdBy = null;
if (attrCreatedBy != null) {
createdBy = UUID.fromString(attrCreatedBy);
}
Calendar createdAt = null;
if (attrCreatedAt != null) {
createdAt = CFLibXmlUtil.parseTimestamp(attrCreatedAt);
}
UUID updatedBy = null;
if (attrUpdatedBy != null) {
updatedBy = UUID.fromString(attrUpdatedBy);
}
Calendar updatedAt = null;
if (attrUpdatedAt != null) {
updatedAt = CFLibXmlUtil.parseTimestamp(attrUpdatedAt);
}
if (createdBy != null) {
dataBuff.setCreatedByUserId(createdBy);
}
if (createdAt != null) {
dataBuff.setCreatedAt(createdAt);
}
if (updatedBy != null) {
dataBuff.setUpdatedByUserId(updatedBy);
}
if (updatedAt != null) {
dataBuff.setUpdatedAt(updatedAt);
}
// Attempt the update
editBuff.update();
editBuff.endEdit();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgServiceTypeMessageFormatter.formatServiceTypeRspnUpdated(
"\n\t\t\t", origBuff.getServiceTypeBuff())
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
((CFAccXMsgRqstHandler) getParser()).appendResponse(response);
}
} catch (RuntimeException e) {
CFAccXMsgRqstHandler xmsgRqstHandler = ((CFAccXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
} catch (Error e) {
CFAccXMsgRqstHandler xmsgRqstHandler = ((CFAccXMsgRqstHandler) getParser());
schemaFormatter = xmsgRqstHandler.getSchemaMessageFormatter();
String response =
schemaFormatter.formatRspnXmlPreamble()
+ "\n"
+ "\t"
+ CFAccXMsgSchemaMessageFormatter.formatRspnException("\n\t\t\t", e)
+ "\n"
+ schemaFormatter.formatRspnXmlPostamble();
xmsgRqstHandler.resetResponse();
xmsgRqstHandler.appendResponse(response);
xmsgRqstHandler.setCaughtException(true);
}
}
public void startElement(String uri, String localName, String qName, Attributes attrs)
throws SAXException {
try {
// Common XML Attributes
String attrId = null;
String attrRevision = null;
// ServiceType Attributes
String attrServiceTypeId = null;
String attrDescription = null;
String attrCreatedAt = null;
String attrCreatedBy = null;
String attrUpdatedAt = null;
String attrUpdatedBy = null;
// Attribute Extraction
String attrLocalName;
int numAttrs;
int idxAttr;
final String S_ProcName = "startElement";
final String S_LocalName = "LocalName";
assert qName.equals("ServiceType");
CFSecurityXMsgRspnHandler xmsgRspnHandler = (CFSecurityXMsgRspnHandler) getParser();
if (xmsgRspnHandler == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser()");
}
ICFSecuritySchemaObj schemaObj = xmsgRspnHandler.getSchemaObj();
if (schemaObj == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "getParser().getSchemaObj()");
}
// 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("Revision")) {
if (attrRevision != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrRevision = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedAt")) {
if (attrCreatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("CreatedBy")) {
if (attrCreatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrCreatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedAt")) {
if (attrUpdatedAt != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedAt = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("UpdatedBy")) {
if (attrUpdatedBy != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrUpdatedBy = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("ServiceTypeId")) {
if (attrServiceTypeId != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrServiceTypeId = attrs.getValue(idxAttr);
} else if (attrLocalName.equals("Description")) {
if (attrDescription != null) {
throw CFLib.getDefaultExceptionFactory()
.newUniqueIndexViolationException(
getClass(), S_ProcName, S_LocalName, attrLocalName);
}
attrDescription = 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 ((attrServiceTypeId == null) || (attrServiceTypeId.length() <= 0)) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "ServiceTypeId");
}
if (attrDescription == null) {
throw CFLib.getDefaultExceptionFactory()
.newNullArgumentException(getClass(), S_ProcName, 0, "Description");
}
// Save named attributes to context
CFLibXmlCoreContext curContext = xmsgRspnHandler.getCurContext();
// Convert string attributes to native Java types
int natServiceTypeId = Integer.parseInt(attrServiceTypeId);
String natDescription = attrDescription;
int natRevision = Integer.parseInt(attrRevision);
UUID createdBy = null;
if (attrCreatedBy != null) {
createdBy = UUID.fromString(attrCreatedBy);
}
Calendar createdAt = null;
if (attrCreatedAt != null) {
createdAt = CFLibXmlUtil.parseTimestamp(attrCreatedAt);
}
UUID updatedBy = null;
if (attrUpdatedBy != null) {
updatedBy = UUID.fromString(attrUpdatedBy);
}
Calendar updatedAt = null;
if (attrUpdatedAt != null) {
updatedAt = CFLibXmlUtil.parseTimestamp(attrUpdatedAt);
}
// Get the parent context
CFLibXmlCoreContext parentContext = curContext.getPrevContext();
// Instantiate a buffer for the parsed information
ICFSecurityServiceTypeObj obj =
(ICFSecurityServiceTypeObj) (schemaObj.getServiceTypeTableObj().newInstance());
CFSecurityServiceTypeBuff dataBuff = obj.getServiceTypeBuff();
dataBuff.setRequiredServiceTypeId(natServiceTypeId);
dataBuff.setRequiredDescription(natDescription);
dataBuff.setRequiredRevision(natRevision);
if (createdBy != null) {
dataBuff.setCreatedByUserId(createdBy);
}
if (createdAt != null) {
dataBuff.setCreatedAt(createdAt);
}
if (updatedBy != null) {
dataBuff.setUpdatedByUserId(updatedBy);
}
if (updatedAt != null) {
dataBuff.setUpdatedAt(updatedAt);
}
obj.copyBuffToPKey();
@SuppressWarnings("unchecked")
List<ICFSecurityServiceTypeObj> list =
(List<ICFSecurityServiceTypeObj>) xmsgRspnHandler.getListOfObjects();
ICFSecurityServiceTypeObj realized = (ICFSecurityServiceTypeObj) obj.realize();
xmsgRspnHandler.setLastObjectProcessed(realized);
if (list != null) {
list.add(realized);
}
} catch (RuntimeException e) {
throw new RuntimeException(
"Near "
+ getParser().getLocationInfo()
+ ": Caught and rethrew "
+ e.getClass().getName()
+ " - "
+ e.getMessage(),
e);
} catch (Error e) {
throw new Error(
"Near "
+ getParser().getLocationInfo()
+ ": Caught and rethrew "
+ e.getClass().getName()
+ " - "
+ e.getMessage(),
e);
}
}