Package marauroa.server.db.adapter

Class MySQLDatabaseAdapter

java.lang.Object

marauroa.server.db.adapter.AbstractDatabaseAdapter

marauroa.server.db.adapter.MySQLDatabaseAdapter

All Implemented Interfaces:

DatabaseAdapter

public class MySQLDatabaseAdapter
extends AbstractDatabaseAdapter

abstracts from MySQL specifications

Author:

hendrik

Field Summary

Fields inherited from class marauroa.server.db.adapter.AbstractDatabaseAdapter

connection, resultSets, statements

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	MySQLDatabaseAdapter()	creates a new MySQLDatabaseAdapter for test purposes, without connection to the DB
	MySQLDatabaseAdapter(Properties connInfo)	creates a new MySQLDatabaseAdapter

Method Summary

Modifier and Type	Method	Description
protected Connection	createConnection(Properties connInfo)	This method creates the real connection to database.
protected String	rewriteSql(String sql)	rewrites CREATE TABLE statements to add TYPE=InnoDB

Methods inherited from class marauroa.server.db.adapter.AbstractDatabaseAdapter

close, commit, doesColumnExist, doesTableExist, execute, execute, executeBatch, getColumnLength, getLastInsertId, isConnectionError, prepareStatement, query, querySingleCellInt, rollback, verifyConnection

Methods inherited from class java.lang.Object

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

Constructor Details

MySQLDatabaseAdapter

public MySQLDatabaseAdapter(Properties connInfo)
                     throws DatabaseConnectionException

creates a new MySQLDatabaseAdapter

Parameters:

connInfo - parameters specifying the connection

Throws:

DatabaseConnectionException - if the connection cannot be established.

MySQLDatabaseAdapter

protected MySQLDatabaseAdapter()
                        throws DatabaseConnectionException

creates a new MySQLDatabaseAdapter for test purposes, without connection to the DB

Throws:

DatabaseConnectionException - if the connection cannot be established.

Method Details

createConnection

protected Connection createConnection(Properties connInfo)
                               throws SQLException,
DatabaseConnectionException

Description copied from class: AbstractDatabaseAdapter

This method creates the real connection to database.

Overrides:

createConnection in class AbstractDatabaseAdapter

Parameters:

connInfo - connection information like url, username and password

Returns:

a connection to the database

Throws:

SQLException - if the connection cannot be established.

DatabaseConnectionException - if the connection cannot be established.

rewriteSql

protected String rewriteSql(String sql)
                     throws SQLException

rewrites CREATE TABLE statements to add TYPE=InnoDB

Overrides:

rewriteSql in class AbstractDatabaseAdapter

Parameters:

sql - original SQL statement

Returns:

modified SQL statement

Throws:

SQLException - in case of a database error