OK,
   After putting the latest driver (mysql-connector-java-3.1.12-bin.jar) in the java/extensions directory, I started getting an Incorrect Driver found error (or something like that).  Then, as the root MySQL user I added a new MySQL user with root privileges to the mysql database with something like this:

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Then as my newly added MySQL user I created a database with something like this:

mysql> CREATE DATABASE menagerie;

 After doing this and then specifying the new user/password and the new database in the EOModeler wizard, IT WORKED.

The thing that really threw me was the error about the wrong driver when the real problem was that I hadn't created the database yet that I was trying to connect to.  Yes, I knew I would have to create the database eventually, but I figured I wasn't even getting that far from the nature of the error message I was getting.  Man, this kind of stuff can just eat up your time.

THANKS again for all your help,
Jeff


On Mar 24, 2006, at 3:12 PM, netBrackets wrote:

Thanks to all for all the great replies.  I really have no problem learning mySQL and the command line interface.  Once I can get started I can pick things up (or remember them from before) pretty quick.  It's all the startup stuff (configuration, installation, connections, getting the right versions etc.) that usually kills me and takes forever.  I'll try some of the things you suggested and let you know how it goes.

Jeff

On Mar 24, 2006, at 2:01 PM, Kieran Kelleher wrote:

Jeff,

An open source, simple to use, Universal Binary (great on the new MacBook Pro!) is

Watch out though, changes to data AND table configuration are saved automatically.... so make sure you have a steady mouse finger with no accidental clicks!

Still, I really, really recommend you get used to mysql on the command line for at least the administration stuff like create database, create table, alter table, mysqldump, etc. .... it's not difficult at all ... just a case of getting used to it ... and then you can ssh from home or anywhere in the world into the database server to make changes or fix some problems.

Regards, Kieran


On Mar 24, 2006, at 12:14 PM, David Holt wrote:

Jeff,

The driver is now included by default with newer installations of WebObjects. Some of the installation instructions you may be reading are for older setups. Don't put anything in the driver or plugin fields of the EOModeler connection dialog box and it should work fine.

You appear to be using an outdated JDBC driver. Check out this page for the latest binary: <http://dev.mysql.com/downloads/connector/j/3.1.html> You are installing in the correct place.

I am using Navicat <http://www.navicat.com/download.html> to manage MySQL and the interface is pretty decent. You can download a free 30 day trial. Another nice tool is phpMyAdmin which is browser based, but it involves getting PHP going and then changing configuration files so that you can use it properly. To just get started, I would go with Navicat. There are also some new GUI admin tools from MySQL that look promising but I haven't looked at them since before Christmas.

I went through the same frustrations as you with MySQL until suddenly it just worked and I haven't looked back. Check out the link to Kieran's weblog that Fabrice sent. Kieran has really great step by step information for a lot of these "getting started" problems. 

David


On 23 Mar 2006, at 8:01 PM, netBrackets wrote:

JDBC connection failed for driver :'org.gjt.mm.mysql.Driver'

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to