Package xal.plugin.mysql

Class MySQLDatabaseAdaptor

java.lang.Object

xal.tools.database.DatabaseAdaptor

xal.plugin.mysql.MySQLDatabaseAdaptor

public class MySQLDatabaseAdaptor
extends DatabaseAdaptor

Constructor Summary

Constructors

Constructor	Description
MySQLDatabaseAdaptor()

Method Summary

Modifier and Type	Method	Description
List<String>	fetchAllSchemas(Connection connection)	Fetch all schemas from the connected database.
Array	getArray(String type, Connection connection, Object array)	Get an SQL Array given an SQL array type, connection and a primitive array
ResultSet	getColumnsResultSet(DatabaseMetaData metaData, String schema, String table)	Get the result set of columns for the specified meta data, schema and table.
Connection	getConnection(String urlSpec, String user, String password)	Get a new database connection
ResultSet	getPrimaryKeysResultSet(DatabaseMetaData metaData, String schema, String table)	Get the result set of primary keys for the specified meta data, schema and table.
ResultSet	getTablesResultSet(DatabaseMetaData metaData, String schema)	Get the result set for tables for the specified meta data and schema.

Methods inherited from class xal.tools.database.DatabaseAdaptor

fetchNontrivialSchemas, fetchPrimaryKeys, fetchTables, getConnection, getInstance, newBlob

Methods inherited from class java.lang.Object

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

Constructor Details

MySQLDatabaseAdaptor

public MySQLDatabaseAdaptor()

Method Details

getArray

public Array getArray(String type,
 Connection connection,
 Object array)
               throws DatabaseException

Description copied from class: DatabaseAdaptor

Get an SQL Array given an SQL array type, connection and a primitive array

Specified by:

getArray in class DatabaseAdaptor

Parameters:

type - An SQL array type identifying the type of array

connection - An SQL connection

array - The primitive Java array

Returns:

the SQL array which wraps the primitive array

Throws:

DatabaseException - if a database exception is thrown

getConnection

public Connection getConnection(String urlSpec,
 String user,
 String password)
                         throws DatabaseException

Description copied from class: DatabaseAdaptor

Get a new database connection

Overrides:

getConnection in class DatabaseAdaptor

Parameters:

urlSpec - The URL to which to connect

user - The user login into the database

password - the user's password

Throws:

DatabaseException - if a database exception is thrown

fetchAllSchemas

public List<String> fetchAllSchemas(Connection connection)
                             throws DatabaseException

Fetch all schemas from the connected database. MySQL adaptor returns catalogs instead of schemas.

Overrides:

fetchAllSchemas in class DatabaseAdaptor

Returns:

list of all schemas in the database

Throws:

DatabaseException

DatabaseException - if the schema fetch fails

getTablesResultSet

public ResultSet getTablesResultSet(DatabaseMetaData metaData,
 String schema)
                             throws SQLException

Get the result set for tables for the specified meta data and schema. MySQL adaptor uses the catalog in place of schema.

Overrides:

getTablesResultSet in class DatabaseAdaptor

Throws:

SQLException

getColumnsResultSet

public ResultSet getColumnsResultSet(DatabaseMetaData metaData,
 String schema,
 String table)
                              throws SQLException

Get the result set of columns for the specified meta data, schema and table. MySQL adaptor uses the catalog in place of schema.

Overrides:

getColumnsResultSet in class DatabaseAdaptor

Throws:

SQLException

getPrimaryKeysResultSet

public ResultSet getPrimaryKeysResultSet(DatabaseMetaData metaData,
 String schema,
 String table)
                                  throws SQLException

Get the result set of primary keys for the specified meta data, schema and table. MySQL adaptor uses the catalog in place of schema.

Overrides:

getPrimaryKeysResultSet in class DatabaseAdaptor

Throws:

SQLException