A connection cache maintains a pool of available connections that EAServer components use to interact with third-tier data servers. You must configure connection caches for the specific user and database combinations used by your components. A connection cache entry improves performance by eliminating the overhead associated with setting up a connection when one is required. Create as many connection caches as you need.
See Chapter 26, “Using Connection Management,” in the EAServer Programmer’s Guide for additional information.
You must refresh a cache before any changes to the cache properties take effect, and you should test the connection with ping before trying to access it from components.
You cannot define two distinct caches that use identical values for server, user, password, and connectivity library. If two caches are defined with matching values for these settings, and your application requests one, EAServer returns the first match that is found.
Creating
a new connection cache
Highlight the Connection Caches folder.
Select File | New Connection Cache.
Configure the connection cache properties in the wizard.
Configured connection cache entries appear on the right side of the window of EAServer Manager when you highlight the Connection Cache folder on the left side of the window.
Viewing,
modifying, or deleting a connection cache entry
Expand the Connection Caches folder.
Highlight the connection cache you want to modify.
From the File menu, select one of:
Configuration Wizard – a wizard to walk you through the configuration of common properties.
Properties – displays the connection cache’s properties in a single dialog box and allows you to change them.
Delete – deletes the connection cache from the system.
