How to Configure JDeveloper to work with MySQL Connector/J

How to Configure JDeveloper to work with MySQL Connector/J

In this JDeveloper and MySQL database server tutorial, you will learn how to configure JDeveloper IDE to work with MySQL Database Server using MySQL Connector/J. By connecting JDeveloper IDE with a MySQL database server, you can MySQL database with Java and Java EE Web applications development.

The below-mentioned tools are used for this tutorial which should be installed on your computers. If you have already not installed this software, click on it to view the tutorial, on how to install this software

1- Oracle Jdeveloper IDE
2- MySQL Database Server
3- MySQL Connector/J


Please follow the below-mentioned steps to complete the installation

  • 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)
  • In Oracle JDeveloper, 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.
How to Configure JDeveloper to work with MySQL database server using Connector/J, jdeveloper tutorial, how to register MySQL database server with Oracle Jdeveloper, mysql connector/J, Database software, database administration, database tutorial

  • 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 do not 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 to connect JDeveloper Projects to connect with MySQL Database Server.

10 Comments

Please enter relevant questions and information.

  1. Hi, I went through your this post and found

    really interesting. I landed this page through

    internet search and found
    this page very good.I am a web designer and

    works in a web design

    company

    as a designer I liked the color of your blog

    also.

    Thanks,
    katrina

    ReplyDelete
  2. Its a really nice post, thanks for it and keep updating the posts.

    Web Designing course in dwarka mod

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. an amazing post .this article had given me new information.thankyou for shareing this articles to the author.
    professional-web-design-company

    ReplyDelete
  5. nice one.this articles is really helpfull .thankyou for shareing such a benificial articles.
    professional-web-design-company

    ReplyDelete
  6. Thank you for showing your thoughts by posting article. It is really nice one.
    Web design companies in Houston
    Web design company Houston

    ReplyDelete
  7. Thank you so much for sharing this vital information with us. This is fantastic.
    Custom Website Build

    ReplyDelete
  8. Thank you for providing such an insightful perspective; the written content is rigorous, which is why I read it carefully.
    On Demand Developers

    ReplyDelete
Previous Post Next Post