Package org.imemex.datasourceplugins.jdbc

This package implements a data source plugin (DSP) to connect iMeMex to JDBC resources.

See:
Description

Class Summary

Activator	Activator for the JDBC data source plugin.
BlackBoxTools
ConnectionPool	This connection pool manages a stack of connections for a given connection URL and connection properties.
Constants
DatabaseResourceView	A resource view for a connection to a database.
DBLPTest	This test does the following on shrek12.inf.ethz.ch: Test 1: Connection to database Test 2: Schema retrieval Test 3: Query
JDBCConnectionTest	This test does the following on a local MySQL imemextest database: Test 1: Connection to database Test 2: Schema retrieval Test 3: Table RV and Row RV patterns Test 4: Scan the beginning
JDBCDataSourcePlugin	A data source plugin to connect to JDBC data sources.
PoolAndSchema	Read-only object glueing a connection pool to the schema information.
ResultSetPullOperator	Abstract pull operator which works on a JDBC result set.
ResultSetQueryPullOperator	Pull operator which works using an arbitrary SQL query.
ResultSetTablePullOperator	Pull operator which works on a relational table using a simple 'select * from table' query.
RowResourceView	An in-memory resource view for a row.
RulesTest
SchemaColumn	Schema information for a column.
SchemaDatabase	Schema information for a single connection to a database.
SchemaTable	Schema information for a table.
SqlDialects	Centralized handling of SQL dialects.
SqlQuery
SqlScan	Execute a scan over the complete database given some date.
SqlTools	Some tools to help working with java.sql
SqlToolsTypes	Helper class to get names for JDBC Type values.
TableGroup	Group to be used for tables.
TableResourceView	A resource view representing a table.

Package org.imemex.datasourceplugins.jdbc Description

This package implements a data source plugin (DSP) to connect iMeMex to JDBC resources.

Resource Views

Three PluginIdentifiableResourceView implementations are used:

• DatabaseResourceView: start view
• TableResourceView: for each table
• RowResourceView: for each row

Connection Pool

We use a simple connection pool to reuse connections to a database. Since this DSP must be able to handle multiple JDBC resources simultaneously, we use a connection pool for each resource.

Schema Information

The schema information is stored in the following objects:

• SchemaDatabase
• SchemaTable
• SchemaColumn