Menu
Mac Os X 10 Dmg Download How To Install Eclipse Dmg File On Mac Crit Buff Increase Dmg Ffxiv Alternative App To Work With Dmg Files Macos Mojave 10.14 Dmg Mac Free Download Dmg-2x.cgp Not Showing Up Disk Image Mounter Mac Dmg Commandlinetoolsosx10 10forxcode6 4 Dmg Dmg Mori Dmc 65 Monoblock.
There is a great plugin for Eclipse called SQL Explorer, which 'is a thin SQL client that allows you to query and browse any JDBC compliant database'. I have a local LAMP (or in this case, MAMP) environment setup on my Mac for development purposes. Up until now I have been using phpMyAdmin through an external web browser to view/edit the MySQL database (Eclipse's built-in web browser sucks -- I cannot even copy/paste from it!). Since I do everything else from within Eclipse, moving outside the Eclipse window just to view tables/data in the database really interrupts my work-flow (not to mention the distractions that come with using a web browser ? ).
SQL Explorer is really nice, once you get it working. I assumed it would be as simple as downloading the plugin and creating the connection to my local MySQL database -- but that didn't work. You can download and manually install the plugin, but choose to use the built-in Eclipse Install and Update functionality to download and install the plugin. Here is how it's done:
Download and Install Eclipse SQL Explorer Plugin
The SQL Explorer plugin should now be installed and available as a new perspective. You can start using it by selecting it in the Open Perspective list (
Window -> Open Perspective -> Other.. ). Once you have opened the SQL Explorer, you will need to add a new connection. Office for mac 2011 free download crack. In the Connections tab, click the 'New Connection Profile' icon or right click anywhere inside the empty list and choose it. This will open the 'Create New Connection Profile' window.
This is where there is no documentation explaining what is really needed to connect to a MySQL database. You would think it would be as simple as selecting the MySQL Driver from the list, entering your database connection information and saving the connection. But upon doing this, I received the following error:
I don't know about you, but I have definitely seen more informative error messages than
com.mysql.jdbc.Driver . After a little research, I discovered that we actually need to install the MySQL JDBC driver before using SQL Explorer to connect to a MySQL database. I didn't see this information anywhere in the SQL Explorer documentation or on the website. The fact that the Create New Connection window shows me a huge list of database drivers to choose from Adobe digital editions 1.5 download. is very misleading! Google passwords chrome extension.
How To Download And Install Eclipse On Mac Windows 10
Before we add the new driver, we need to download the MySQL JDBC Connector. You will want to copy the
mysql-connector-java-5.0.8-bin.jar file somewhere permanent, since the new driver we create will look for for this file whenever we connect to a MySQL database.
Download Connector and Create MySQL JDBC Driver
How To Download And Install Eclipse On Mac Os
At this point, you should have a window that looks like this:
Click the OK button. This will bring you back to the
'Create New Connection Profile' window. Now you should be able to select your new 'MySQL JDBC Driver' from the list of drivers, fill in the URL field with something like 'jdbc:mysql://localhost:3306/test_database ', and enter your MySQL Username and Password details (if you're using MAMP, the defaults are root/root ). Click OK and then double click on the new connection in the Connections list. Assuming your MySQL database is running and the connection details are correct, you should see the Database Structure tab populate and allow you to view the contents of your database. How to download insanity flyff on mac.
For those who might want to know exactly what versions of software I am using, here is the list:
How Do I Install Eclipse On Mac
Mac OS X 10.4.10 on a MacBook Pro
Eclipse 3.2.2 SQL Explorer plugin 3.0.0.2006 MySQL JDBC Connector 5.0.8 How To Install Eclipse
I've only started to explore the possibilities of what can be done with SQL Explorer, but I can already tell it will make my development process much smoother. I was surprised that there wasn't more readily available documentation explaining how to do what I have explained here, but hopefully someone will find this mini-tutorial useful.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |