com.ontimize.db.sql

Class AbstractSQLHandler

java.lang.Object

com.ontimize.db.sql.AbstractSQLHandler

All Implemented Interfaces:

SQLHandler

Direct Known Subclasses:

AccessSQLHandler, HSQLDBSQLHandler, MySQLSQLHandler, OracleSQLHandler, PostgreSQLHandler, SQLServerSQLHandler

public abstract class AbstractSQLHandler
extends Object
implements SQLHandler

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	ADD
protected static String	ALTER_TABLE
protected static String	COLUMN
protected static String	CREATE_TABLE
static boolean	DEBUG
protected static String	DEFAULT
protected static String	DROP
protected static String	DROP_TABLE
protected static String	NOT_NULL

Fields inherited from interface com.ontimize.db.sql.SQLHandler

CLOSE_PARENTHESIS, OPEN_PARENTHESIS

Constructor Summary

Constructors

Constructor and Description
AbstractSQLHandler()

Method Summary

Methods

Modifier and Type	Method and Description
ISQLInfo	alterSQLTable(List sqlTables, Connection connection) This method alters a database table.
String	alterSQLTable(SQLTableAlter table, Connection connection) Alter the table in the database using ANSI standard
ISQLInfo	alterSQLTableTransactional(List sqlTables, Connection connection) This method alters a database table in transactional mode.
ISQLInfo	createSQLTable(List sqlTables, Connection connection) This method creates a database table.
String	createSQLTable(SQLTableCreation table, Connection connection) Creates the table in the database using ANSI standard
ISQLInfo	createSQLTableTransactional(List sqlTables, Connection connection) This method creates a database table in transactional mode.
String	createStatementAlterTable(SQLTableAlter table) Return the SQL Statement to alter the table.
String	createStatementCreateTable(SQLTableCreation table) Return the SQL Statement to create the table.
String	createStatementDropTable(SQLTableDrop table) Return the SQL Statement to drop the table.
ISQLInfo	dropSQLTable(List sqlTables, Connection connection) This method drops a database table.
String	dropSQLTable(SQLTableDrop table, Connection connection) Drop the table in the database using ANSI standard
ISQLInfo	dropSQLTableTransactional(List sqlTables, Connection connection) This method drops a database table in transactional mode.
protected static void	executeSQL(String sql, Connection con) Execute the SQL Statement.
ISQLInfo	executeSQLTable(List sqlTables, Connection connection) This method executes a serial of SQL actions(create,drop or alter) over a database table.
ISQLInfo	executeSQLTableTransactional(List sqlTables, Connection connection) This method executes a serial of SQL actions(create,drop or alter) over a database table in transactional mode.
String	executeStatement(String statement, Connection connection)
String	getCreateStatementAlterTableColumn(SQLTableAlterColumn table)
String	getCreateStatementAlterTableConstraint(SQLTableAlterConstraint table)
protected String	getDefinitionColumn(SQLColumn column, boolean includePrimaryKey)
protected String	getStringDefaultValue(Object value, SQLColumn column)
String	isMultiplePrimaryKey(SQLTableCreation table)

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.ontimize.db.sql.SQLHandler

getSQLTypeName

Field Detail

DEBUG

public static boolean DEBUG

CREATE_TABLE

protected static final String CREATE_TABLE

See Also:

Constant Field Values

DROP_TABLE

protected static final String DROP_TABLE

See Also:

Constant Field Values

ALTER_TABLE

protected static final String ALTER_TABLE

See Also:

Constant Field Values

DEFAULT

protected static final String DEFAULT

See Also:

Constant Field Values

NOT_NULL

protected static final String NOT_NULL

See Also:

Constant Field Values

ADD

protected static final String ADD

See Also:

Constant Field Values

DROP

protected static final String DROP

See Also:

Constant Field Values

COLUMN

protected static final String COLUMN

See Also:

Constant Field Values

Constructor Detail

AbstractSQLHandler

public AbstractSQLHandler()

Method Detail

executeSQLTable

public ISQLInfo executeSQLTable(List sqlTables,
                       Connection connection)

Description copied from interface: SQLHandler

This method executes a serial of SQL actions(create,drop or alter) over a database table. At first, autocommit mode in connection is fixed to false, then its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. Moreover, Exceptions are also managed by this method.

Call diagram of this method:

-connection.setAutoCommit(false);
...
...
-executeSQLTableTransactional
...
...
-connection.setAutoCommit(true);


Specified by:

executeSQLTable in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

executeSQLTableTransactional

public ISQLInfo executeSQLTableTransactional(List sqlTables,
                                    Connection connection)
                                      throws Exception

Description copied from interface: SQLHandler

This method executes a serial of SQL actions(create,drop or alter) over a database table in transactional mode.

Specified by:

executeSQLTableTransactional in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

createSQLTable

public ISQLInfo createSQLTable(List sqlTables,
                      Connection connection)

Description copied from interface: SQLHandler

This method creates a database table. At first, autocommit mode in connection is fixed to false, then its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. Moreover, Exceptions are also managed by this method.

