#3 Unable to connect to Oracle

[Anonymous]

When I try to connect to a remote Oracle database (from a Windows XP 64), I'm getting an exception:

[code]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:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:388)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:381)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:564)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:431)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
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:359)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at dbedit.ConnectionData.connect(ConnectionData.java:144)
at dbedit.actions.ConnectAction.performThreaded(ConnectAction.java:54)
at dbedit.actions.CustomAction$1.execute(CustomAction.java:64)
at dbedit.ThreadedAction.run(ThreadedAction.java:52)
at java.lang.Thread.run(Unknown Source)

DBEdit 2.2 (11/03/2010)
Windows XP 5.2 Service Pack 2 amd64
Java(TM) SE Runtime Environment 1.6.0_17-b04[/code]

I replaced the 'ojdbc6.jar' with 'ojdbc14.jar', which solved the problem for me...

[Jef Van Den Ouweland]

Thanks for submitting the issue.
Seems there's a bug in Oracle driver 11.2.0.1
Oracle states that this bug was not present in version 11.1.0.7.
I can't simulate the problem, I can connect to all my databases just fine.
Can you please try this earlier version and let me know the result?
http://download.oracle.com/otn/utilities_drivers/jdbc/111070/ojdbc6.jar

[Dennis]

Thanks for the quick reply, the given driver works perfectly for me...

[Jef Van Den Ouweland]

Fixed in version 2.2.1 by downgrading the Oracle driver which contained the bug.