org.waarp.common.database.model

Class DbModelOracle

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelOracle

All Implemented Interfaces:

DbModel

Direct Known Subclasses:

DbModelOracleFtp, DbModelOracleKernel, DbModelOracleR66

public abstract class DbModelOracle
extends DbModelAbstract

Oracle Database Model implementation

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	DbModelOracle.DBType
protected static class	DbModelOracle.DbTypeResolverOracle

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

DbModelAbstract.DbTypeResolver

Field Summary

Fields

Modifier and Type	Field and Description
protected oracle.jdbc.pool.OracleConnectionPoolDataSource	oracleConnectionPoolDataSource
protected DbConnectionPool	pool

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

dbTypeResolver, MAX_BINARY, MAX_KEY_VARCHAR, MAX_LONGVARCHAR, MAX_VARCHAR

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DbModelOracle() Create the object and initialize if necessary the driver
protected	DbModelOracle(String dbserver, String dbuser, String dbpasswd) Create the object and initialize if necessary the driver
protected	DbModelOracle(String dbserver, String dbuser, String dbpasswd, Timer timer, long delay) Create the object and initialize if necessary the driver

Method Summary

Modifier and Type	Method and Description
int	currentNumberOfPooledConnections()
Connection	getDbConnection(String server, String user, String passwd)
DbType	getDbType()
String	limitRequest(String allfields, String request, int nb) Add a limit on the request to get the "limit" first rows.
long	nextSequence(DbSession dbSession)
void	releaseResources() Release any internal resources if needed
void	resetSequence(DbSession session, long newvalue) Reset the sequence (example)
protected String	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

Methods inherited from interface org.waarp.common.database.model.DbModel

createTables, needUpgradeDb, upgradeDb

Field Detail

oracleConnectionPoolDataSource

protected oracle.jdbc.pool.OracleConnectionPoolDataSource oracleConnectionPoolDataSource

pool

protected DbConnectionPool pool

Constructor Detail

DbModelOracle

protected DbModelOracle(String dbserver,
                        String dbuser,
                        String dbpasswd,
                        Timer timer,
                        long delay)
                 throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

timer -

delay -

Throws:

WaarpDatabaseNoConnectionException

DbModelOracle

protected DbModelOracle(String dbserver,
                        String dbuser,
                        String dbpasswd)
                 throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

Throws:

WaarpDatabaseNoConnectionException

DbModelOracle

protected DbModelOracle()
                 throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Throws:

WaarpDatabaseNoConnectionException

Method Detail

getDbType

public final DbType getDbType()

Returns:

the current DbType used

releaseResources

public final void releaseResources()

Description copied from interface: DbModel

Release any internal resources if needed

Specified by:

releaseResources in interface DbModel

Overrides:

releaseResources in class DbModelAbstract

currentNumberOfPooledConnections

public final int currentNumberOfPooledConnections()

Specified by:

currentNumberOfPooledConnections in interface DbModel

Overrides:

currentNumberOfPooledConnections in class DbModelAbstract

Returns:

the number of Pooled Connections if any

getDbConnection

public final Connection getDbConnection(String server,
                                        String user,
                                        String passwd)
                                 throws SQLException

Specified by:

getDbConnection in interface DbModel

Overrides:

getDbConnection in class DbModelAbstract

Returns:

a connection according to the underlying Database Model

Throws:

SQLException

resetSequence

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

Description copied from interface: DbModel

Reset the sequence (example)

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

nextSequence

public long nextSequence(DbSession dbSession)
                  throws WaarpDatabaseNoConnectionException,
                         WaarpDatabaseSqlException,
                         WaarpDatabaseNoDataException

Returns:

The next unique specialId

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

WaarpDatabaseNoDataException

validConnectionString

protected final String validConnectionString()

Specified by:

validConnectionString in class DbModelAbstract

Returns:

the associated String to validate the connection (as "select 1 from dual")

limitRequest

public final String limitRequest(String allfields,
                                 String request,
                                 int nb)

Description copied from interface: DbModel

Add a limit on the request to get the "limit" first rows. Note that it must be compatible to add the "limit" condition.
DO NOT CHANGE (add) ANYTHING to the request

On Oracle: select allfield from (request) where rownnum <= limit
On others: request LIMIT limit

Parameters:

allfields - string representing the equivalent to "*" in "select *" but more precisely as "field1, field2" in "select field1, field2"

Returns:

the new request String which will limit the result to the specified number of rows