Chapter 6 Using Adaptive Server Anywhere with Jaguar

Jaguar and Adaptive Server Anywhere architecture

The following diagram shows the architecture of a Jaguar server and an Adaptive Server Anywhere database.

Components make calls to an Adaptive Server Anywhere database server. A Jaguar server uses the transaction manager, which is a part of Jaguar, 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. The Jaguar server 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 is 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 execute a stored procedure or directly update to or retrieve data from rows in a table in the database.