[Mork]

I can run a Java program that connects to a MySQL 5 database with no problems.

I can connect to the database, do queries, and such, using an interactive tool.

However when I try to use either of the MySQL drivers in 4.0.3’s DB Explorer, all I get is: “Error connecting to database.”

I don’t get any **useful** information at all to help me figure out what’s going on.

I’ve tried including the user name and password on the URL line as the Java program successsfully does and I’ve tried to not include the user and password on the URL line, but instead, include them on their respective user and password fields in the DB Explorer. I’ve tried not requiring password. Bascially all permutations.

Two questions:

1. Why isn’t there, by now, a better, that is, a useful error message about what might be wrong with the connection instead of the useless “idiot light” (like in a car) approach of “ERROR” help me figure out what’s wrong? I hope they resolve this in 4.1.

2. What do you suggest to fix this connection problem?

Thanks very much in advance.

— M

[Riyad Kalla]

Mork,
Please make sure you aer configuring your MySQL driver first, from Window > Preferences > MyEclipse > Database Explorer > Drivers, then when you create a connection profile in the DB Explorer, be sure to select the driver you configured already.

This is a known issue, we hate how unintuitive this is right now, it has come up a few times internally on how to stream line this.

[Mork]

Holly cow!!!

Yes, you’re right. I keep forgetting to set up the drivers.

You recall we were working on that JSP problem where drop down combos turned in to other controls (Hopefully to be fixed in 4.1), right?

Well, I suppose in re-installing MyEclipse to work on that problem, I neglected to set up the drivers for MySQL again.

I suppose you could enhance the error message quite a bit by saying in it just what you said in your extremely helpful reply to me….to make sure the drivers are configured in MyEclipse first. That has always been my problem and I ALWAYS forget to check it!

In any case, all is well and I’m back working now. <s>

THANK YOU VERY MUCH!!!!!!!!!

EXCELLENT SUPPORT!!!!!!

Best,

— M

[Riyad Kalla]

You recall we were working on that JSP problem where drop down combos turned in to other controls (Hopefully to be fixed in 4.1), right?

Yes, did you try our M1 release? That should have been fixed, I worked with the developer that fixed it.

I suppose you could enhance the error message quite a bit by saying in it just what you said in your extremely helpful reply to me….to make sure the drivers are configured in MyEclipse first. That has always been my problem and I ALWAYS forget to check it!

Yes we need to do something, this problem keeps occuring. Sorry about that.

Glad things are working now.

[Mork]

Another way to handle it is to make setting up the JDBC driver as just part of a workflow.

If the driver hasn’t been set up, we should get a message right away when selecting it from the Database Explorer with, possibly, a link to take us to the part of MyEclipse where you do set it up.

Having MyEclipse check things, as you try to set up DB connections for example, and give some simple instructions would catch most of the problems people report I would imagine.

Thanks again!!!!!!

[Scott Anderson]

Mork,

I think we’re doing exactly that sort of thing, along with fixing the error reporting, in the 4.1 milestone builds. Thanks for the suggestions.

[Author]

Posts