com.goldencode.p2j.persist

Class SequenceManager

java.lang.Object

com.goldencode.p2j.persist.SequenceManager

public abstract class SequenceManager
extends java.lang.Object

A class that manages all sequence handling functions and statements calls, including static dynamic forms. It also manages a map with handlers for each database and will dispatch the primitives to a dedicate handler per database. The runtime implementations of XXXSequenceHandlers the statement/functions leverage dialect infrastructure in Hibernate if possible (if we find it is feasible to use native sequences on PostgreSQL). If this is not possible, the SequenceHandlers will use any native support the respective database server offer and will emulate the needed 4GL behavior in java.

Field Summary

Fields

Modifier and Type	Field and Description
private static boolean	CURRENT Constant used for obtaining the current value of the sequence.
private static SequenceHandler	defaultHandler A default handler for sequences that will return unknown values.
private static java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.String>>	legacyMap Mapping from 4GL-legacy names to db-oriented names used in application.
private static boolean	NEXT Constant used to activate the NEXT-VALUE mode.
private static java.util.HashMap<java.lang.String,SequenceHandler>	seqHandlers Internal data structure with all instantiated SequenceHandlers.
private static java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,Sequence>>	sequences The list of all known sequences in a double hashed Map (schema x sqlName).

Constructor Summary

Constructors

Constructor and Description
SequenceManager()

Method Summary

