EDT configuration information

Provides sample event data table (EDT) configuration information for various databases.

For configuration of the EDT, a particular XA provider may use any combination of the EDT properties in addition to the EDTDriverName. If a property must be set for an XA DataSource’s configuration, and it is not present in the activation specification, a configuration file may be used. This file is called EDTExtendedProperties.properties. Place it where the adapter is installed. The property file uses a standard Java™ properties file format.

The sample configuration values that follow omit these properties: EDTUserName, EDTUserPassword, and EDTTableName because they are always required. Also, EDTSchema is omitted as it is only required for a non-default schema. Values shown in brackets are not literal, and you should replace them with appropriate values for your environment during configuration.

Sample values for EDT properties on DB2® databases

Property Sample value
EDTDriverName COM.ibm.db2.jdbc.DB2XADataSource
EDTDatabaseName [an existing database]

Sample values for EDT properties on Cloudscape™ databases

Property Sample value
EDTDriverName com.ibm.db2j.jdbc.DB2jXADataSource
EDTDatabaseName [any name; database need not exist]

Sample values for EDT properties on Informix® databases

Property Sample value
EDTDriverName com.informix.jdbcx.IfxXADataSource
EDTServerName [The name of the Informix instance on the server]
EDTPortNumber [port number]
EDTDatabaseName [The database name]
EDTExtendedProperties.properties Include this file to complete the onfiguration
ifxIFXHOST [The physical name of the database server]

Sample values for EDT properties on Oracle databases

Property Sample value
EDTDriverName oracle.jdbc.xa.client.OracleXADatasource
EDTURL jdbc:oracle:thin:@myServer:1521:myDatabase

Sample values for EDT properties on MS-SQL Server

Property Sample value
EDTDriverName com.microsoft.jdbcx.sqlserver.SQLServerDataSource
EDTServerName [name of server hosting SQLServer]
EDTDatabaseName [name of the existing database]
EDTPortNumber [port]

Sample values for EDT properties on Sybase databases

Property Sample value
EDTDriverName com.sybase.jdbc2.jdbc.SybXADataSource
EDTServerName [name of server hosting Sybase]
EDTDatabaseName [name of the existing database]
EDTPortNumber [port]

Terms of use |

Last updated: Sun Mar 12 11:24:19 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)