myeclipse6.5连接oracle11G R2 ora
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。解决办法： ------
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