![]() ![]() I hope that helps although it's a pretty inconclusive result.This example should be considered a proof of concept only. I tried it again from the beginning and that was the trick again on the second try. After I got the ping failure, I copied and pasted my DB's password into the password field again, and got a Ping success. 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. I was able to go through it in a few minutes. What I found is that the tutorial as I have it here is still correct. (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 recently installed Eclipse Indigo so I was starting from a clean slate. 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. Save to commit your changes.įrank (and others having the Ping failure problem), In the table editing view that appeared, add your data. Right click on it and choose Data -> Edit. In the "Data Source Explorer" view, dig down into the directory structure until you find your table in the "Tables" folder. Highlight the text to be executed, right click, and choose "Execute Selected Text". In the SQL Editor view, write an SQL statement to add a table to the selected database. Create a new project if you don't have one yet. In the "New SQL File" wizard, select the folder where the SQL file should be stored. ![]() In the main Eclipse menu, select File -> New -> SQL File. By default the MySQL database setup creates a root user with a blank password. Change the URL, User name and Password appropriate to your circumstance. In the "Database" and "URL" fields, change the word "database" to the actual name of the database you want to connect to. On the second page of the "New Connection Profile" Wizard, edit the connection properties. The error message in the wizard should now disappear. jar from the package that you downloaded and remove the default. Just ignore the error in the wizard for now. On the "Name/Type" tab, select the MySQL JDBC Driver version 5.1 (or whatever version you downloaded). On the first page of the "New Connection Profile" Wizard, select the "MySQL" connection profile type and hit "Next >".Ĭlick the circle with a plus sign next to the "Drivers" drop-down box. In the "Data Source Explorer" view, right click on "Database Connections" and select "New.". Step 4: Open up Eclipse and switch to the "Database Development" perspective (Window -> Open Perspective -> Other. If you're developing on a Mac, see: Install MySQL on Mac OS X. Step 3: Download, Install, and start up MySQL. Step 2: Download the Connector/J MySQL Database Driver. Step 1: Download and Install the Eclipse IDE for Java EE Developers. 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. Here you will find a step-by-step guide showing how to set up Eclipse for MySQL development. Setting up Eclipse as a MySQL development environment using the Database Development perspective is quite easy. Using MySQL and Java? Check out an easier way: Yank ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |