org.waarp.common.database.model

Class EmptyDbModel

java.lang.Object

org.waarp.common.database.model.EmptyDbModel

All Implemented Interfaces:

DbModel

public class EmptyDbModel
extends Object
implements DbModel

Empty DbModel

Author:

"Frederic Bregier"

Constructor Summary

Constructors

Constructor and Description
EmptyDbModel()

Method Summary

Methods

Modifier and Type	Method and Description
void	createTables(DbSession session) Create all necessary tables into the database
int	currentNumberOfPooledConnections()
Connection	getDbConnection(String server, String user, String passwd)
DbType	getDbType()
String	limitRequest(String allfields, String request, int limit) Add a limit on the request to get the "limit" first rows.
boolean	needUpgradeDb(DbSession session, String version, boolean tryFix) Check if Database is ok from version
long	nextSequence(DbSession dbSession)
void	releaseResources() Release any internal resources if needed
void	resetSequence(DbSession session, long newvalue) Reset the sequence (example)
boolean	upgradeDb(DbSession session, String version) Upgrade Database from version
void	validConnection(DbSession dbSession) Validate connection

Methods inherited from class java.lang.Object

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

Constructor Detail

EmptyDbModel

public EmptyDbModel()

Method Detail

getDbConnection

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

Specified by:

getDbConnection in interface DbModel

Returns:

a connection according to the underlying Database Model

Throws:

SQLException

releaseResources

public void releaseResources()

Description copied from interface: DbModel

Release any internal resources if needed

Specified by:

releaseResources in interface DbModel

currentNumberOfPooledConnections

public int currentNumberOfPooledConnections()

Specified by:

currentNumberOfPooledConnections in interface DbModel

Returns:

the number of Pooled Connections if any

getDbType

public DbType getDbType()

Specified by:

getDbType in interface DbModel

Returns:

the current DbType used

createTables

public void createTables(DbSession session)
                  throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Create all necessary tables into the database

Specified by:

createTables in interface DbModel

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

resetSequence

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

Description copied from interface: DbModel

Reset the sequence (example)

Specified by:

resetSequence in interface DbModel

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

nextSequence

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

Specified by:

nextSequence in interface DbModel

Returns:

The next unique specialId

Throws:

WaarpDatabaseNoConnectionException

WaarpDatabaseSqlException

WaarpDatabaseNoDataException

validConnection

public void validConnection(DbSession dbSession)
                     throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Validate connection

Specified by:

validConnection in interface DbModel

Throws:

WaarpDatabaseNoConnectionException

limitRequest

public String limitRequest(String allfields,
                  String request,
                  int limit)

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

Specified by:

limitRequest in interface DbModel

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

upgradeDb

public boolean upgradeDb(DbSession session,
                String version)
                  throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Upgrade Database from version

Specified by:

upgradeDb in interface DbModel

Returns:

True if the Database is upgraded

Throws:

WaarpDatabaseNoConnectionException

needUpgradeDb

public boolean needUpgradeDb(DbSession session,
                    String version,
                    boolean tryFix)
                      throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Check if Database is ok from version

Specified by:

needUpgradeDb in interface DbModel

tryFix - True will imply a try to fix if possible

Returns:

True if the Database needs an upgrade

Throws:

WaarpDatabaseNoConnectionException