Tuesday, August 18, 2009

Setup MySQL Development in Eclipse

Using MySQL and Java? Check out an easier way: Yank

Setting up Eclipse as a MySQL development environment using the Database Development perspective is quite easy. Here you will find a step-by-step guide showing how to set up Eclipse for MySQL development. The tutorial shows how to get the right version of Eclipse, how to setup a MySQL database, how to get and use the Connector/J database driver, how to connect to a database within Eclipse, and how to create a table containing some sample data.

Step 1: Download and Install the Eclipse IDE for Java EE Developers.



Step 2: Download the Connector/J MySQL Database Driver.


Step 3: Download, Install, and start up MySQL. If you're developing on a Mac, see: Install MySQL on Mac OS X.

Step 4: Open up Eclipse and switch to the "Database Development" perspective (Window --> Open Perspective --> Other... --> Database Development perspective).




Step 5: Connect to your MySQL database.

In the "Data Source Explorer" view, right click on "Database Connections" and select "New...".



On the first page of the "New Connection Profile" Wizard, select the "MySQL" connection profile type and hit "Next >".

Click the circle with a plus sign next to the "Drivers" drop-down box.

On the "Name/Type" tab, select the MySQL JDBC Driver version 5.1 (or whatever version you downloaded). Just ignore the error in the wizard for now.

On the "Jar List" tab, add the driver .jar from the package that you downloaded and remove the default .jar that was added to the list. The error message in the wizard should now disappear. Click "OK".

On the second page of the "New Connection Profile" Wizard, edit the connection properties. In the "Database" and "URL" fields, change the word "database" to the actual name of the database you want to connect to. Change the URL, User name and Password appropriate to your circumstance. By default the MySQL database setup creates a root user with a blank password. Test the connection and hit "Finish".


Step 6: Create a table.

In the main Eclipse menu, select File --> New --> SQL File.



In the "New SQL File" wizard, select the folder where the SQL file should be stored. Create a new project if you don't have one yet. Give the file a name and hit "Finish".

In the SQL Editor view, write an SQL statement to add a table to the selected database. Highlight the text to be executed, right click, and choose "Execute Selected Text".


Step 7: Add data to the table.

In the "Data Source Explorer" view, dig down into the directory structure until you find your table in the "Tables" folder. Right click on it and choose Data --> Edit.



In the table editing view that appeared, add your data. Save to commit your changes.



Piece of cake!!
at

