Configuring database types

Table 4-1 describes the predefined database types. Use the Management Console to modify the definitions of these database types and create other database types.

The predefined database types are configured in the default-database-types.xml Ant configuration file, located in the config subdirectory of your EAServer installation.

Table 4-1: Database types

Database type

Description

JCM_Odbc

An ASA database that uses the com.sybase.jaguar.jcm.odbc.OdbcDriver driver.

JCM_Odbc_Unicode

Adaptive Server Enterprise database that uses the com.sybase.jaguar.jcm.odbc.OdbcuDriver driver.

JCM_Oracle

Oracle database that uses the com.sybase.jaguar.jcm.oracle.OracleDriver driver. This database type corresponds to the EAServer 5.x OCI8, OCI9, and OCI10 native connection caches.

JCM_Oracle_Unicode

Oracle database that uses the com.sybase.jaguar.jcm.oracle.OracleuDriver driver. This database type corresponds to the EAServer 5.x OCI8U, OCI9U, and OCI10U native connection caches.

JCM_Sybase

ASA database that uses the com.sybase.jaguar.jcm.sybase.SybaseDriver driver. This database type corresponds to the EAServer 5.x CTLIB_110 native connection cache.

Oracle

Oracle database that uses the oracle.jdbc.driver.OracleDriver driver.

Sybase_ASA

ASA database that uses the com.sybase.djc.sql.jit.SybaseDataSource3 driver

EAServer uses an ASA database for Java Message Service storage, EJB container-managed persistence, EJB and Web session state storage, and the XA recovery log. To use another database type, reconfigure the default data source—see “Configuring data sources”.

Sybase_ASE

Adaptive Server Enterprise database that uses the com.sybase.djc.sql.jit.SybaseDataSource3 driver.

StepsCreating a new database type

  1. In the Management Console, open the Resources folder.

  2. Highlight Database Types, right-click, and select Add.

  3. Enter the database name in the wizard.

    Database names must be one word, which can contain letters, numbers, and underscores. Names are case-sensitive. You cannot modify the name of an existing database.

Database entries appear in the right pane of the Management Console when you highlight the Database Types folder in the left pane.

StepsDeleting a database type

  1. Expand the Database Types folder.

  2. Highlight the database type to delete, right-click, and select Delete.

  3. In the wizard, select Finish.

StepsConfiguring a database type

  1. Expand the Database Types folder.

  2. Select the database type to configure.

  3. In the right pane, enter the database type properties on these tabs:

    To save your changes, select Apply. To restore the initial values, select Reset.

NoteYou must restart the server for changes to take effect.