Constructor and Description |
---|
EmptyDbModel() |
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() |
DbModelAbstract.DbTypeResolver |
getDbTypeResolver() |
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
|
public Connection getDbConnection(String server, String user, String passwd) throws SQLException
getDbConnection
in interface DbModel
SQLException
public void releaseResources()
DbModel
releaseResources
in interface DbModel
public int currentNumberOfPooledConnections()
currentNumberOfPooledConnections
in interface DbModel
public DbType getDbType()
public DbModelAbstract.DbTypeResolver getDbTypeResolver()
getDbTypeResolver
in interface DbModel
public void createTables(DbSession session) throws WaarpDatabaseNoConnectionException
DbModel
createTables
in interface DbModel
session
- SQL sessionWaarpDatabaseNoConnectionException
public void resetSequence(DbSession session, long newvalue) throws WaarpDatabaseNoConnectionException
DbModel
resetSequence
in interface DbModel
session
- SQL sessionWaarpDatabaseNoConnectionException
public long nextSequence(DbSession dbSession) throws WaarpDatabaseNoConnectionException, WaarpDatabaseSqlException, WaarpDatabaseNoDataException
nextSequence
in interface DbModel
WaarpDatabaseNoConnectionException
WaarpDatabaseSqlException
WaarpDatabaseNoDataException
public void validConnection(DbSession dbSession) throws WaarpDatabaseNoConnectionException
DbModel
validConnection
in interface DbModel
WaarpDatabaseNoConnectionException
public String limitRequest(String allfields, String request, int limit)
DbModel
On Oracle: select allfield from (request) where rownnum <= limit
On others: request LIMIT limit
limitRequest
in interface DbModel
allfields
- string representing the equivalent to "*" in
"select
*" but more precisely as "field1,
field2" in "select field1, field2"public boolean upgradeDb(DbSession session, String version) throws WaarpDatabaseNoConnectionException
DbModel
upgradeDb
in interface DbModel
WaarpDatabaseNoConnectionException
public boolean needUpgradeDb(DbSession session, String version, boolean tryFix) throws WaarpDatabaseNoConnectionException
DbModel
needUpgradeDb
in interface DbModel
tryFix
- True will imply a try to fix if possibleWaarpDatabaseNoConnectionException
Copyright © 2009–2020 Waarp. All rights reserved.