42 comments:

  1. AnonymousAugust 29, 2009 at 5:23 PM

    Hi. Excellent tutorial, however I have a problem. I can not see the Execution Plans in Eclipse while running MySQL queries. Do you know how to do it?

    ReplyDelete
  2. Tim MolterAugust 29, 2009 at 9:01 PM

    ElJuanfer, sorry, I haven't figured that out yet!

    ReplyDelete
  3. baaharDecember 5, 2009 at 11:44 AM

    Thanks a lot for this tutorial. It helped to connect with Eclipse to my database so easily. As a Netbeans user, I often find Eclipse complicated.

    ReplyDelete
  4. UnknownFebruary 6, 2010 at 11:12 PM

    Hi there!
    I followed your guide, but when I hit test connection I get "Ping failed"? What do u think I have done wrong, because I can connect to MySQL through the terminal.

    //Robert

    ReplyDelete
  5. Tim MolterFebruary 7, 2010 at 4:47 PM

    Hi Robert, Everything in the New Connection Profile wizard must be entered without mistakes. It's most likely that something in there is not correct. The first thing you could verify is that you have defined the host and port correctly. Perhaps whoever set up the DB set the port to something non-standard. If you are able to access the DB via the terminal, I guess you have the username and password and DB name correct. After you double check all that, and there are still problems, it could be a firewall issue. That's all I can think of!

    ReplyDelete
  6. adminMay 8, 2010 at 7:07 AM

    Hi, this is very good and simple explanation for database connection in eclipse.

    ReplyDelete
  7. robezyJuly 13, 2010 at 9:35 AM

    Hello,

    I have a trouble with datatools? Could you help? Whenever I try to execute a group of statements together, I get error saying there is a syntax error. But if I execute statements one by one there is no problem? Any Idea what is wrong? I tried all options, Execute selected statement, execute all etc. But all gives same error.

    Thanks,
    Robert

    ReplyDelete
  8. Tim MolterJuly 13, 2010 at 7:25 PM

    Hi Robert, I'm not sure, but make sure you have a semicolon (;) after each statement if you don't. Otherwise I don't know what to say. Good luck!

    ReplyDelete
  9. WendyAugust 11, 2010 at 11:57 PM

    Hi,

    Do I need to place the connector/j in a certain place? Because right now Eclipse cannot see MySQL in the connection profile wizard.

    Thanks!

    ReplyDelete
  10. WendyAugust 12, 2010 at 12:39 AM

    To clarify, in my "New Connection Profile" wizard, I only have 5 options (Derby Embedded Database, Generic JDBC Connection, HSQLDB Connection Profile, PostgreSQL JDBC Connection, and Sybases ASA) , none of which are MySQL. Could you help?

    ReplyDelete
  11. Tim MolterAugust 12, 2010 at 9:03 PM

    Wendy, that's strange. I've never ran into that problem, but it seems to be a problem with your Eclipse installation. No, you don't have to put the Connector/J in a certain place... I hope you can figure it out!

    ReplyDelete
  12. AnonymousSeptember 26, 2010 at 12:58 AM

    This was a fantastic tutorial...I wish I could have found it earlier!

    ReplyDelete
  13. MrHydeOctober 30, 2010 at 3:33 AM

    One example of Development in Postgres??

    ReplyDelete
  14. Tim MolterOctober 31, 2010 at 9:29 AM

    MrHyde, sorry no time...

    ReplyDelete
  15. PipistrelloNovember 14, 2010 at 9:12 PM

    Hi Robert,
    Nice tutorial, but i get an exception:
    Communications link failure, unable to connect to "database name"
    Do you know what it could depend from?

    ReplyDelete
  16. Tim MolterNovember 14, 2010 at 10:39 PM

    Pipistrello, no, sorry, I haven't seen that issue before. Good luck!

    ReplyDelete
  17. BhupeshJuly 1, 2011 at 3:17 PM

    Thanks a lot.dear..it was a great tutorial...

    ReplyDelete
  18. UnknownJuly 24, 2011 at 11:01 AM

    hi there such a great tutorial really can't stop appreciating you. But i cannot connect to the database it says ping failed whenever i try to connect. Is this a driver problem i am using java connector 5.1.17 driver. Please help me.

    Thanks

    ReplyDelete
  19. Tim MolterJuly 24, 2011 at 6:04 PM

    Nani, I doubt it's a driver problem. It sounds like either your MySQL server is not running or the port number is set to something other than 3306.

    ReplyDelete
  20. GeekMetalGigAugust 17, 2011 at 2:33 AM

    @NANI: Actually what you've got problem i have also faced that same problem. actually u must do by these following steps:
    1. first start the mysql server.
    2. then type "show databases;"
    3. then type "use ";
    4. now in eclipse in database field change the name as your database name.
    5. and also change the Url as "jdbc:mysql://localhost:3306/"


    Thank You,

    ReplyDelete
  21. GabiSeptember 2, 2011 at 9:05 PM

    Thank you very much! This tutorial was a real lifesaver for me in connecting to MySQL database using Eclipse.

    ReplyDelete
  22. cknoettgSeptember 5, 2011 at 7:21 AM

    Thank you for the tutorial. To confirm what GeekMetalGig said, if you right click the new profile that you have created for MySQL in Eclipse, and select Properties, you have to change:

    1. Database (field) to the Name that MySQL assigned to you when you first installed MySQL - if you can't remember it, fire up the MySQL WorkBench and it will show up in the lower left-hand corner of the screen once you have established a connection.

    2. URL (field) - erase "database" from the end of the URL listed in this tutorial.

    Of course, you also want to make sure that MySQL was set up on Port 3306 and your password is correct.

    ReplyDelete
  23. AnonymousSeptember 19, 2011 at 5:16 AM

    am very new to java. MY eclipse download which is does not have the "database development " perspective. By following instruction, t get to the dead end where there are options like:cvc repository, debug, java(default),java browsing, java type hierchy,planning, resources,team sync., and XML. thanks alot.
    DEV,

    ReplyDelete
  24. Tim MolterSeptember 19, 2011 at 10:08 AM

    Anonymous, what Eclipse package did you download and install? It could be that yours simply doesn't have that perspective bundled by default.

    ReplyDelete
  25. AnonymousSeptember 19, 2011 at 9:15 PM

    Thank you. needed the another version . Was using the classic 3.7 but needed the " Eclipse IDE for .Java EE Developers" . thank you

    ReplyDelete
  26. Christopher MarshallSeptember 23, 2011 at 2:54 PM

    Hi All,

    I've seen a number of people on here discussing the "ping failed" problem. I encountered the same problem and here are two things you can check. They solved it for me:

    ---

    1) Get the Jar and not a zip

    When I downloaded Connector/J I got the file mysql-connector-java-5.1.17.zip. Because the button to add the driver says "Add Jar/Zip" I assumed that this was the file it needed.

    However, if you unzip it you will find a file mysql-connector-java-5.1.17-bin.jar; this is the one you actually need.

    2) The default connection string seems wrong.

    Somewhere along the way my connection string became: "/jdbc:mysql:/192.168.56.101:3306/db" it actually should be "jdbc:mysql://192.168.56.101:3306/db" (note the extra '/'). I'm not sure if this came from the default or if I inadvertently deleted it.

    ---

    Once I'd fixed these I got a ping success.

    ReplyDelete
  27. FrankOctober 14, 2011 at 5:31 AM

    Excellent tutorial... things went well until Step 5... I also have the dreaded 'ping failed' problem. :( But for me, it sits there for several minutes before giving me the message.

    Can someone clarify (screenshot?) please... what exactly are the Database and URL values? Does the URL have your database name on the end or not?

    Thanks.

    ReplyDelete
  28. Tim MolterOctober 14, 2011 at 10:58 AM

    Frank (and others having the Ping failure problem),

    There seems to be a lot of people having the Ping failure problem so I thought I'd go through the tutorial myself and see if I ran into the problem too. I recently installed Eclipse Indigo so I was starting from a clean slate. (A while ago I started using Sequel Pro for database work and haven't touched a SQL table via Eclipse in a long time. I highly recommend Sequel Pro, BTW. It's free.)

    What I found is that the tutorial as I have it here is still correct. The database URL is correct. I was able to go through it in a few minutes. However I did get the Ping failure error at first as well! My conclusion is that it's a bug in Eclipse's database connection wizard. After I got the ping failure, I copied and pasted my DB's password into the password field again, and got a Ping success. I tried it again from the beginning and that was the trick again on the second try. Seems like a weird bug to me.

    I hope that helps although it's a pretty inconclusive result....

    ReplyDelete
  29. FrankOctober 17, 2011 at 12:16 AM

    Thanks Tim... that did help.

    After your comment, I gave up on the Database Connection thing altogether, and just imported my code (I'm moving from NetBeans to Eclipse) and it worked (once I'd figured out how to include the driver .jar in my project. :)

    ReplyDelete
  30. Preeti koulgikarNovember 6, 2011 at 5:43 PM

    very helpful...thanks Tim

    ReplyDelete
  31. cjrFebruary 14, 2012 at 11:27 PM

    Just what I was looking for. Thanks!

    ReplyDelete
  32. PrashanthMarch 18, 2012 at 2:33 AM

    Thanks a lot Tim . This was of great help.

    ReplyDelete
  33. AnonymousMarch 23, 2012 at 12:40 PM

    thanks for the tutorial and would like to thank @GeekMetalGig for his comments on how to solve 'ping failed'

    ReplyDelete
  34. achuApril 22, 2012 at 2:18 PM

    thanks.but "ping failed' error is showing.could u pls help me....

    ReplyDelete
  35. KallyMay 1, 2012 at 11:42 PM

    I got the Ping failed too. So, I unzipped the package and imported the actual JAR file instead of zip/tar and BAM it works!!!! You might need to manually remove the zip file you included before adding the Jar file.

    ReplyDelete
  36. AnonymousMay 8, 2012 at 7:42 AM

    Excellent! It was very hard thing just before I read this! Thank you for sharing...

    ReplyDelete
  37. SupreetMay 17, 2012 at 3:28 AM

    Awesome,,,,Simple and effective...Thanks a tonne...

    ReplyDelete
  38. AnonymousMay 17, 2012 at 3:29 AM

    Awesome ...great help..thanks a lot....

    ReplyDelete
  39. vishalAugust 16, 2012 at 5:50 PM

    hi thanx a lot for ur help,but when iam creating a table it is showing no database selected,even though my details are exactly the same as urs.

    ReplyDelete
  40. AnonymousMay 2, 2013 at 1:09 PM

    Mr Varrier said
    Its very useful.Thank you..!!

    ReplyDelete
  41. AnonymousAugust 2, 2013 at 8:31 PM

    Some additional clarity for the ping failed issue: http://dev.mysql.com/downloads/connector/j/ only has an msi file, not a .jar file to download. Make sure you download the msi, then double click it to install. You should be able to find the jar file within the program files somewhere.

    Thanks for the tutorial! Good stuff. :)

    ReplyDelete
  42. UnknownNovember 22, 2014 at 10:21 PM

    Hello Master :) thanks a lot for this tutorial. it helped me a lot to connect the eclipse to the database..

    ReplyDelete