can't connect to db running mysql v5

Classic Servoy
1

i’m unable to get servoy to connect to a database running
under mysql version 5.

the error i get is:
“java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?”

i know the server is running, as i can query it from command
line sql.

can anyone offer any advice on this one?
thanks in advance.
rm.

servoy version: R2 2.2rc4 build 322
mysql version: 5.0.3-beta-nt
os: xp

2

Have you tried getting the latest jdbc driver from the mysql website and using it?

I seem to remember having the same error message using mysql 4.1 and getting the jdbc driver from mysql did the trick.

Jim

3

hi jim; thanks for responding.

i downloaded the current (recommended) version of
mysql-connector-java from the mysql web site today,
but i can’t for the life of me figure out how to install it.

i’ll keep searching for clues; if you know how to do this,
i’d appreciate some pointers.

thanks again.
rm.

4

RobertMeyer:
hi jim; thanks for responding.

i downloaded the current (recommended) version of
mysql-connector-java from the mysql web site today,
but i can’t for the life of me figure out how to install it.

i’ll keep searching for clues; if you know how to do this,
i’d appreciate some pointers.

thanks again.
rm.

Unzip it and put the file named ‘mysql-connector-java-x.y.z-bin.jar’ in the drivers folder of your servoy installation then when you create a DB server connection choose the driver called ‘com.mysql.jdbc.Driver’ and you’re up and running.

5

to avoid confusion with the old driver: delete the old driver mysql.jar from your drivers folder. Even if you then use the old URL’s it will still use the new driver.

6

I have today had a similar problem to Robert moving to a new server running MySQL 4.1.12.

This thread saved me hours of searching and pleading for help and goes to show you what a great resource is being built within this forum.

Thanks to all contributors - remember that your throw away remark could be the advice that saves someone’s bacon !

As an aside question - is there anywhere on the Servoy main web site that shows list of the most up to date DB drivers and if not then could there be ?

Cheers
Harry

7

I got pulled from this project for a bit to work on something
else, and haven’t had a chance to try the suggestions presented
(today might be the day!)

but i wanted to thank everyone who responded.

this forum is a marvelous place! :D

8

Harry Catharell:
As an aside question - is there anywhere on the Servoy main web site that shows list of the most up to date DB drivers and if not then could there be ?

My advice is to keep an eye on your DB maker site to stay up to date with jdbc driver development but don’t be in a hurry to update, read regularly the changelog for every new version and don’t change drivers unless you have some problem with the current one or you see a bug fix that you need, the latest driver id not always the best choice.
In Italy we use to say “Winning team is not to be changed”. ;-)

9

Harry Catharell:
As an aside question - is there anywhere on the Servoy main web site that shows list of the most up to date DB drivers and if not then could there be ?

It’s a bit tricky as it depends very much on which version of the database you are using. Particularly with databases like mysql that have loads of builds and loads of different builds of the jdbc driver it can sometimes be tricky to pick the right combination. In general the safest is to run the jdbc driver that was more or less released at the same time as your database.

10

Fair and reasonable answers and I will keep my eye on things.

Nicola, in the UK we say: ‘If it isn’t broken, don’t fix it !’

Cheers, and I am up and running having sourced the driver update.

Cheers
Harry