X

Shay Shmeltzer's Oracle Development Tools Tips

  • March 31, 2005

JDeveloper with MySQL - yes, it works...

Shay Shmeltzer
Director of Product Management - Oracle

Every couple of weeks we get a post on one of the many discussion forums out there asking if JDeveloper works with non-Oracle databases or application servers.

Well the answer is yes.

But people are always looking for samples of this, and to tell the truth, not all the product managers have time to install/configure and learn non-Oracle products.

So it is nice to see an article like this one showing you how to use JDeveloper with MySQL (and showing you some of the benefits of Oracle ADF in the process).

Especially since it is written by a non-Oracle person.

See I told you so - it does work.

(by the way there are more MySQL documents on the JDeveloper how-to's page).

Join the discussion

Comments ( 7 )
  • Jaime Saturday, July 25, 2009
    Thank you, my teacher told me you haven't support for mysql and that if I want to use it I should configure xml's manually
  • shay Monday, July 27, 2009
    Note that a blog entry about using MySQL with JDeveloper 11g is here:
    http://jobinesh.blogspot.com/2009/06/adf-with-mysql.html
  • guest Monday, May 30, 2011
    Hello Shay,
    I would like to connect through jdeveloper to a MySql database and read hebrew data on a table.
    this is the url we use for the connection, but the data is derived in gibrish:
    jdbc:mysql://server:port/ecc?characterSetResults=hebrew
  • Shay Tuesday, May 31, 2011
    Guest, check the encoding settings in your database and then in the JDeveloper project properties->compiler, and in your JSF page heading - you probably want them all to be UTF-8.
  • guest Monday, July 4, 2016

    I have found an easier way to connect to MySQL database. Can you please check here ?

    http://adf.palash90.in/2016/07/connecting-mysql-database-through.html


  • Elad Thursday, September 15, 2016

    Hi shay,

    When I write java class in Jdeveloper, and want to print a message in hebrew, I get "?????" instead of the real text.

    I tried to change the encoding to "hebrew", but this didn't work.

    The current value in the encoding is: cp1255.

    Thanks in advanced,

    Elad


  • Shay Shmeltzer Saturday, September 17, 2016

    Elad, check the encoding in the project properties->compiler, in your JSF and also in your Database.

    Only when all of them are set correctly you'll get what you need.

    http://dev.mysql.com/doc/refman/5.7/en/charset-database.html

    You might want to switch to work in UTF


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.