eclipse to mysql

mlnm · 11-14-2011, 08:31 AM

Hi guys, i am trying to connect eclipse to mysql and i googled for the connector and found that is connector jand i downloaded it and read a few tutorials about it but they didn't help , so please help me to install and configure that plugin.

corp769 · 11-15-2011, 01:20 AM

Wait, huh?? Could you explain this again?
If I think I know what you are talking about, would the following help?
http://stackoverflow.com/questions/8...ration-plugins

Cheers,

Josh

SecretCode · 11-15-2011, 03:46 AM

This is from memory, and seeing what's on my system, as I'm not using MySQL atm ...

You download the Connector/J archive (tar.gz or zip, tar probably better) file from the MySQL web site.
Unpack it somewhere on your system. I have eclipse in /opt/eclipseNNN/eclipse and I put connector/J into /opt/eclipse351/mysql-connector-java-5.1.12/.
In your eclipse project, add (in project properties - java build path) the external jar which will be something like /opt/eclipse351/mysql-connector-java-5.1.12/mysql-connector-java-5.1.12-bin.jar.
Then in your class you need code like

Code:

String url = "jdbc:mysql://localhost:3306/" + dbname;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection(url, username, password);