org.waarp.common.database.model

Class DbModelMysql

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelCommonMariadbMySql

org.waarp.common.database.model.DbModelMysql

All Implemented Interfaces:

DbModel

Direct Known Subclasses:

DbModelMysqlFtp, DbModelMysqlKernel, DbModelMysqlR66

public abstract class DbModelMysql
extends DbModelCommonMariadbMySql

MySQL Database Model implementation

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected static class	DbModelMysql.DbTypeResolverMySQL

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

DbModelCommonMariadbMySql.DBType

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

DbModelAbstract.DbTypeResolver

Field Summary

Fields

Modifier and Type	Field and Description
static String	MYSQL_DRIVER_JRE6
static String	MYSQL_DRIVER_JRE8
protected ConnectionPoolDataSource	mysqlConnectionPoolDataSource
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	DbModelMysql() Create the object and initialize if necessary the driver
protected	DbModelMysql(String dbserver, String dbuser, String dbpasswd) Create the object and initialize if necessary the driver
protected	DbModelMysql(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()
void	releaseResources() Release any internal resources if needed

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

limitRequest, nextSequence, resetSequence, 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

MYSQL_DRIVER_JRE6

public static final String MYSQL_DRIVER_JRE6

See Also:

Constant Field Values

MYSQL_DRIVER_JRE8

public static final String MYSQL_DRIVER_JRE8

See Also:

Constant Field Values

mysqlConnectionPoolDataSource

protected ConnectionPoolDataSource mysqlConnectionPoolDataSource

pool

protected DbConnectionPool pool

Constructor Detail

DbModelMysql

protected DbModelMysql(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

DbModelMysql

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

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

Throws:

WaarpDatabaseNoConnectionException

DbModelMysql

protected DbModelMysql()
                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 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