com.ontimize.db.sql

Interface SQLHandler

All Known Implementing Classes:

AbstractSQLHandler, AccessSQLHandler, HSQLDBSQLHandler, MySQLSQLHandler, OracleSQLHandler, PostgreSQLHandler, SQLServerSQLHandler

public interface SQLHandler

Interface to be implemented by all database handlers. Two methods are different because they manage the parameter connection in a different mode.

Author:

Imatia Innovation

Field Summary

Fields

Modifier and Type	Field and Description
static String	CLOSE_PARENTHESIS
static String	OPEN_PARENTHESIS

Method Summary

Methods

Modifier and Type	Method and Description
ISQLInfo	alterSQLTable(List sqlTables, Connection connection) This method alters a database table.
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.
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.
ISQLInfo	dropSQLTableTransactional(List sqlTables, Connection connection) This method drops a database table in transactional mode.
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	getSQLTypeName(int sqlType)

Field Detail

OPEN_PARENTHESIS

static final String OPEN_PARENTHESIS

See Also:

Constant Field Values

CLOSE_PARENTHESIS

static final String CLOSE_PARENTHESIS

See Also:

Constant Field Values

Method Detail

createStatementCreateTable

String createStatementCreateTable(SQLTableCreation table)
                                  throws Exception

Return the SQL Statement to create the table.

Parameters:

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

Returns:

a String with the SQL statement

Throws:

Exception

createStatementDropTable

String createStatementDropTable(SQLTableDrop table)
                                throws Exception

Return the SQL Statement to drop the table.

Parameters:

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

Returns:

a String with the SQL statement

Throws:

Exception

createStatementAlterTable

String createStatementAlterTable(SQLTableAlter table)
                                 throws Exception

Return the SQL Statement to alter the table.

Parameters:

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

Returns:

a String with the SQL statement

Throws:

Exception

createSQLTable

ISQLInfo createSQLTable(List sqlTables,
                      Connection connection)

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);


Parameters:

sqlTables - list with all sqlTables

connection - the connection

dropSQLTable

ISQLInfo dropSQLTable(List sqlTables,
                    Connection connection)

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);


Parameters:

sqlTables - list with all sqlTables

connection - the connection

alterSQLTable

ISQLInfo alterSQLTable(List sqlTables,
                     Connection connection)

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);


Parameters:

sqlTables - list with all sqlTables

connection - the connection

createSQLTableTransactional

ISQLInfo createSQLTableTransactional(List sqlTables,
                                   Connection connection)
                                     throws Exception

This method creates a database table in transactional mode.

Call diagram of this method:

-execute sql to create all tables

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

dropSQLTableTransactional

ISQLInfo dropSQLTableTransactional(List sqlTables,
                                 Connection connection)
                                   throws Exception

This method drops a database table in transactional mode.

Call diagram of this method:

-execute sql to drop all tables

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

alterSQLTableTransactional

ISQLInfo alterSQLTableTransactional(List sqlTables,
                                  Connection connection)
                                    throws Exception

This method alters a database table in transactional mode.

Call diagram of this method:

-execute sql to alter all tables

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

executeSQLTable

ISQLInfo executeSQLTable(List sqlTables,
                       Connection connection)

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);


Parameters:

sqlTables - list with all sqlTables

connection - the connection

executeSQLTableTransactional

ISQLInfo executeSQLTableTransactional(List sqlTables,
                                    Connection connection)
                                      throws Exception

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

Parameters:

sqlTables - list with all sqlTables

connection - the connection

Throws:

Exception

getSQLTypeName

String getSQLTypeName(int sqlType)
                      throws Exception

Throws:

Exception