JDBC Adapter Connection but Adapter Service Fails

[lamarvannoy202]

Hello,

We are having an issue retrieving information from a database using JDBC Adapter version 6.5 running on IS 7.1.1.0. We are able to successfully enable a connection from the JDBC connections page on the web UI, but when we attempt to run a simple select statement from an Adapter Service in Developer we receive the below error:

com.wm.app.b2b.server.ServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service

[ART.114.505] Error while invoking adapter service com.wm.adapter.wmjdbc.services.Select.
com.wm.adapter.wmjdbc.connection.JDBCConnection

We are able to reload values from the adapter in the adapter service, view the tables, and set everything up successfully, however when we run the service to test we get the error.

The database is located on another network and we are connecting through a VPN tunnel. We have verified the connectivity: we can ping the server on the listening port and we can perform the exact SELECT statement configured in the Adapter Service using SQL*Plus client from the server IS is running on. I have tried many different configurations, but have no luck.

Here are our connection details:

Connection Type JDBC Adapter Connection
Package Name FxJDBCConnectionManager

Connection Properties
Transaction Type NO_TRANSACTION
DataSource Class oracle.jdbc.pool.OracleDataSource
serverName <NATAddress_for_Oracle_DB_Server>
user
password
databaseName
portNumber 1526
networkProtocol
Other Properties url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=NATADDRESS)(PORT=1526))(ADDRESS=(PROTOCOL=TCP)(HOST=NATADDRESS2)(PORT=1526)) (LOAD_BALANCE=yes)(FAILOVER=on))(CONNECT_DATA=(SERVICE_NAME=DBNAME)))

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) 100000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

Any help is greatly appreciated!