General

Select the General tab on the Connection Cache Properties window to set the basic connection cache options described in Table 10-3.

From the General tab window, you can test the cache configuration to verify that connections can be made using the options you supply. See “Connection cache ping” for more information.

Table 10-3: General tab connection cache properties

Property

Description

Comments/Example

Connection Cache Name

The name for this cache configuration.

Connection cache names are limited to one word, which can contain letters, numbers, and underscores. Names are case-sensitive. You cannot modify the name of an existing connection cache.

Description for the cache

The description of the connection cache section.

The description is a string of up to 255 characters.

Server Name

The URL appropriate for use in JDBC calls.

For the Sybase shared-memory JDBC driver, use:

jdbc:sybase:shm:null:0

where host name = null and port = 0 (zero), because the connection is made through shared memory and not through the network.

Driver name

Set the driver name and properties using the Driver tab on the General window.

Your choice for library type is:

  • JDBC – for connections using the Sybase shared-memory JDBC driver.

The names for each of the cache types are:

  • For NT platforms:

    JDBC – the Java class name for the driver class. For example, the Sybase jConnect 5.2 driver requires com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource.

  • For UNIX platforms:

    JDBC – the Java class name for the driver class; for example, com.sybase.jdbc2.jdbc.SybDriver.

User Name

The user name for this cache.

The name used (along with a password) to connect to the database identified by the server entry.

Password

The password for this cache.

The password used in connection with a user name to connect to the database identified by the server entry. Passwords are encrypted in the EJB Server configuration file.

The Adaptive Server plug-in does not display passwords for existing caches. If you need to change a password, enter the new password and click OK.