Unable to connect Oracle DataSource database

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:
Java: default IBM 1.6 JVM
JDBC Adapter: WmJDBCAdapter_6.5_Fix28
Oracle Driver: ojbc6.jar (
Oracle Database:

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.

A quick google search reveals the following link:

which suggests adding -Duser.timezone=somevalue.

You need to edit Integration Server’s startup script

and append that additional definition to the end of the JAVA_OPTS setting.

We have several database connecting to the Integration server as datasource from diffrent time zone… US and Trinidad. I don’t think hard code the timezone in the server.bat will help.

Unfortunatly your problem is related to Oracle (not wM suite) and the link just gives a pointer to a one possible solution. I would suggest posting your question (in a reworded manner) to some of the Oracle forums and see if anyone has a good suggestion.