ORA-01882 error when connecting to Oracle from JBoss EAP

Solution Verified - Updated -

Issue

We are receiving errors when connecting to Oracle via JDBC.  The root caused-by is as follows:

Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region  not found
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
     at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:573)
     at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
     at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:366)
     at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:752)
     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:366)
     at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
     at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
     at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
     at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
     at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:207)
     ... 80 more

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 5
    • 6
    • 7
  • Oracle database

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In