Other databases

EAServer components can connect to any database for which an ODBC or JDBC driver is available. Contact your database vendor for information on JDBC or ODBC driver availability.

NoteDo not use the Sun JDBC-ODBC bridge driver for production Do not use the Sun JDBC-ODBC driver in production application deployment, or to support persistence for the EAServer message service. This driver is suitable only for demonstration use only.

To achieve ODBC connectivity, install the appropriate driver, configure a data source that uses the ODBC driver to connect to the target database, then define an EAServer data source to use it.

To achieve JDBC connectivity, install the appropriate JDBC driver, then define an EAServer data source that uses that driver to connect to the target server. When you run the server, you must include the path to the driver’s class file in your system’s CLASSPATH setting. Many drivers require configuration. For example, you may need to install stored procedures on each server to which you intend to connect. See your JDBC driver documentation for complete configuration instructions.

NoteMost JDBC drivers provide standalone test utility applications (or at least sample applications) that you can use to verify that the driver and data sources are correctly configured. Verify connectivity with a standalone application before configuring EAServer to use a new driver and data source combination.

See “Configuring data sources” for information on defining data sources.