org.waarp.openr66.database.model

Class DbModelMysqlR66

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelCommonMariadbMySql

org.waarp.common.database.model.DbModelMysql

org.waarp.openr66.database.model.DbModelMysqlR66

All Implemented Interfaces:

DbModel

public class DbModelMysqlR66
extends DbModelMysql

MySQL Database Model implementation

Nested Class Summary

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

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 inherited from class org.waarp.common.database.model.DbModelMysql

MYSQL_DRIVER_JRE6, MYSQL_DRIVER_JRE8, mysqlConnectionPoolDataSource, pool

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

dbTypeResolver, MAX_BINARY, MAX_KEY_VARCHAR, MAX_LONGVARCHAR, MAX_VARCHAR

Constructor Summary

Constructors

Constructor and Description
DbModelMysqlR66(String dbserver, String dbuser, String dbpasswd) Create the object and initialize if necessary the driver

Method Summary

Modifier and Type	Method and Description
void	createTables(DbSession session) Create all necessary tables into the database
boolean	needUpgradeDb(DbSession session, String version, boolean tryFix) Check if Database is ok from version
boolean	upgradeDb(DbSession session, String version) Upgrade Database from version

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

currentNumberOfPooledConnections, getDbConnection, getDbType, releaseResources

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

Constructor Detail

DbModelMysqlR66

public DbModelMysqlR66(String dbserver,
                       String dbuser,
                       String dbpasswd)
                throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

Throws:

WaarpDatabaseNoConnectionException

Method Detail

createTables

public final void createTables(DbSession session)
                        throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Create all necessary tables into the database

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

upgradeDb

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

Description copied from interface: DbModel

Upgrade Database from version

Returns:

True if the Database is upgraded

Throws:

WaarpDatabaseNoConnectionException

needUpgradeDb

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

Description copied from interface: DbModel

Check if Database is ok from version

tryFix - True will imply a try to fix if possible

Returns:

True if the Database needs an upgrade

Throws:

WaarpDatabaseNoConnectionException