WebSphere Adapter for JDBC

Resource adapter properties

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.

Table 1. Resource adapter properties for the Adapter for JDBC
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.
Related reference
Managed (J2C) connection factory properties
Activation specification properties

Terms of use |

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)