MySQL JDBC driver in Eclipse Ganymede [message #233985] |
Wed, 22 July 2009 00:23 |
Emmanuel Waûters Messages: 1 Registered: July 2009 |
Junior Member |
|
|
Can anyone help me with my problem? I tried to install a driver , but it
don't go as it should. I have succesfully installed MySQL and now I trie
to install the MySQL JDBC driver in Eclipse Ganymede
In green are the links or buttons I clicked on.
In red is the text I wrote in the blank spaces.
In black the text I get : the menu, problemnotifications,....
Java EE
Data Source Explorer
I marked Database Connections and open with the right mousekey the menu
and clicked on New
Connection Profile
Create a DB2 for Linux, UNIX, and Windows connection profile.
Connection Profile Types:
MySQL
Name: ( Where I put in the next line)
BeersLocalHost
Next>'
Specify a Driver and Connection Details
Select a driver from the drop-down and provide login details for the
connection.
Drivers: MySQL JDBC Driver [+] (I clicked on this button New Driver
Definition)
Specify a Driver Template and Definition Name
Name/Type
MySQL JDBC Driver MySQL 5.1
First I get this answer:
Unable to locate JAR/zip in file system as specified by the driver
definition: mysql- connector-java-5.1.0-bin.jar.
Jar List
I remove mysql-connector-java-5.1.0.-bin.jar and loose notification
Unable to locate JAR/zip in file system as specified by the driver
definition: mysql- connector-java-5.1.0-bin.jar.
When I then want to install the driver
C:\Users\Emmanuel\Contacts\Documents\Programma's\mysql-conne ctor-java-5.1.7\mysql- connector-java-5.1.7\mysql-connector-java-5.1.7-bin.jar
I get :
A driver already exists with that name. Please provide a unique driver name
I can't push then the button ok, but just can push the button cancel.
If I trie again and this time I do the following steps:
Specify a Driver and Connection Details
Select a driver from the drop-down and provide login details for the
connection.
Drivers: MySQL JDBC Driver [+] (I clicked on this button New Driver
Definition)
Specify a Driver Template and Definition Name
Name/Type
MySQL JDBC Driver MySQL 5.1
First I get this answer:
Unable to locate JAR/zip in file system as specified by the driver
definition: mysql- connector-java-5.1.0-bin.jar.
Jar List
I let the file mysql-connector-java-5.1.0.-bin.jar as it is and add the
next file
C:\Users\Emmanuel\Contacts\Documents\Programma's\mysql-con nector-java-5.1.7\mysql- connector-java-5.1.7\mysql-connector-java-5.1.7-bin.jar
to and I get following notification :
A driver already exists with that name. Please provide a unique driver
name.
So in both cases I get as answer even if the driver is in the list -
their isn't a driver available and when I want to remove the driver
and/or add a new driver to it I get as answer the driver already exists.
Could somebody help me, I follow a course and can't get further because I
can't work by this problem with JDBC.
Or because of the problems with installing the MySQL JDBC driver , is the
only solution that remains then to remove and reinstall Eclipse? If so,
what is the best way to remove Eclipse with leaving no traces of files or
subfiles of the program anymore. So when I reinstall Eclipse, there can be
no conflict anymore when installing the MySQL JDBC driver. Thanks for
Your help.
Emmanuel
Thanks forward.
Emmanuel
|
|
|
|
Re: MySQL JDBC driver in Eclipse Ganymede [message #667550 is a reply to message #234061] |
Fri, 29 April 2011 13:46 |
No real name Messages: 1 Registered: April 2011 |
Junior Member |
|
|
Solution for Problem:
mySQL, eclipse, Database Connections
Unable to locate JAR/zip in file system as specified by the driver definition: mysql-connector-java-5.1.0-bin.jar.
In the Menu:
Window -> Preferences -> Data Management -> Driver Definition -> Add..
In "Name/Type" tab
Select "MySQL JDBC Driver" in your Version
Add something to "Driver Name" to make it unique
In "JAR List" tab:
be sure your mySQL JDBC connector is listed here. Otherwise download it and add it.
In "Properties" tab:
Connection URL : jdbc:mysql://yourHost:3306/databaseWhichExist
Database Name: databaseWhichExist
Driver Class: com.mysql.jdbc.Driver
Password: TheCorrectPassword
UserID: UserNameWhichExistInDatabase
Note: not all steps may be necessary
[Updated on: Fri, 29 April 2011 13:49] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.04437 seconds