myeclipse6.5连接oracle11G R2 ora-00604 ora-12705错误(转帖)

1.环境

-----------------

eclipse3.3  myeclipse6.5 oracle11G R2  jdk1.6

2。错误信息：

-----------

ORA-00604: error occurred at recursive SQL level 1

ORA-12705: Cannot access NLS data files or invalid environment specified

3。解决办法：

---------

打开D:/MyEclipse-6.5/eclipse/eclipse.ini文件;

把 -Duser.language=en 改为：-Duser.language=zh

在DB Browser中，oracle10g驱动用ojdbc14.jar--支持jdk1.4 jdk1.5

oracle11G R2 驱动用ojdbc14.jar--支持1.6

如果是jdk1.2/jdk1.3 ,使用class12.jar就可以了

4.oracle10g驱动使用的jdk环境：

---------------------

Oracle Database 10g  Release 2 (10.2.0.2) JDBC Drivers

 

JDBC Thin for All Platforms

    classes12.jar (1,594,191 bytes) - for use with JDK 1.2 and JDK 1.3

    classes12_g.jar (2,038,127 bytes) - same as classes12.jar, except that classes were

compiled with "javac -g" and contain some tracing information.

    classes12dms.jar (1,601,843 bytes) - same as classes12.jar, except that it contains

additional code`to support Oracle Dynamic Monitoring Service.

    classes12dms_g.jar (2,046,467 bytes) - same as classes12dms.jar except that classes were

compiled with "javac -g" and contain some tracing information.

    ojdbc14.jar (1,540,457 bytes) - classes for use with JDK 1.4 and 1.5

    ojdbc14_g.jar (1,932,834 bytes) - same as ojdbc14.jar, except that classes were compiled

with "javac -g" and contain some tracing information.

    ojdbc14dms.jar (1,548,006 bytes) - same as ojdbc14.jar, except that it contains

additional code`to support Oracle Dynamic Monitoring Service.

    ojdbc14dms_g.jar (1,940,478 bytes) - same as ojdbc14dms.jar, except that classes were

compiled with "javac -g" and contain some tracing information.

    orai18n.jar (1,645,109 bytes) - NLS classes for use with JDK 1.2, 1.3, 1.4, and 1.5.

This jar file replaces the old nls_charset jar/zip files.

    ons.jar (48,492 bytes) - for use by the pure Java client-side Oracle Notification

Services (ONS) deamon.

    demo.tar (604,160 bytes) or demo.zip (529,267 bytes) - contains sample JDBC programs.

5.参考文档：

-----------

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

http://caijinrong.bokee.com/5996094.html

http://read.newbooks.com.cn/info/175003.html

 

以上方法对我的系统基本无效.

我用的是ubuntu 8.04 ,java版本1.6.0-06 oracle 10.2.0.1 数据库字符集 gbk , eclipse 3.3.2 myeclipse6.5 GA

最终,将ubuntu切换到英文下,问题解决 . 但这不是最终解决方法. 还在寻找中.

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.

在eclipse.ini里加入这两行后,解决!(这样要通过运行eclipse才生效)

另一种解决办法是像上面说的,修改myeclipse.sh 加上 -Duser.language=en  -Duser.country=US