Modifier and Type	Method and Description
private static void	addSequenceDefinition(java.lang.String schema, java.lang.String legName, java.lang.String sqlName, long sesInit, long seqInc, long seqMin, long seqMax, boolean seqCycle) Creates the internal data structure representing a sequence object and add it to in-memory list.
static int64	currentValue(java.lang.String legName) Maps the CURRENT-VALUE(seqName) function from Progress as it is defined in Open Edge 10.x.
static int64	currentValue(java.lang.String legName, java.lang.String ldbName) Maps the CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicCurrentValue(character legName, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicCurrentValue(character legName, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicCurrentValue(java.lang.String legName, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicCurrentValue(java.lang.String legName, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicNextValue(character legName, character ldbName) Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicNextValue(character legName, java.lang.String ldbName) Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicNextValue(java.lang.String legName, character ldbName) Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static int64	dynamicNextValue(java.lang.String legName, java.lang.String ldbName) Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(character legName, long newValue, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(character legName, long newValue, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(character legName, NumberType newValue, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(character legName, NumberType newValue, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(java.lang.String legName, long newValue, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(java.lang.String legName, long newValue, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(java.lang.String legName, NumberType newValue, character ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	dynamicSetValue(java.lang.String legName, NumberType newValue, java.lang.String ldbName) Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
private static java.lang.String	getDatabaseForSequence(java.lang.String legacyName) Seeks the database in which the sequence is defined.
static Sequence	getSequence(java.lang.String dbName, java.lang.String name) Lookups the internal data structure representing a sequence object.
private static SequenceHandler	getSequenceHandler(java.lang.String ldbName) Factory method for obtaining a sequence object for a database.
private static int64	getValueImpl(boolean next, java.lang.String ldbName, java.lang.String seqLegacyName, boolean dynamic) Implementation of all cases of querying the sequence values.
static int64	nextValue(java.lang.String legName) Maps the NEXT-VALUE(seqName) function from Progress as it is defined in Open Edge 10.x.
static int64	nextValue(java.lang.String legName, java.lang.String ldbName) Maps the NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x.
static void	prepare(Database database, java.lang.String schema) Prepare the sequences from a specified database for usage.
private static java.lang.String	resolveDynamicName(java.lang.String legacyName, java.lang.String schema) Resolve the legacy name to actual sql name of a sequence.
static void	setValue(java.lang.String legName, long newValue) Maps the CURRENT-VALUE(seqName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	setValue(java.lang.String legName, long newValue, java.lang.String ldbName) Maps the CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	setValue(java.lang.String legName, NumberType newValue) Maps the CURRENT-VALUE(seqName) = expr statement from Progress as it is defined in Open Edge 10.x.
static void	setValue(java.lang.String legName, NumberType newValue, java.lang.String ldbName) Maps the CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x.
private static void	setValueImpl(java.lang.String ldbName, java.lang.String seqLegacyName, java.lang.Long val, boolean dynamic) Implementation of all cases of manual update of a sequence's value.

Methods inherited from class java.lang.Object

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

Field Detail

defaultHandler

private static final SequenceHandler defaultHandler

A default handler for sequences that will return unknown values. It is used for sequences that are not found in db or unsupported dialects.

sequences

private static final java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,Sequence>> sequences

The list of all known sequences in a double hashed Map (schema x sqlName).

I wonder if the first level uses the sequence names and the second the database. This makes it easier to look for a sequence when the name of the database is default/unknown.

seqHandlers

private static final java.util.HashMap<java.lang.String,SequenceHandler> seqHandlers

Internal data structure with all instantiated SequenceHandlers. The keys are logical database names. This assures that for each database there is only one SequenceHandler which also serves for synchronizing access to sequence functionality using these database-unique objects as locks.

legacyMap

private static final java.util.HashMap<java.lang.String,java.util.HashMap<java.lang.String,java.lang.String>> legacyMap

Mapping from 4GL-legacy names to db-oriented names used in application. Each schema has its own set of mapping for sequences. This is why this member is double-hashed. Note:Only sequences that have mutated name will be store is this structure.

NEXT

private static final boolean NEXT

Constant used to activate the NEXT-VALUE mode.

See Also:

Constant Field Values

CURRENT

private static final boolean CURRENT

Constant used for obtaining the current value of the sequence.

See Also:

Constant Field Values

Constructor Detail

SequenceManager

public SequenceManager()

Method Detail

currentValue

public static int64 currentValue(java.lang.String legName)

Maps the CURRENT-VALUE(seqName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of a sequence defined in the Data Dictionary.

Parameters:

legName - An identifier that specifies the name of a sequence defined in 4GL.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

currentValue

public static int64 currentValue(java.lang.String legName,
                                 java.lang.String ldbName)

Maps the CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of the sequence defined in 4GL.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If a sequence with this name exists in more than one connected database, then you must specify ldbName.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

nextValue

public static int64 nextValue(java.lang.String legName)

Maps the NEXT-VALUE(seqName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

Returns:

The next value of a sequence can be one of the following:

• The value obtained by incremented the current value of the sequence with its increment if the value does not cross the upper/lower limits. In the case of cycling sequences the sequence value is reset to initial value.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

nextValue

public static int64 nextValue(java.lang.String legName,
                              java.lang.String ldbName)

Maps the NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. If multiple databases are connected, you can omit this parameter if you specify a sequence that is unique to one of the databases.

Returns:

The next value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicCurrentValue

public static int64 dynamicCurrentValue(java.lang.String legName,
                                        java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of the sequence defined in the Data Dictionary.

Parameters:

legName - The name of a sequence defined in the Data Dictionary.

ldbName - The logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicCurrentValue

public static int64 dynamicCurrentValue(java.lang.String legName,
                                        character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of the sequence defined in the Data Dictionary.

Parameters:

legName - The name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to a logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicCurrentValue

public static int64 dynamicCurrentValue(character legName,
                                        java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of the sequence defined in the Data Dictionary.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - The logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicCurrentValue

public static int64 dynamicCurrentValue(character legName,
                                        character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the current value of the sequence defined in the Data Dictionary.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to a logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The current value of a sequence can be one of the following:

• The initial value specified in the Data Dictionary.
• The last value set with either the CURRENT-VALUE statement or the NEXT-VALUE function.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicNextValue

public static int64 dynamicNextValue(java.lang.String legName,
                                     java.lang.String ldbName)

Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - The name of a sequence defined in the Data Dictionary.

ldbName - The logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The next value of a sequence can be one of the following:

• The value obtained by incremented the current value of the sequence with its increment if the value does not cross the upper/lower limits. In the case of cycling sequences the sequence value is reset to initial value.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicNextValue

public static int64 dynamicNextValue(java.lang.String legName,
                                     character ldbName)

Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - The name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to a logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The next value of a sequence can be one of the following:

• The value obtained by incremented the current value of the sequence with its increment if the value does not cross the upper/lower limits. In the case of cycling sequences the sequence value is reset to initial value.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicNextValue

public static int64 dynamicNextValue(character legName,
                                     java.lang.String ldbName)

Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - The logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The next value of a sequence can be one of the following:

• The value obtained by incremented the current value of the sequence with its increment if the value does not cross the upper/lower limits. In the case of cycling sequences the sequence value is reset to initial value.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

dynamicNextValue

public static int64 dynamicNextValue(character legName,
                                     character ldbName)

Maps the DYNAMIC-NEXT-VALUE(seqName, ldbName) function from Progress as it is defined in Open Edge 10.x. Returns the next value of the sequence, incremented by the positive or negative value defined in the Data Dictionary.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to a logical name of the database in which the sequence is defined. The database must be connected.

Returns:

The next value of a sequence can be one of the following:

• The value obtained by incremented the current value of the sequence with its increment if the value does not cross the upper/lower limits. In the case of cycling sequences the sequence value is reset to initial value.
• The unknown value (?) if the sequence has exceeded its minimum or maximum and is not cycling.

setValue

public static void setValue(java.lang.String legName,
                            NumberType newValue)

Maps the CURRENT-VALUE(seqName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

setValue

public static void setValue(java.lang.String legName,
                            long newValue)

Maps the CURRENT-VALUE(seqName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

setValue

public static void setValue(java.lang.String legName,
                            long newValue,
                            java.lang.String ldbName)

Maps the CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

setValue

public static void setValue(java.lang.String legName,
                            NumberType newValue,
                            java.lang.String ldbName)

Maps the CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(java.lang.String legName,
                                   long newValue,
                                   java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(java.lang.String legName,
                                   long newValue,
                                   character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(java.lang.String legName,
                                   NumberType newValue,
                                   java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to the name of a database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(java.lang.String legName,
                                   NumberType newValue,
                                   character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(character legName,
                                   long newValue,
                                   java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to the name of a database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(character legName,
                                   long newValue,
                                   character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - An identifier that specifies the name of a sequence defined in the Data Dictionary.

ldbName - An identifier that specifies the logical name of the database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - An integer expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(character legName,
                                   NumberType newValue,
                                   java.lang.String ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to the name of a database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

dynamicSetValue

public static void dynamicSetValue(character legName,
                                   NumberType newValue,
                                   character ldbName)

Maps the DYNAMIC-CURRENT-VALUE(seqName, ldbName) = expr statement from Progress as it is defined in Open Edge 10.x. Resets the current value of the sequence to the one specified as parameter.

Parameters:

legName - A character expression that evaluates to the name of a sequence defined in the Data Dictionary.

ldbName - A character expression that evaluates to the name of a database in which the sequence is defined. The database must be connected. You can omit this parameter if the sequence name is unambiguous. If more than one connected database has a sequence with given name, then you must supply ldbName.

newValue - A numerical expression assigned as the current value of the specified sequence. If expression is outside the boundary set by the initial value (at one end) and the lower limit or upper limit (at the other end) for the sequence, Progress returns an error, and the sequence value remains unchanged.

getSequence

public static Sequence getSequence(java.lang.String dbName,
                                   java.lang.String name)

Lookups the internal data structure representing a sequence object.

Parameters:

dbName - The logical name or alias of the database.

name - The sql name of the sequence.

Returns:

The named Sequence from the database and null if something is wrong (database not connected, sequence does not exist).

prepare

public static void prepare(Database database,
                           java.lang.String schema)

Prepare the sequences from a specified database for usage. The set of sequences is obtained from _Sequence enum form from the database's location. It is possible that the enum is not created at all when there are no sequences defined in the database.

Parameters:

database - The database to be analyzed.

schema - The database's schema.

getValueImpl

private static int64 getValueImpl(boolean next,
                                  java.lang.String ldbName,
                                  java.lang.String seqLegacyName,
                                  boolean dynamic)

Implementation of all cases of querying the sequence values.

Parameters:

next - If NEXT, the next value of the sequence is returned. If CURRENT the current value is returned.

ldbName - The legacy database name. In static mode, the null / ? (unknown) value will attempt to detect the database dynamically. If operation fails, unknown value is returned. In dynamic mode, this is an error and an appropriate error condition will be raised.

seqLegacyName - The sequence legacy name.

dynamic - Activates the dynamic sequence name resolution mode.

Returns:

The (new) value of the sequence, as requested.

setValueImpl

private static void setValueImpl(java.lang.String ldbName,
                                 java.lang.String seqLegacyName,
                                 java.lang.Long val,
                                 boolean dynamic)

Implementation of all cases of manual update of a sequence's value.

Parameters:

ldbName - The legacy database name. In static mode, the null / ? (unknown) value will attempt to detect the database dynamically. If operation fails, unknown value is returned. In dynamic mode, this is an error and an appropriate error condition will be raised.

seqLegacyName - The sequence legacy name.

val - The new value to be set.

dynamic - Activates the dynamic sequence name resolution mode.

getDatabaseForSequence

private static java.lang.String getDatabaseForSequence(java.lang.String legacyName)

Seeks the database in which the sequence is defined. It is assumed that there should no conflicts or the first found database is returned. This method is called when some (static) sequence function has been called without the last parameter (ldbName). As a side effect, if the database is found, it is guaranteed that the appropriate SequenceHandler has been loaded.

Parameters:

legacyName - The legacy sequence name of the sequence to lookup after.

Returns:

The name of the database where the sequence is defined.

resolveDynamicName

private static java.lang.String resolveDynamicName(java.lang.String legacyName,
                                                   java.lang.String schema)

Resolve the legacy name to actual sql name of a sequence.

Parameters:

legacyName - The name of the sequence in 4GL.

schema - The schema of the sequence.

Returns:

The sql-legal name of the schema.

getSequenceHandler

private static SequenceHandler getSequenceHandler(java.lang.String ldbName)

Factory method for obtaining a sequence object for a database. If some settings is not found in directory a default SequenceHandler is returned by default.

Parameters:

ldbName - The name of the database

Returns:

An instance of Sequence that will to which the internal functionality will be delegated.

addSequenceDefinition

private static void addSequenceDefinition(java.lang.String schema,
                                          java.lang.String legName,
                                          java.lang.String sqlName,
                                          long sesInit,
                                          long seqInc,
                                          long seqMin,
                                          long seqMax,
                                          boolean seqCycle)

Creates the internal data structure representing a sequence object and add it to in-memory list.

This method is only called at startup time or when the database is initializing.

Parameters:

schema - The schema/database.

legName - The legacy name of the sequence (as it was defined in 4GL).

sqlName - The sql-legal name of the sequence.

sesInit - The initial value of the sequence.

seqInc - The increment value of the sequence.

seqMin - The minimum value of the sequence.

seqMax - The maximum value of the sequence.

seqCycle - The cycle flag of the sequence.