openr66.database.data
Class DbConfiguration

java.lang.Object
  goldengate.common.database.data.AbstractDbData
      openr66.database.data.DbConfiguration

public class DbConfiguration
extends goldengate.common.database.data.AbstractDbData

Configuration Table object

Author:

Frederic Bregier

Nested Class Summary

static class

DbConfiguration.Columns

Nested classes/interfaces inherited from class goldengate.common.database.data.AbstractDbData

goldengate.common.database.data.AbstractDbData.UpdatedInfo

Field Summary

static int[]	dbTypes
protected static String	insertAllValues
static int	NBPRKEY
protected static String	selectAllFields
static String	table
protected static String	updateAllFields

Fields inherited from class goldengate.common.database.data.AbstractDbData

allFields, dbSession, isSaved, otherFields, primaryKey

Constructor Summary

DbConfiguration(goldengate.common.database.DbSession dbSession, String hostid)

DbConfiguration(goldengate.common.database.DbSession dbSession, String hostid, long rg, long wg, long rs, long ws, long del)

Method Summary

void	changeUpdatedInfo(goldengate.common.database.data.AbstractDbData.UpdatedInfo info)
void	delete()
boolean	exist()
static DbConfiguration	getFromStatement(goldengate.common.database.DbPreparedStatement preparedStatement) For instance from Commander when getting updated information
protected String	getInsertAllValues()
protected String	getSelectAllFields()
protected String	getTable()
protected String	getUpdateAllFields()
static goldengate.common.database.DbPreparedStatement	getUpdatedPrepareStament(goldengate.common.database.DbSession session)
protected String	getWherePrimaryKey()
protected void	initObject()
void	insert()
boolean	isOwnConfiguration()
void	select()
protected void	setFromArray()
protected void	setPrimaryKey()
protected void	setToArray()
void	update()
void	updateConfiguration() Update configuration according to new value of limits

Methods inherited from class goldengate.common.database.data.AbstractDbData

get, getTrueValue, getValue, getValues, setTrueValue, setValue, setValues

Methods inherited from class java.lang.Object

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

Field Detail

dbTypes

public static final int[] dbTypes

table

public static final String table

See Also:

Constant Field Values

NBPRKEY

public static final int NBPRKEY

See Also:

Constant Field Values

selectAllFields

protected static final String selectAllFields

updateAllFields

protected static final String updateAllFields

insertAllValues

protected static final String insertAllValues

See Also:

Constant Field Values

Constructor Detail

DbConfiguration

public DbConfiguration(goldengate.common.database.DbSession dbSession,
                       String hostid,
                       long rg,
                       long wg,
                       long rs,
                       long ws,
                       long del)

Parameters:

dbSession -

hostid -

rg - Read Global Limit

wg - Write Global Limit

rs - Read Session Limit

ws - Write Session Limit

del - Delay Limit

DbConfiguration

public DbConfiguration(goldengate.common.database.DbSession dbSession,
                       String hostid)
                throws goldengate.common.database.exception.GoldenGateDatabaseException

Parameters:

dbSession -

hostid -

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

Method Detail

initObject

protected void initObject()

Specified by:

initObject in class goldengate.common.database.data.AbstractDbData

getSelectAllFields

protected String getSelectAllFields()

Specified by:

getSelectAllFields in class goldengate.common.database.data.AbstractDbData

getTable

protected String getTable()

Specified by:

getTable in class goldengate.common.database.data.AbstractDbData

getInsertAllValues

protected String getInsertAllValues()

Specified by:

getInsertAllValues in class goldengate.common.database.data.AbstractDbData

getUpdateAllFields

protected String getUpdateAllFields()

Specified by:

getUpdateAllFields in class goldengate.common.database.data.AbstractDbData

setToArray

protected void setToArray()

Specified by:

setToArray in class goldengate.common.database.data.AbstractDbData

setFromArray

protected void setFromArray()
                     throws goldengate.common.database.exception.GoldenGateDatabaseSqlException

Specified by:

setFromArray in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseSqlException

getWherePrimaryKey

protected String getWherePrimaryKey()

Specified by:

getWherePrimaryKey in class goldengate.common.database.data.AbstractDbData

setPrimaryKey

protected void setPrimaryKey()

Specified by:

setPrimaryKey in class goldengate.common.database.data.AbstractDbData

delete

public void delete()
            throws goldengate.common.database.exception.GoldenGateDatabaseException

Overrides:

delete in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

insert

public void insert()
            throws goldengate.common.database.exception.GoldenGateDatabaseException

Overrides:

insert in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

exist

public boolean exist()
              throws goldengate.common.database.exception.GoldenGateDatabaseException

Overrides:

exist in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

select

public void select()
            throws goldengate.common.database.exception.GoldenGateDatabaseException

Overrides:

select in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

update

public void update()
            throws goldengate.common.database.exception.GoldenGateDatabaseException

Overrides:

update in class goldengate.common.database.data.AbstractDbData

Throws:

goldengate.common.database.exception.GoldenGateDatabaseException

getFromStatement

public static DbConfiguration getFromStatement(goldengate.common.database.DbPreparedStatement preparedStatement)
                                        throws goldengate.common.database.exception.GoldenGateDatabaseNoConnectionException,
                                               goldengate.common.database.exception.GoldenGateDatabaseSqlException

For instance from Commander when getting updated information

Parameters:

preparedStatement -

Returns:

the next updated Configuration

Throws:

goldengate.common.database.exception.GoldenGateDatabaseNoConnectionException

goldengate.common.database.exception.GoldenGateDatabaseSqlException

getUpdatedPrepareStament

public static goldengate.common.database.DbPreparedStatement getUpdatedPrepareStament(goldengate.common.database.DbSession session)
                                                                               throws goldengate.common.database.exception.GoldenGateDatabaseNoConnectionException,
                                                                                      goldengate.common.database.exception.GoldenGateDatabaseSqlException

Returns:

the DbPreparedStatement for getting Updated Object

Throws:

goldengate.common.database.exception.GoldenGateDatabaseNoConnectionException

goldengate.common.database.exception.GoldenGateDatabaseSqlException

changeUpdatedInfo

public void changeUpdatedInfo(goldengate.common.database.data.AbstractDbData.UpdatedInfo info)

Specified by:

changeUpdatedInfo in class goldengate.common.database.data.AbstractDbData

updateConfiguration

public void updateConfiguration()

Update configuration according to new value of limits

isOwnConfiguration

public boolean isOwnConfiguration()

Returns:

True if this Configuration refers to the current host