Connecting to MySQL in JDeveloper

1) Download MySQL Connector/J 3.0.11
2) Select Tools -> Default Project Properties in JDeveloper



3) Select Libraries in the tree view. Click Add Library in the right plane.


4) Click New.. 5) Library Name: MySql
Location: User
Click Add Entry..

The Select Path Entry dialog is displayed.

6) Click OK


7)Click OK
8)Select the Connections tab and right-click on the Database node to select New Database Connection.
9) Click Next

10) Connection Name: MySql
Connection Type: Third Party JDBC Driver

Click Next.

11) In the Authentication window specify Username as root (Password is not required to be specified for a root user by default), and click on Next.
12) Click New..

In the Driver Class field enter com.mysql.jdbc.Driver.

Click Browse..In the Library, select the MySql library that you defined earlier.
Click OK
Click OK

13) Enter the URL: jdbc:mysql://localhost/test?
Click Next

14) Click Test Connection