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.
Do not use the Sun JDBC-ODBC bridge driver
This driver is suitable for demonstration use only. Do not
use the Sun JDBC-ODBC driver in production application deployment,
or to support persistence for the EAServer message service.
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 connection cache that uses that data source.
To achieve JDBC connectivity, install the appropriate JDBC driver, then define an EAServer connection cache 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 further configuration. For example, you may have to install stored procedures on each server that you intend to connect to. See your JDBC driver documentation for further configuration instructions.
Most 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 connection caches” for information on defining connection caches.
