psdi.configure

Class SysDataElementMAXMESSAGES

java.lang.Object

org.jdom.Content

org.jdom.Element

psdi.configure.SysDataElement

psdi.configure.SysDataElementMAXMESSAGES

All Implemented Interfaces:

java.io.Serializable, java.lang.Cloneable, org.jdom.Parent, UpgConstants

public class SysDataElementMAXMESSAGES
extends SysDataElement
implements UpgConstants

Element to represent the MAXMESSAGES table in the XML file that is output by BuildUpgMetadata and input to Upgrade. This is an extension of psdi.configure.SysDataElement.

SysDataElementMAXMESSAGES is instanciated by the following:

• When reading XML (Upgrade), instanciated from ConfigXMLFactory, via Upgrade. The SysDataElementMAXMESSAGES method getDeleteSql returns sql statements for deleting rows from the MAXMESSAGES table appropriately, after having run ConfigDB.

See Also:

SysDataElement, psdi.upgrade.BuildUpgMetadata, psdi.upgrade.Upgrade, Serialized Form

Field Summary

Fields inherited from class psdi.configure.SysDataElement

codeElements, con, doNotUpdateCols, keyCols, newCol, newData, newDataOldKeys, oldCol, oldData, orgidKey, orgs, siteidKey, sites, sNo, status, sYes, tbname, util

Fields inherited from interface psdi.configure.UpgConstants

DB2, doNotUpdateACTION, doNotUpdateALNDOMAIN, doNotUpdateAPPLICATIONAUTH, doNotUpdateAUTOKEY, doNotUpdateCONDITION, doNotUpdateCONTRACTPROPERTY, doNotUpdateCONTRACTTYPE, doNotUpdateCROSSOVERDOMAIN, doNotUpdateDOCTYPES, doNotUpdateLANGUAGE, doNotUpdateMAXAPPS, doNotUpdateMAXCONDDETAIL, doNotUpdateMAXCONTROLVALUE, doNotUpdateMAXDOMAIN, doNotUpdateMAXLOGAPPENDER, doNotUpdateMAXLOGGER, doNotUpdateMAXMENU, doNotUpdateMAXMESSAGES, doNotUpdateMAXMODULES, doNotUpdateMAXPROP, doNotUpdateMAXPROPVALUE, doNotUpdateMAXROLE, doNotUpdateMAXSEQUENCE, doNotUpdateMAXSERSECURITY, doNotUpdateMAXSERVICE, doNotUpdateMAXTABLEDOMAIN, doNotUpdateMAXVARS, doNotUpdateMAXVARTYPE, doNotUpdateMXCOLLAB, doNotUpdateMXCOLLABREF, doNotUpdateNUMERICDOMAIN, doNotUpdateNUMRANGEDOMAIN, doNotUpdatePORTLET, doNotUpdatePRICALC, doNotUpdateSECURITYRESTRICT, doNotUpdateSIGOPTION, doNotUpdateSYNONYMDOMAIN, doNotUpdateTAXTYPE, doNotUpdateWORKPRIORITY, doNotUpdateWORKTYPE, doNotUpdateWPEDITSETTING, messageCache, NEWONLY, OLDANDNEW, OLDONLY, ORACLE, SQLINET, SQLMICROSOFT, SQLSERVER, SYSDATATABLES, SYSTEMTABLES, UNKNOWN

Constructor Summary

Constructors

Constructor and Description
SysDataElementMAXMESSAGES()
SysDataElementMAXMESSAGES(java.lang.String name)
SysDataElementMAXMESSAGES(java.lang.String name, org.jdom.Namespace namespace)
SysDataElementMAXMESSAGES(java.lang.String name, java.lang.String uri)
SysDataElementMAXMESSAGES(java.lang.String name, java.lang.String prefix, java.lang.String uri)
SysDataElementMAXMESSAGES(java.lang.String tbname, java.util.TreeMap newCol, java.util.TreeMap oldCol, java.util.TreeMap newData, java.util.TreeMap oldData, java.util.TreeMap newDataOldKeys, java.util.TreeMap keyCols, java.io.File codefile) This constructor is used when creating a new Element for the purpose of writing out XML.

Method Summary

Modifier and Type	Method and Description
java.util.ArrayList<java.lang.String>	deleteRow(org.jdom.Element row, java.util.TreeMap colsColno) When reading XML, and the row needs to be deleted from the customer's database, return the sql statement for deleting the row.
java.util.ArrayList	getDeleteSql(java.lang.String tbname, java.sql.Connection con, Util util, java.util.TreeMap oldCol, java.util.TreeMap keyCols) When reading XML, return a series of sql statements to update the customer's database.

Methods inherited from class psdi.configure.SysDataElement

addCodes, addCodesExtension, addOneRow, buildFromHashMaps, canUpdateColumn, compareRows, compareRows, deleteRow, deleteRowExtension, domainInUse, executeQuery, getAttribute, getChunkUpdates, getKeys, getMaxReserved, getNextVal, getSequenceName, getSql, getStatus, getTableName, getUpgCodesElement, getWhereClause, haveDup, initSequence, insertRow, insertRowExtension, isUniqueColumnID, loadDoNotUpdateCols, removeOneRow, scanKeyCols, setKeyAttributes, setStatus, setTableName, setUpgCodes, updateRow, updateRowExtension

