Enabling data source access for the JDBC adapters in Software AG webMethods Integration Server
In Software AG webMethods Integration Server, a container obtains the location of the data source by an internal lookup that happens outside of the regular JNDI interfaces. Therefore, specifying alternate connections is not possible. To overcome this problem, augment the configuration with additional properties where applicable.
About this task
The process of configuring the JDBC adapter
in Software AG webMethods Integration Server has the following steps:
- Load the Rational® Integration Tester data source driver by changing the class of the data source implementation to com.greenhat.jdbc.ConnectionPoolDataSource.
- Specify the existing value in the dataSourceClass property so that it can access the underlying implementation source.
Procedure
- In webMethods Integration Server Administrator console, under the Adapters box, click JDBC Adapter. The View Connection dialog box opens.
- Disable the existing data source.
- Copy the value set in the DataSource Class field. You will use this value in Step 5 .
- Set DataSource Class to com.greenhat.jdbc.ConnectionPoolDataSource.
-
Add the following name-value pairs
to the Other Properties field:
- dataSourceClass=The value that you copied in Step 3 - for example, dataSourceClass=oracle.jdbc.pool.OracleDataSource
- liveDatabaseURL=The URL of the Rational® Integration Tester physical resource - for example, liveDatabaseURL=jdbc:oracle:thin:@localhost:1521:XE.
Note: Ensure that the field does not have any liveJNDIName property set. -
Optional: To connect to a virtual database instance, add
the following
name-value
pairs to the Other Properties field: virtualDBProperties=databaseName=gh|user=gh|password=gh. You can use any data source property supported by Oracle or Microsoft™ SQL providers.Note: Format the values asname=value
pairs separated by "|" (vertical pipe symbol). - Enable the data source.
- Verify that the configuration works as expected.