Getting "ora-00604: error occurred at recursive sql level 1 ora-01882: timezone region not found" error, while accessing oracle from BusinessConnect Administrator.
Article ID: KB0079390
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessConnect | 7.0.0,6.4.0,6.3.0 |
Description
Getting error while accessing Oracle DB remotely from, BusinessConnect >> Manage >> Database Connection (JDBC URL:"jdbc:oracle:thin:@MachineName.mydomain.com:1521:orcl" >> Test Connection
[ JDBC URL example : jdbc:oracle:thin:@zzz..tibco.com:1521:orcl ]
Error:
+++++++++++++++++++++++++
java.lang.Exception: java.sql.SQLException: ORA-00604: error occurred at recursive S
QL level 1
ORA-01882: timezone region not found
+++++++++++++++++++++++++
Environment
Linux
Resolution
- Please Add oracle.jdbc.timezoneAsRegion=false in "admin.tra" file as given below,
++++++++++++++++++++
java.property.oracle.jdbc.timezoneasregion=false
++++++++++++++++++++
- After this, restart the hawk and administrator to reflect the changes.
- You may also try to check the version of the Oracle jdbc driver and Oracle database. For oracle 11.x Replacing it with ojdbc6.jar version 11.1.0.7.0 will solve the issue.
++++++++++++++++++++
java.property.oracle.jdbc.timezoneasregion=false
++++++++++++++++++++
- After this, restart the hawk and administrator to reflect the changes.
- You may also try to check the version of the Oracle jdbc driver and Oracle database. For oracle 11.x Replacing it with ojdbc6.jar version 11.1.0.7.0 will solve the issue.
Issue/Introduction
Getting error while accessing Oracle DB remotely from, BusinessConnect >> Manage >> Database Connection (JDBC URL:"jdbc:oracle:thin:@MachineName.mydomain.com:1521:orcl" >> Test Connection
Feedback
Yes
No
Powered by
