General properties

The properties that you configure on the General tab are:

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 A description of the connection cache. The description is a string with a maximum of 255 characters.

Database Type The database type. Required for caches that use the EAServer automatic persistence or stateful failover features, such as EJB CMP entity beans.Several types are predefined, and you can create your own. See “Database type setting” for more information.

Server Name For each of these database driver types, enter:

JDBC – the URL appropriate for use in JDBC calls. For more information, see “About JDBC connection URLs”.
ODBC – the ODBC data source name. See “About ODBC data source names” for more information.
CTLIB – the server name as it would be specified in a ct_connect call. On UNIX platforms, the server must be listed in the EAServer interfaces file. For Windows, it must be listed in the ini\sql.ini file.
OCI 7.X – the Oracle SQL*Net connect string or database alias.
OCI 8.X – the Oracle SQL*Net connect string or database alias.
OCI 9.X – the Oracle SQL*Net connect string or database alias.

For XA connections, enter the name of the XA resource server. For JDBC, enter:

NetworkProtocol=Tds:Server=yourServer:Port=TdsPort

where yourServer is the server that the driver is installed on, and TdsPort is the port number where TDS calls are received.

For ODBC or JDBC connections, see your driver documentation for more information. For OCI connections, see your Oracle documentation.

jConnect metadata support required If you have transactional components that use jConnect caches, make sure the jConnect DatabaseMetaData stored procedures are installed on the database server.

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.

The cache user name and password are always used for the initial connection, but you can configure set-proxy support so that a component’s database work is done using the client identity. See com.sybase.jaguar.conncache.ssa for more information.

Password The password for this cache. The password and user name are used to connect to the database identified by the server entry. Passwords are encrypted in the EAServer configuration file.

EAServer Manager does not display passwords for existing caches. To change a password, enter the new password and click OK.