Oracle SQL Developer and Oracle 9i version

Question

I'm using Oracle SQL Developer version:

When i try execute a SELECT in a Oracle 9i database i got the following error:

I have PL/SQL DEVELOPER installed in my machine and i can SELECT this same table normally in same database (Oracle 9i) but with Oracle SQL Developer i got the error.

SOLUTION I downloaded the driver ojdbc6.jar and set in Advanced Tool Oracle SQL Developer. Everything works fine.

Um... no, the error does not appear when you "try to connect". What you got is a normal Oracle error message, you wouldn't get that if you weren't able to connect in the first place. Just guessing, but I assume you get that error AFTER you connect, when you try to run a SELECT statement or something similar. If you work in information technology you should know you must be precise, especially when you ask for help. The issue is probably caused by a Java driver incompatibility with your very old Oracle version. See community.oracle.com/thread/3638852 for possible solution. — mathguy
Exactly, this error occurs in SELECT not in CONNECT, i already edited my post. — Ronaldo Lanhellas
I have a Instant Client 11.2 and tried: Tools > Preferences > Database > Advanced to point to an 11.2.0.3 Oracle client (either full or instant). But i got the same error. — Ronaldo Lanhellas
I don't know much more than I already said (never had to work with Oracle 9). Lucky for you, Jeffy Smith, the program manager for SQL Developer at Oracle, is a contributor to Stack Overflow and he often jumps in to help on SQL Developer questions. Give him a few hours to find your post and respond to it! You did very well to tag your question properly with the oracle-sqldeveloper tag. Good luck! — mathguy

Ronaldo Lanhellas Ronaldo Lanhellas · Accepted Answer · 2017-08-02T20:34:11

SOLUTION

I downloaded the driver ojdbc6.jar and set in Oracle SQL Developer. Everything works fine.

Oracle SQL Developer and Oracle 9i version

1 Answers