psdi.mbo

Class MaxSequence

java.lang.Object

psdi.mbo.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.
static long	getNextDb2Sequence(java.sql.Connection con, java.lang.String seqName) Returns the unique key for DB2 by executing a sql statement
static void	reset() Reset msp = null so it will be rebuilt.

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 subsequent call adds one to the seed value.

Parameters:

con - - Database Connection

tbName - - table name

name - - Column name

Returns:

- unique key

Throws:

MXException

getNextDb2Sequence

public static long getNextDb2Sequence(java.sql.Connection con,
                                      java.lang.String seqName)
                               throws MXException

Returns the unique key for DB2 by executing a sql statement

Parameters:

con - - Database Connection

tbName - - table name

name - - column name

Returns:

- unique key

Throws:

MXException

reset

public static void reset()
                  throws MXException

Reset msp = null so it will be rebuilt.

Throws:

MXException