Call diagram of this method:

-connection.setAutoCommit(false);
...
...
-createSQLTableTransactional
...
...
-connection.setAutoCommit(true);


Specified by:

createSQLTable in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

dropSQLTable

public ISQLInfo dropSQLTable(List sqlTables,
                    Connection connection)

Description copied from interface: SQLHandler

This method drops a database table. At first, autocommit mode in connection is fixed to false, then its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. Moreover, Exceptions are also managed by this method.

Call diagram of this method:

-connection.setAutoCommit(false);
...
...
-dropSQLTableTransactional
...
...
-connection.setAutoCommit(true);


Specified by:

dropSQLTable in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

alterSQLTable

public ISQLInfo alterSQLTable(List sqlTables,
                     Connection connection)

Description copied from interface: SQLHandler

This method alters a database table. At first, autocommit mode in connection is fixed to false, then its SQL statements are grouped into transactions that are terminated by a call to either the method commit or the method rollback. Moreover, Exceptions are also managed by this method.

Call diagram of this method:

-connection.setAutoCommit(false);
...
...
-alterSQLTableTransactional
...
...
-connection.setAutoCommit(true);


Specified by:

alterSQLTable in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

createSQLTableTransactional

public ISQLInfo createSQLTableTransactional(List sqlTables,
                                   Connection connection)
                                     throws Exception

Description copied from interface: SQLHandler

This method creates a database table in transactional mode.

Call diagram of this method:

-execute sql to create all tables

Specified by:

createSQLTableTransactional in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

dropSQLTableTransactional

public ISQLInfo dropSQLTableTransactional(List sqlTables,
                                 Connection connection)
                                   throws Exception

Description copied from interface: SQLHandler

This method drops a database table in transactional mode.

Call diagram of this method:

-execute sql to drop all tables

Specified by:

dropSQLTableTransactional in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

alterSQLTableTransactional

public ISQLInfo alterSQLTableTransactional(List sqlTables,
                                  Connection connection)
                                    throws Exception

Description copied from interface: SQLHandler

This method alters a database table in transactional mode.

Call diagram of this method:

-execute sql to alter all tables

Specified by:

alterSQLTableTransactional in interface SQLHandler

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

executeSQL

protected static void executeSQL(String sql,
              Connection con)
                          throws Exception

Execute the SQL Statement.

Parameters:

sql - String which contains the SQL Statement.

con - The connection.

Throws:

Exception

createSQLTable

public String createSQLTable(SQLTableCreation table,
                    Connection connection)
                      throws Exception

Creates the table in the database using ANSI standard

Parameters:

table -

connection -

Throws:

Exception

dropSQLTable

public String dropSQLTable(SQLTableDrop table,
                  Connection connection)
                    throws Exception

Drop the table in the database using ANSI standard

Parameters:

table -

connection -

Throws:

Exception

alterSQLTable

public String alterSQLTable(SQLTableAlter table,
                   Connection connection)
                     throws Exception

Alter the table in the database using ANSI standard

Parameters:

table -

connection -

Throws:

Exception

executeStatement

public String executeStatement(String statement,
                      Connection connection)
                        throws Exception

Throws:

Exception

createStatementCreateTable

public String createStatementCreateTable(SQLTableCreation table)
                                  throws Exception

Description copied from interface: SQLHandler

Return the SQL Statement to create the table.

Specified by:

createStatementCreateTable in interface SQLHandler

Parameters:

table - The SQLTableCreation table with whole information to create it.

Returns:

a String with the SQL statement

Throws:

Exception

getDefinitionColumn

protected String getDefinitionColumn(SQLColumn column,
                         boolean includePrimaryKey)
                              throws Exception

Throws:

Exception

getStringDefaultValue

protected String getStringDefaultValue(Object value,
                           SQLColumn column)

isMultiplePrimaryKey

public String isMultiplePrimaryKey(SQLTableCreation table)

createStatementDropTable

public String createStatementDropTable(SQLTableDrop table)
                                throws Exception

Description copied from interface: SQLHandler

Return the SQL Statement to drop the table.

Specified by:

createStatementDropTable in interface SQLHandler

Parameters:

table - The SQLTableDrop table with whole information to drop it.

Returns:

a String with the SQL statement

Throws:

Exception

createStatementAlterTable

public String createStatementAlterTable(SQLTableAlter table)
                                 throws Exception

Description copied from interface: SQLHandler

Return the SQL Statement to alter the table.

Specified by:

createStatementAlterTable in interface SQLHandler

Parameters:

table - The SQLTableAlter table with whole information to alter it.

Returns:

a String with the SQL statement

Throws:

Exception

getCreateStatementAlterTableColumn

public String getCreateStatementAlterTableColumn(SQLTableAlterColumn table)
                                          throws Exception

Throws:

Exception

getCreateStatementAlterTableConstraint

public String getCreateStatementAlterTableConstraint(SQLTableAlterConstraint table)
                                              throws Exception

Throws:

Exception