MyEclipse+Hibernate 4--Connect to Oracle Database

The connection with Oracle Database has the same step when you connect with MySQL database. The difference lies on the selection of Driver JARs.

In DB Browse, click new icon to create a new connection.

Click Configure database driver:

Add new drivers:

Please download Oracle JDBC Drivers from Oracle Homepage.
Here is the driver for Oracle 10g:
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc101020.html

If you are using Orcale 9i, please search for the corresponding driver.   And if you have installed Oracle Client in your system, the driver is the directory:
  your disk:\Program Files\oracle\ora92\jdbc\lib\classes12.jar

And set driver temlate as Oracle Thin Driver like this and select the classes12.jar as Driver JARs.

Continue to set the username and password and host address.

Now you can connect the Oracle database.


Blog