org.waarp.common.database.model

Class DbModelCommonMariadbMySql

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelCommonMariadbMySql

All Implemented Interfaces:

DbModel

Direct Known Subclasses:

DbModelMariadb, DbModelMysql

public abstract class DbModelCommonMariadbMySql
extends DbModelAbstract

MariaDB/MySQL common Database Model implementation

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	DbModelCommonMariadbMySql.DBType

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.DbModelAbstract

dbTypeResolver

Constructor Summary

Constructors

Constructor and Description
DbModelCommonMariadbMySql()

Method Summary

Modifier and Type	Method and Description
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	resetSequence(DbSession session, long newvalue) Reset the sequence (example)
protected String	validConnectionString()

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

closeInternalConnection, currentNumberOfPooledConnections, getDbConnection, getDbTypeResolver, releaseResources, 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, getDbType, needUpgradeDb, upgradeDb

Constructor Detail

DbModelCommonMariadbMySql

public DbModelCommonMariadbMySql()

Method Detail

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 String validConnectionString()

Specified by:

validConnectionString in class DbModelAbstract

Returns:

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

limitRequest

public 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