[rateoty]

hello,
I’m using an oracle 10 g (personal edition) on localhost. With oracle jdeveloper or oracle sqldeveloper I’m able ot connect to my schema. When I make a connection inside a class

DriverManager.registerDriver(new oracle.jdbc.OracleDriver());  
Connection conn =                 DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test", "test_dba","systest");

the connection works and I can use it.

If I try to connect in DB Browser with that same connection settings (that is:
URL:jdbc:oracle:thin:@localhost:1521:test
User name:test_dba
Password:systest

as driver I use the oracle.jdbc.driver.OracleDriver from the database installations odbc14.jar
),
I get an error:

Error while trying to login to database :
ORA-00604: error occured at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

the log entry is:

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-12-14 11:06:19.606
!MESSAGE Error while trying to login to database
!STACK 0
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:785)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Unknown Source)

If I try to connect with a wrong username hte error I get is the expected wrong username/password error.

regards Jürgen

my configuration:

Windows XP,

Myeclipse:
Version: 5.1.0 GA
Build id: 20061111-5.1.0-GA

eclipse:
Version: 3.2.1.r321_v20060921-b_XVA-INSQSyMtx
Build id: M20060921-0945

[Haris Peco]

Jürgen,

Could you try with latest jdbc 10g driver.Some Oracle’s driver have bug when you use specific locale, but it is fixed in latest driver.
I suppose that you have different language settings fro MyEclipse and jdeveloper/sqldeveloper.
You can (for testing) try start MyEclipse with English locale

Regards,

[rateoty]

hello,

sorry for being a bit confusing in my first posting.
I mentioned the jdeveloper, but the code example works fine in eclipse. So it should not be the drive which causes the problem with the connection in the db Browser, since I use the same odbc14.jar for the code example (with eclipse compiled and running) as for the db browser.

I don’t see a separate download for oracle drivers – I simply downloaded the latest version of 10g. When I’ve tried with 10gXE, I had the same problem as with the personal edition.

How do I start eclipse with an english locale?

Regards Jürgen

[Haris Peco]

Jürgen,

Could you try 10.2.0.2 jdbc driver from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html
This is README and describe your problem http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/readme_jdbc_10202.html

‘4629654 ORA-12705 at JDBC connect with mixed language/country for locale’

for starting eclipse in English locale you can do :
-add option -nl en_US
-add with -Duser.language=en -Duser.country=US in -vmargs part
or
– add in eclipse.ini

-Duser.language=en
-Duser.country=US

in seperate line.

However, new driver is correct solution for you.

Regards,

[rateoty]

hello,

thanks for your advice, using the new driver works fine.

regards Jürgen

[Author]

Posts