Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge about how to solve the problem of connecting Oracle 10g in MyEclipse 6.0. in the operation of practical cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Problem with MyEclipse 6.0connecting Oracle 10g ORA-00604,ORA-12705

MyEclipse Database Explorer always prompts when establishing an Oracle10g database connection

Java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1

ORA-12705: invalid or unknown NLS parameter value specified

The preliminary analysis of the problem is the conflict between MyEclipse 6.0language and Oracle 10g.

Further analysis, because Oracle can be logged in normally, so the problem appears on the myeclipse side.

Solution 1: the estimated version of MyEclipse found on the Internet is 5.0. the solution

1. Modify the regional and language options in the windows XP control panel to customize the Standard and format in the Regional options to English (USA)

two。 In MyEclipse, help menu > About MyEclipse... > Click "Configuration Details" to set two values:

Osgi.nl=en_US

User.language=en

In this way, you can successfully establish an oracle connection in MyEclipse Database Explorer.

This method is not suitable in MyEclipse6.0.

The solution for MyEclipse 6.0to connect to Oracle:

Modify the eclipse.ini file to change "- Duser.language=en" to "- Duser.language=zh". Problem solved.

Analysis: the main reason is that when MyEclipse starts up, the language code is loaded in the [MyEclipse path]\ eclipse\ eclipse.ini file.

The country code is obtained from the regional setting of the system. If the default startup parameter of MyEclipse is "- Duser.language=en" and the operating system is set to "Chinese (China)", the message after loading MyEclipse is "en_CN", so the above problems will occur, so as long as the settings on both sides are changed to the same, you can solve the above problems.

You can also set the locale of the system to "Chinese (China)", modify the eclipse.ini file, and change "- Duser.language=en" to "- Duser.language=zh", so that the Configuration Details information loaded by MyEclipse will be unified to zh_CN, that is, "osgi.nl=zh_CN".

If it is a problem with MyEclipse6.0 connecting to Oracle 9i, the solution can be as follows

The database server character set select * from nls_database_parameters, which comes from props$, is the character set that represents the database.

The client character set environment select * from nls_instance_parameter, which comes from v$parameter.

A setting that represents the character set of the client, which may be a parameter file, an environment variable, or a registry

The character set of the client needs to be the same as that of the server in order to display the non-Ascii characters of the database correctly. If multiple settings exist, alter session > environment variables > registry > parameter file

The character set is required to be consistent, but the language setting can be different, and the language setting is recommended in English. If the character set is zhs16gbk, nls_lang can be American_America.zhs16gbk.

First of all, check what the current database character set is, and choose the same configuration database.

This is the end of the content of "how to solve the problem of connecting Oracle 10g in MyEclipse 6.0". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.