Methods inherited from class org.jdom.Element

addContent, addContent, addContent, addContent, addContent, addNamespaceDeclaration, clone, cloneContent, getAdditionalNamespaces, getAttribute, getAttribute, getAttributes, getAttributeValue, getAttributeValue, getAttributeValue, getAttributeValue, getChild, getChild, getChildren, getChildren, getChildren, getChildText, getChildText, getChildTextNormalize, getChildTextNormalize, getChildTextTrim, getChildTextTrim, getContent, getContent, getContent, getContentSize, getDescendants, getDescendants, getName, getNamespace, getNamespace, getNamespacePrefix, getNamespaceURI, getQualifiedName, getText, getTextNormalize, getTextTrim, getValue, indexOf, isAncestor, isRootElement, removeAttribute, removeAttribute, removeAttribute, removeChild, removeChild, removeChildren, removeChildren, removeContent, removeContent, removeContent, removeContent, removeNamespaceDeclaration, setAttribute, setAttribute, setAttribute, setAttributes, setAttributes, setContent, setContent, setContent, setContent, setName, setNamespace, setText, toString

Methods inherited from class org.jdom.Content

detach, equals, getDocument, getParent, getParentElement, hashCode

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface org.jdom.Parent

getDocument, getParent

Constructor Detail

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES()

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES(java.lang.String name)

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES(java.lang.String name,
                                 org.jdom.Namespace namespace)

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES(java.lang.String name,
                                 java.lang.String uri)

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES(java.lang.String name,
                                 java.lang.String prefix,
                                 java.lang.String uri)

SysDataElementMAXMESSAGES

public SysDataElementMAXMESSAGES(java.lang.String tbname,
                                 java.util.TreeMap newCol,
                                 java.util.TreeMap oldCol,
                                 java.util.TreeMap newData,
                                 java.util.TreeMap oldData,
                                 java.util.TreeMap newDataOldKeys,
                                 java.util.TreeMap keyCols,
                                 java.io.File codefile)
                          throws java.lang.Exception

This constructor is used when creating a new Element for the purpose of writing out XML. It calls buildFromHashMaps.

Parameters:

tbname - The name of the table. See tbname.

newCol - The column metadata on this table, from the new database. See newCol.

oldCol - The column metadata on this table, from the old database. See oldCol.

newData - The data from the new database. See newData.

oldData - The data from the old database. See oldData.

keyCols - Key columns for this table. See keyCols.

codeFile - The file UpgCodes.xml that may contain special codes for rows in the table. For SysDataElementSYNONYMDOMAIN this is null.

Throws:

java.lang.Exception

See Also:

SysDataElement.scanKeyCols(), SysDataElement.buildFromHashMaps()

Method Detail

getDeleteSql

public java.util.ArrayList getDeleteSql(java.lang.String tbname,
                                        java.sql.Connection con,
                                        Util util,
                                        java.util.TreeMap oldCol,
                                        java.util.TreeMap keyCols)
                                 throws java.lang.Exception

When reading XML, return a series of sql statements to update the customer's database.

• If the XML status is OLDONLY, the sql will delete from table for that row.

If different update logic is needed for a particular table, this class can be extended and this method overridden.

Overrides:

getDeleteSql in class SysDataElement

Parameters:

tbname - The table name. See tbname.

con - The connection to the database being upgraded. See con.

util - Reference to the Util class. See util.

oldCol - TreeMap of the data structure for the columns on this table (key = column name). (This is retrieved AFTER ConfigDB may have updated the format.) See oldCol.

keyCols - The key columns for this table. See keyCols.

Returns:

Series of sql statements

Throws:

java.lang.Exception

See Also:

SysDataElement.loadDoNotUpdateCols(), SysDataElement.scanKeyCols(), deleteRow(org.jdom.Element, java.util.TreeMap)

deleteRow

public java.util.ArrayList<java.lang.String> deleteRow(org.jdom.Element row,
                                                       java.util.TreeMap colsColno)
                                                throws java.lang.Exception

When reading XML, and the row needs to be deleted from the customer's database, return the sql statement for deleting the row. Called from getDeleteSql. This is an extension of SysDataElement.deleteRow, as special processing is required for MaxMessages. Some messages were created with trailing spaces. SQL Server and DB2 cannot distinguish between values with trailing spaces and values without. We do it here programmatically with a call to verifyRow

Parameters:

row - The element from the input XML representing a row in this table.

colsColno - The metadata for the columns on this table, key = colno.

Returns:

A "delete from..." sql statement. There will be no siteid/orgid condition, so it may delete multiple rows. This is an ArrayList so that extensions of this class can provide more than one Sql statement if needed, e.g. for parent/child tables.

Throws:

java.lang.Exception

See Also:

#verifyRow(Element, HashMap, TreeMap)}, SysDataElement.deleteRowExtension(org.jdom.Element, java.util.ArrayList)