JDBC Driver for Oracle 10G XE

Question

I installed Oracle 10G XE. I want to connect to it using JDBC. What driver should I use for it and where can I download it from?

Thanks.

Answer 1

On the computer on which the server is installed, the Oracle JDBC drivers are located in ORACLE_HOME/jdbc/lib . Just put ojdbc14.jar in your classpath ( ojdbc14_g.jar same as ojdbc14.jar , except that the classes were compiled with "javac -g" and contain some tracing information).

EDIT: According to Oracle Database 10g Release 2 (10.2.0.4) the JDBC drivers , ojdbc14.jar contains classes for use with JDK 1.4 and 1.5 (and I don’t understand why it does not work with JDK 6, some JDBC 4.0 functions will not be available).

Some new drivers are available in Oracle Database 11g Release 2 JDBC Drivers , but I do not see the difference between ojdbc14.jar and ojdbc15.jar (except that ojdbc15.jar requires JDK 5+): they are both JDBC 3.0 drivers , so I think that it’s just a matter of the end of life support ojbdc14.jar . If you want JDBC 4.0 support, you will need ojdbc16.jar . See the Oracle JDBC FAQ for more information.

Answer 2

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Usually you need the latest JDBC drivers, they will also work with older versions of the database. Or, to be safe, combine the JDBC version with your database.

Answer 3

According to this getting started guide, you need the Oracle Express client, which can be found here.

Answer 4

You want to select the JDBC driver that matches your version of Oracle and the JDK used. ojdbc14.jar for JDK 1.4; there are newer versions, at least for JDK 5, that I know of. I'm not sure if there is a JDBC driver for JDK 6. Use the best fit for your situation, available to Oracle.