The error:
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource EmpacTrinidadAdapter:EmpacTrinidadAdapter.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
Integration Server: 8.2.1.0
Java: default IBM 1.6 JVM
JDBC Adapter: WmJDBCAdapter_6.5_Fix28
Oracle Driver: ojbc6.jar (11.2.0.2.0)
Oracle Database: 9.2.0.1.0
The Oracle database is located in Trinidad. The webMethods server is in Canada.
This same Adapter and driver can connect successfully to local Oracle 10 and Oracle 11 databases.
#webMethods#Integration-Server-and-ESB