JDBC MOMIS Wrapper

This wrapper is a standard way to access to all the data sources accessible by JDBC.

Questo wrapper permette l'accesso a sorgenti dati accessibili tramite JDBC.

This is a configurable wrapper. Here is an example of configuration file

#
#
# Configuration file for the MOMIS prototype
#
#
orbPort=1050
orbServer=sparc20.dsi.unimo.it
#
# Time out in seconds
timeOutGracePeriod=28800
timeOutCheckPeriod=3600

#
# Wrapper connection parameters
#
wrapper_serverName=wrDb2Alberto
wrapper_dataUrl=jdbc:db2:alberto
wrapper_dataDriver=COM.ibm.db2.jdbc.app.DB2Driver

where

orbPort port number of the CORBA naming server
orbServer server address of the CORBA naming server
timeOutGracePeriod, timeOutCheckPeriod time out times in seconds
wrapper_serverName name used for registration in the naming server
wrapper_dataUrl Database Connection string, this is DBMS dependent
wrapper_dataDriver reference to the JDBC driver, this is DBMS dependent

It is also available startup script that initialize environment variable (like CLASSPATH) and store log-files pid-numbers and specific configuration file for several JDBC wrapper instance.
To start all configured wrapper is enough the command

startWrapper start

And to stop such drivers

startWrapper stop

Features

It is not quite complete but the following features are implemented:

Translation of all the interface as list of attributes
Query execution, data is returned by CORBA MomisResultSet objects.

Features not yet implemented:

Extraction of coherence information (foreign keys)
Extraction of primary keys

UML class SCHEMA

The MOMIS Home Page