com.ibm.ism.content.psdi.tools

Class MaxSequence

java.lang.Object

com.ibm.ism.content.psdi.tools.MaxSequence

public class MaxSequence
extends java.lang.Object

Author:

Manju_Makonahalli Class to generate unique id's. In oracle and db2 the unique ids are generated from database sequence number generators. In sql server the unique ids are generated using the maxsequence table. In order to use this class, the Maxsequence table should contain an entry with the tablename, columnname and sequence name.

Constructor Summary

Constructors

Constructor and Description
MaxSequence()

Method Summary

Modifier and Type	Method and Description
static long	generateKey(java.sql.Connection con, java.lang.String tbName, java.lang.String name) Generates a unique key used by long description and workflow ID columns.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MaxSequence

public MaxSequence()

Method Detail

generateKey

public static long generateKey(java.sql.Connection con,
                               java.lang.String tbName,
                               java.lang.String name)
                        throws MXException

Generates a unique key used by long description and workflow ID columns. If the database is Oracle, it returns the MAXSEQ sequence's next value. If not Oracle then the system system time on the SQLServer database server in milliseconds at the time of the first call is used as a seed for a counter. Each subsiquent call adds one to the seed value.

Throws:

MXException