org.waarp.gateway.kernel.database.model

Class DbModelOracleKernel

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelOracle

org.waarp.gateway.kernel.database.model.DbModelOracleKernel

All Implemented Interfaces:

DbModel

public class DbModelOracleKernel
extends DbModelOracle

Oracle Database Model implementation

Nested Class Summary

Nested classes/interfaces inherited from class org.waarp.common.database.model.DbModelOracle

DbModelOracle.DBType, DbModelOracle.DbTypeResolverOracle

Nested classes/interfaces inherited from class org.waarp.common.database.model.DbModelAbstract

DbModelAbstract.DbTypeResolver

Field Summary

Fields inherited from class org.waarp.common.database.model.DbModelOracle

oracleConnectionPoolDataSource, pool

Fields inherited from class org.waarp.common.database.model.DbModelAbstract

dbTypeResolver, MAX_BINARY, MAX_KEY_VARCHAR, MAX_LONGVARCHAR, MAX_VARCHAR

Constructor Summary

Constructors

Constructor and Description
DbModelOracleKernel(String dbserver, String dbuser, String dbpasswd) Create the object and initialize if necessary the driver

Method Summary

Modifier and Type	Method and Description
static void	createTableMonitoring(DbSession session)
void	createTables(DbSession session) Create all necessary tables into the database
boolean	needUpgradeDb(DbSession session, String version, boolean tryFix) Check if Database is ok from version
long	nextSequence(DbSession dbSession)
void	resetSequence(DbSession session, long newvalue) Reset the sequence (example)
boolean	upgradeDb(DbSession session, String version) Upgrade Database from version

Methods inherited from class org.waarp.common.database.model.DbModelOracle

currentNumberOfPooledConnections, getDbConnection, getDbType, limitRequest, releaseResources, validConnectionString

Methods inherited from class org.waarp.common.database.model.DbModelAbstract

closeInternalConnection, getDbTypeResolver, validConnection, validConnectionSelect

Methods inherited from class java.lang.Object

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

Constructor Detail

DbModelOracleKernel

public DbModelOracleKernel(String dbserver,
                           String dbuser,
                           String dbpasswd)
                    throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

Throws:

WaarpDatabaseNoConnectionException

Method Detail

createTables

public final void createTables(DbSession session)
                        throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Create all necessary tables into the database

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

createTableMonitoring

public static void createTableMonitoring(DbSession session)
                                  throws WaarpDatabaseNoConnectionException

Throws:

WaarpDatabaseNoConnectionException

resetSequence

public final void resetSequence(DbSession session,
                                long newvalue)
                         throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Reset the sequence (example)

Specified by:

resetSequence in interface DbModel

Overrides:

resetSequence in class DbModelOracle

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

nextSequence

public final long nextSequence(DbSession dbSession)

Specified by:

nextSequence in interface DbModel

Overrides:

nextSequence in class DbModelOracle

Returns:

The next unique specialId

upgradeDb

public final boolean upgradeDb(DbSession session,
                               String version)

Description copied from interface: DbModel

Upgrade Database from version

Returns:

True if the Database is upgraded

needUpgradeDb

public final boolean needUpgradeDb(DbSession session,
                                   String version,
                                   boolean tryFix)

Description copied from interface: DbModel

Check if Database is ok from version

tryFix - True will imply a try to fix if possible

Returns:

True if the Database needs an upgrade