Chapter 7 Using Adaptive Server Anywhere with EAServer

EAServer and Adaptive Server Anywhere architecture

Figure 7-1shows the architecture of EAServer and an Adaptive Server Anywhere database.

Figure 7-1: EAServer with an ASA database

Components make calls to an Adaptive Server Anywhere database server. EAServer uses the transaction manager, which is a part of EAServer, to manage these method calls in transactions. Depending on the transaction options of the components, the transaction manager can organize method calls to databases into transactions. EAServer also uses connection caches to pool connections to the Adaptive Server Anywhere database. That is, when a component releases a connection, the connection is not terminated but is placed back into a pool of connections from which another component can reuse that connection.

The simplest ways to connect to an Adaptive Server Anywhere database are to use either a JDBC driver or an ODBC driver. The method call is passed across the network using the selected driver. The method call can either execute a stored procedure, or update or retrieve data from rows in a table in the database.