Document directory
- Connection to Oracle database with myeclipse
Connection to Oracle database with myeclipse
When myeclipse Database Explorer establishes an Oracle database connection, no matter which Oracle JDBC driver package (classes12.jar, ojdbc14.jar) is used, the following error is reported.
Java. SQL. sqlexception: ORA-00604: Error occurred at recursive SQL Level 1
Java. SQL. sqlexception: ORA-12705: Invalid or unknown NLS parameter value specified
Many of the reasons for searching on the Internet are the Oracle version or the Oracle driver version, but none of them are correct. It is estimated that they are from the same author .-_-!
Below, I will give you a feasible solution (also from the network, I tried to solve this problem ):
1. Modify the region and language options in the Windows XP control panel and set "standard and format" in "region options" to "English (US )";
2. In myeclipse, click "help"> about myeclipse...> "configuration details" and set two values:
Osgi. nl = en_us
User. language = EN
In this way, you can smoothly establish an oracle connection in myeclipse Database Explorer.
Note: I did not perform any additional tests. This solution comes from the network, and I happen to be using Windows XP. Therefore, whether it is applicable to other environments is only tested by everyone, haha ~
Bytes ----------------------------------------------------------------------------------------------------
I tried again just now. The main cause of this problem is that when myeclipse is started, the language encoding is in the [myeclipse path]/Eclipse/eclipse. the Country Code is obtained from the system region settings. if the default startup parameter of myeclipse is "-duser. language = EN ", and the information loaded by myeclipse in the operating system" Chinese (China) "is" en_cn ". In this way, the above problems will occur, therefore, you only need to change the settings on both sides to the same one to solve the above problem. the preceding solution is unified to en_us.
You can also set the system region to "Chinese (China)" and modify eclipse. INI file, replace "-duser. language = EN "changed to"-duser. language = ZH ", so that the configuration details information loaded by myeclipse is unified into zh_cn, that is," osgi. NL = zh_cn ". then I conducted a test to solve the problem. |
========================================================== ======================================
I also encountered this problem. The solution is the last one. Modify eclipse. ini.
-Showsplash
Com. genuitec. myeclipse. Product
-- Launcher. xxmaxpermsize
256 m
-Vmargs
-Xms128m
-Xmx512m
-Duser. Language = ZH
-XX: permsize = 128 m
-XX: maxpermsize = 256 m
