Thursday, April 16, 2009

Oracle JDeveloper 11g with MySQL

How To Use ADF Business Components in Oracle JDeveloper 11g with MySQL:

Configure JDeveloper to work with MySQL Connector/J

  • Download MySQL Connector/J 3.0.11 unzip it and copy the JDBC driver JAR file to a known location, such as /jdev/lib (mine is C:\bea\jdeveloper\jdev\lib)
  • From the Tools menu, select Default Project Properties.
  • In the tree view, select Libraries and Classpath.
  • In the right pane, select Add Libary. The 'Add Library' dialog will be displayed.
  • select New. The 'Create Library' dialog will be displayed.
  • Name the library MySQL JDBC.
  • Set the location to User.
  • Click on Class Path.
  • Click Add Entry. The 'Select Path Entry' dialog is displayed.

  • Navigate to the JAR file for the MySQL Connect/J JDBC driver (it should be called something like C:\bea\jdeveloper\jdev\lib\mysql-connector-java--bin.jar).
  • Click on the jar file and click Select.
  • Click OK.
  • Click OK.
  • The library will be defined, and it will be in the Selected Libraries list. You probably don't want that library to be defined in all your projects, so shuttle it over to the Available Libraries list.
  • Click OK.
Now you can use that library in any of your projects.


4 comments: