WebSphere Adapter for JDBC
Resource adapter properties consist of logging and tracing, bidirectional language support, and activities specific to the adapter, such as the default configuration properties of the adapter. You configure these properties using the enterprise service discovery wizard or the administrative console of the server.
When you configure the adapter, specify the resource adapter properties listed in the tables below. The bidirectional resource adapter properties that need to be configured when bidirectional text transformation has been activated are described in a separate table in this section.
Property | Type | Description | Globalized | Default value |
---|---|---|---|---|
BONameSpace | String | Namespace for the business object definitions to be used by this adapter. This value should be taken from the value you provided during the metadata discovery process. This property is required. | No | None |
DatabaseVendor | String | Specifies which RDBMS the adapter uses for special processing. Set the value to DB2, Oracle, or MSSQLServer if using an IBM® DB2®, Oracle, or Microsoft® SQL Server database. If using a different database, set the value to the name of that database. If using a non-default database, ensure that the proper driver is loaded. If this property is set to Others, the adapter determines which database to use by locating the driver. A value is required for the adapter to process successfully. | No | None |
enableHASupport | String | When the enableHASupport property is set to true, only one of the replicated adapter instances actively polls for events while other instances are in standby mode. If the enableHASupport property is set to false, all of the adapter instances replicated on cluster members actively poll for events. This may result in event duplication. Do not change the value of enableHASupport to false for single server environments. | true | |
LogFileName | String | The full path of the log file. This property is required. | No | None |
LogNumberOfFiles | Integer | The number of log files to use. When a log file reaches its maximum size, another log file is started. | No | 1 |
LogMaxFileSize | Integer | Size of the log files in kilobytes. If no value is specified, the files have no maximum size. | No | None |
PingQuery | String | SQL query used to test valid connection to the database. | No | None |
QueryTimeOut | Integer | This specifies the maximum number of seconds a query can take for all SQL statements. If a value is not specified, no timeout is set on the query. If the query takes longer than the number of seconds specified, the database produces an SQL exception that is captured. The associated message is logged in the log file. | Yes | None |
ReturnDummyBO ForSP | Boolean | Used to return output parameters even when the result set is empty. In the case of RetrieveSP, a result set is returned. If the result set is empty, no business objects are created, and the output parameters returned by the procedure call cannot be retrieved. If this property value is true, a dummy business object with values from output and input/output parameters populated in the corresponding attributes is returned. | No | false |
TraceFileName | String | The full path to the trace file. This property is required. | No | None |
TraceNumberOfFiles | Integer | The number of trace files to use. When a trace file reaches its maximum size, another trace file is started. | No | 1 |
TraceFileSizeMax | Integer | Size of the trace files in kilobytes. If no value is specified, the files have no maximum size. | No | None |
The following table describes Resource adapter properties that need to be configured only when bidirectional text transformation has been activated.
Bidirectional resource adapter properties for the Adapter for JDBC
Property | Type | Description |
---|---|---|
BiDiContextEIS | String | Defines bidirectional format for content data in all of the business object runtime instances. |
BiDiContextMetadata | String | Defines bidirectional format for metadata or configuration properties stored in the deployment descriptor. |
BiDiContextSkip | Boolean | Flag that controls the invocation of bidirectional support at the resource adapter level. If it equals true, the support will not be invoked. If it equals false, then the support will be invoked. |
BiDiContextSpecialFormat | String | Specifies the category of properties subject to special treatment for all of the connector properties. |
BiDiContextTurnBiDiOff | Boolean | Flag that controls the invocation of bidirectional transformation for the JDBC adapter. This parameter takes precedence over all the rest of the bidirectional parameters on all levels. In other words, if it is set to true, no bidirectional support is invoked, and no checks nor lookups are performed. If it is set to false, bidirectional support is invoked. |
Last updated: Tue 12 Dec 2006 03:32:39
(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)