Adding data source for jidea 11.0.2

Question

i'm trying to connect to a oracle 10g database from inside jidea,i'm using ojdbc6-11.2.0.1.0.jar as the jdbc driver. attached is the error message i'm getting when i'm trying to connect! can any one help me to solve this issue??

Connection to oracle - albi1dv1 failed
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)

Regards, Rangana

This post might help you http://stackoverflow.com/q/1629327/778687 — tusar, Mar 27 '12 at 07:08

score 0 · Answer 1 · answered Nov 13 '12 at 14:36

0

in eclipse go run - > run configuration
in there go to JRE tab in right side panels
in VM Arguments section paste this

-Duser.timezone=GMT
then Apply - > Run

answered Nov 13 '12 at 14:36

Priyan at Dialog

309
1
6
16

score 0 · Answer 2 · answered Mar 27 '12 at 07:34

0

i have used the jdbc driver named ojdbc14_noneXe.jar, it solved my problem. :)

FYI - i'm connecting to a remote oracle development database, not an local installation on my mechine!

answered Mar 27 '12 at 07:34

Rangana Sampath

1,447
3
32
57

score 0 · Answer 3 · answered Mar 27 '12 at 15:05

0

You can set the timezone to IDEA. This will prevent this error. Add the next line to file idea.vmoptions :

-Duser.timezone=your_database_timezone

Here's some explanation on how to get your database timezone

answered Mar 27 '12 at 15:05

Bit-Man

516
4
17

Adding data source for jidea 11.0.2

3 Answers3