fatgasra.blogg.se - Installling eclipse on mac

#INSTALLLING ECLIPSE ON MAC INSTALL#
#INSTALLLING ECLIPSE ON MAC DRIVERS#
#INSTALLLING ECLIPSE ON MAC UPDATE#
#INSTALLLING ECLIPSE ON MAC DRIVER#
#INSTALLLING ECLIPSE ON MAC SOFTWARE#

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.

#INSTALLLING ECLIPSE ON MAC SOFTWARE#

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.įor those who might want to know exactly what versions of software I am using, here is the list: Click OK and then double click on the new connection in the Connections list. 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). This will bring you back to the 'Create New Connection Profile' window.

#INSTALLLING ECLIPSE ON MAC DRIVER#

This should automatically fill in the Driver Class Name field at the bottom with ''Īt this point, you should have a window that looks like this:Ĭlick the OK button.

Click Add and then select the mysql-connector-java-5.0.8-bin.jar file you downloaded.

In the Example URL field fill in the following: jdbc:mysql:// /.

On the 'Create New Driver' screen fill in the Name field with something like 'MySQL JDBC Driver'.

Open the 'Create New Connection Profile' window in SQL Explorer, click the New Driver button.

Download the MySQL JDBC Connector, extract and save the mysql-connector-java-5.0.8-bin.jar file some place permanent (I stored it in my /Applications/Eclipse/ directory).

Download Connector and Create MySQL JDBC Driver 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.

#INSTALLLING ECLIPSE ON MAC DRIVERS#

The fact that the Create New Connection window shows me a huge list of database drivers to choose from is very misleading!īefore we add the new driver, we need to download the MySQL JDBC Connector. I didn't see this information anywhere in the SQL Explorer documentation or on the website.

#INSTALLLING ECLIPSE ON MAC INSTALL#

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 don't know about you, but I have definitely seen more informative error messages than. But upon doing this, I received the following error: 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. This is where there is no documentation explaining what is really needed to connect to a MySQL database.

This will open the 'Create New Connection Profile' window. In the Connections tab, click the 'New Connection Profile' icon or right click anywhere inside the empty list and choose it. Once you have opened the SQL Explorer, you will need to add a new connection. You can start using it by selecting it in the Open Perspective list ( Window -> Open Perspective -> Other.). The SQL Explorer plugin should now be installed and available as a new perspective.

A new screen should open which allows you to select 'SQL Explorer'.

Uncheck everything except 'SQL Explorer' and click Finish.

You should now see 'SQL Explorer' in the list of 'Sites to include in search'.

Click 'New Remote Site', enter 'SQL Explorer' in the Name field and '' in the URL field and then click OK.

Choose the 'Search for new features to install' option and click Next.

From within Eclipse, choose 'Help -> Software Updates -> Find and Install' from the menus.

Here is how it's done: Download and Install Eclipse SQL Explorer Plugin

#INSTALLLING ECLIPSE ON MAC UPDATE#

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. 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. SQL Explorer is really nice, once you get it working.

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 😉 ). 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!).

I have a local LAMP (or in this case, MAMP) environment setup on my Mac for development purposes. 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".