Provides sample event data table (EDT) configuration information for various databases.
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] |
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)