At work I’ve been using Oracle’s SQL Developer lately to do my database work. It has been working great until this week when we started working on migrating to Oracle 10g. I installed the new 10g client on my workstation and while I could still use SQL Developer to connect to my old 9x schemas - trying to connect to 10g would result in a horrible crash.
After I dug around I found what seems to be the solution on the SQL Developer Forum.
Turns out there may be an issue with the JDBC drivers shipping with the latest SQL Developer. The ‘fix’ is to copy two .jar files from your 10g client install to the SQL Developer directories.
On my machine I copied these two files from my Oracle installation:
C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.jar
C:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14dms.jar
To SQL Developer:
C:\Program Files\sqldeveloper\jdbc\lib\ojdbc14.jar
C:\Program Files\sqldeveloper\jdbc\lib\ojdbc14dms.jar
Overwriting the existing files.
While this isn’t an official fix - it worked for me as well as others on the forum.
FWIW - SQL Developer can also connect to MSSQL, MySQL and Access and it’s free!
You May Also Enjoy Reading:
One Comment
Been using sql developer since its beta days. Great tool
One Trackback
[...] Oracle 10g and SQL DeveloperAt work I ve been using Oracle s SQL Developer lately to do my database work. It has been working great until this week when we started working on migrating to Oracle 10g. [...]