ORA-604 and ORA-01882 With JDBC Connections to Database 22.214.171.124
Last updated on JULY 28, 2017
Applies to:JDBC - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
There are 2 databases: One is 188.8.131.52 and it is the database which has the JNDI data source to then connect to the application database which was version 184.108.40.206 and was upgraded to 220.127.116.11.
After these changes, when trying to connect with JDBC 12.2 to the 18.104.22.168 JNDI database, the connection fails with the errors:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
Connecting directly with JDBC 22.214.171.124 to the upgraded 126.96.36.199 application database succeeds.
JDBC driver was upgraded to version 188.8.131.52.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms