 |
|
|
 |
|
 |
|
| Author |
Message |
|
|
Post subject: [DB] Problems accessing Oracle database
 Posted: Sep 27, 2006 - 05:46 PM
|
|
Moderator
Joined: Jan 06, 2004
Posts: 23347
|
|
From time to time we have users report problems when dealing with Oracle databases either with using the DB Explorer, reverse engineering or some other function. The issue almost always stems from the fact that they are using the old classes12.zip driver and not the newer ojdbc14.jar driver (JDBC for java 1.4/5.0). The newer driver is much more robust and will work with Oracle DB versioned 8.1.7 or greater and can be downloaded from here.
Additionally there is a known problem when using the Oracle 9 or 10 JDBC driver in an international environment that will result in a stack trace like:
| Code: |
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified
...
|
The fix is to upgrade your JDBC driver to the latest version (>= 10.2.0.2) available here. |
|
|
| |
|
|
|
 |
|
|
| |
|
|
 |
|
 |
|
|
|
|
Search
Register
Log in to check your private messages
