Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Web Tools Project (WTP) » MySQL JDBC driver in Eclipse Ganymede
MySQL JDBC driver in Eclipse Ganymede [message #233985] Wed, 22 July 2009 00:23 Go to next message
Emmanuel Waûters is currently offline Emmanuel WaûtersFriend
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 #234061 is a reply to message #233985] Thu, 23 July 2009 14:31 Go to previous messageGo to next message
Brian Fitzpatrick is currently offline Brian FitzpatrickFriend
Messages: 495
Registered: July 2009
Senior Member
Hi Emmanuel,

This is in Ganymede? If you go to Preferences, do you see a
"Connectivity" or "Data Management" node? Drill into that until you find
a "Driver Definitions" node. You should see a list of existing driver
definitions. Sounds like you already have one with the name you
specified. If so, you should be able to edit it and update the jar list
to point at the jar you want.

Hope that helps!
--Fitz
Re: MySQL JDBC driver in Eclipse Ganymede [message #667550 is a reply to message #234061] Fri, 29 April 2011 13:46 Go to previous message
No real name is currently offline No real nameFriend
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

Previous Topic:Web Page Editor throws up an "Undefined" error window
Next Topic:Adding grid & Rulers in Web Page Editor in eclipse
Goto Forum:
  


Current Time: Sat Dec 20 16:03:30 GMT 2014

Powered by FUDForum. Page generated in 0.03901 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software