There is a minor problem when creating a JDBC Adapter Service if the Oracle user used in the adapter properties owns no objects (i.e. no tables or views). Create adapter fails with:
com.webMethods.developer.adapter.metadata.AdapterMetadataException: com.wm.app.b2b.server.ServiceException: [ART.114.243] Adapter Runtime (Metadata): Failed to run resourceDomainLookupValues service. Details provided in error log.
[ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource Scott:Adapters.
Pool state error in Scott:Adapters. Cannot process resquest.
on select.allDistinct [Ljava.lang.String;@ab23aa
java.lang.Exception: Adapter values are not available.
The work around is to create a table (it can be empty) belonging to Scott so that the select.allDistinct returns at least one row.
My environment is:
Create Adapter Service in Developer Version 6.5 (394)
on JDBC Adapter Version 6.5 with
JDBC_6-5_Fix3
JDBC_6-5_Fix4
JDBC_6-5_Fix8
WmJDBCAdapter6_5_debug_fix9_new
My connection properties are:
Transaction Type NO_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName 123.321.123.321
user Scott
password ******
databaseName Test
portNumber 1521
networkProtocol tcp
Other Properties driverType=thin
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10