org.kepler.util.sql

Class MySQL

java.lang.Object

org.kepler.util.sql.DatabaseType

org.kepler.util.sql.MySQL

public class MySQL
extends DatabaseType

An implementation of DatabaseType for MySQL.

Author:

Daniel Crawl

Field Summary

Fields inherited from class org.kepler.util.sql.DatabaseType

_connection, _createIndexes, VERSION_TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	MySQL() Only this package (DatabaseFactory) can instantiate.

Method Summary

Modifier and Type	Method and Description
protected java.lang.String	_getCreateTableSuffix() Get any suffix used when creating tables.
protected java.lang.String	_getDriverName() Get the driver class name.
protected java.lang.String	_getJDBCUrl(java.lang.String hostName, java.lang.String port, java.lang.String databaseName) Get a JDBC URL.
protected java.lang.String	_getTypeString(Column column) Get the SQL string of a column type.
protected boolean	_hasGeneratedKeys() Returns true if database supports auto-generated keys in its prepared statements.
void	connect(java.util.Map<java.lang.String,java.lang.String> parameters) Connect to a database.
java.lang.String	getName() Get the name of the type.
void	renameColumn(java.lang.String oldName, Column newColumn, java.lang.String tableName) Rename a column.
void	setColumnNotNull(Column column, java.lang.String tableName) Set not null constraint to a column.
void	setColumnNull(Column column, java.lang.String tableName) Change a column to allow null values.

Methods inherited from class org.kepler.util.sql.DatabaseType

_areForeignKeysIndexed, _arePrimaryKeysIndexed, _combineHostAndPort, _connectInitialize, _executeSQL, _getConnection, _getConnection, _getPort, _hasCatalog, _isAutoIncResultReferencedByName, _isIdentifierTooLong, _isTableCached, _needCapitalColumnNames, _needCapitalTableNames, _needIdentityForAutoInc, _needSequencesForAutoInc, addMinorVersion, changeColumnType, commit, copyColumn, createColumn, createColumn, createColumn, createIndex, createIndex, createTables, createTables, createVersionTable, deleteColumn, disconnect, getColumnAlterStr, getColumnDefinition, getColumnDefinition, getColumnName, getColumnNames, getColumnSize, getConnection, getDefaultTimeStr, getFalseValue, getMajorVersion, getMinorVersion, getPrepStatement, getPrimaryFileExtension, getSQLDelete, getSQLInsert, getSQLInsert, getSQLSelect, getSQLSelect, getSQLUpdate, getStatement, getTableName, getTrueValue, getVersionString, hasNewerSchema, hasOlderSchema, insert, needAbsolutePathForName, needHostForConnect, needPasswordForConnect, needUserForConnect, procedureExists, rollback, setAutoCommit, tableExists, tableExists, updateMinorVersion

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQL

protected MySQL()

Only this package (DatabaseFactory) can instantiate.

Method Detail

connect

public void connect(java.util.Map<java.lang.String,java.lang.String> parameters)
             throws java.sql.SQLException

Connect to a database.

Overrides:

connect in class DatabaseType

Throws:

java.sql.SQLException

getName

public java.lang.String getName()

Get the name of the type.

Specified by:

getName in class DatabaseType

renameColumn

public void renameColumn(java.lang.String oldName,
                         Column newColumn,
                         java.lang.String tableName)
                  throws java.sql.SQLException

Rename a column.

Specified by:

renameColumn in class DatabaseType

Throws:

java.sql.SQLException

setColumnNull

public void setColumnNull(Column column,
                          java.lang.String tableName)
                   throws java.sql.SQLException

Change a column to allow null values.

Specified by:

setColumnNull in class DatabaseType

Throws:

java.sql.SQLException

setColumnNotNull

public void setColumnNotNull(Column column,
                             java.lang.String tableName)
                      throws java.sql.SQLException

Set not null constraint to a column.

Specified by:

setColumnNotNull in class DatabaseType

Throws:

java.sql.SQLException

_getCreateTableSuffix

protected java.lang.String _getCreateTableSuffix()

Get any suffix used when creating tables.

Overrides:

_getCreateTableSuffix in class DatabaseType

_getDriverName

protected java.lang.String _getDriverName()

Get the driver class name.

Specified by:

_getDriverName in class DatabaseType

_getJDBCUrl

protected java.lang.String _getJDBCUrl(java.lang.String hostName,
                                       java.lang.String port,
                                       java.lang.String databaseName)
                                throws java.sql.SQLException

Get a JDBC URL.

Specified by:

_getJDBCUrl in class DatabaseType

Throws:

java.sql.SQLException

_getTypeString

protected java.lang.String _getTypeString(Column column)

Get the SQL string of a column type.

Specified by:

_getTypeString in class DatabaseType

_hasGeneratedKeys

protected boolean _hasGeneratedKeys()

Returns true if database supports auto-generated keys in its prepared statements.

Specified by:

_hasGeneratedKeys in class DatabaseType