Hi All,
Hopefully this is the right place to post this question.
I'm having difficulty getting my webapp connecting to the mysql server running locally.
If I write a simple
Java application and do some sql through
JDBC it works fine; connecting to, querying and receiving results from the database.
As soon as I try to do the same in a webapp thats deployed in
tomcat (locally) I get the following error,
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Why is this happening? I know all the connection parameters are correct. As far as I'm aware there's no firewall blocking or anything going on.
I'm using eclipse on Vista x64 with tomcat 6.0.18 with mysql 5.0.67 x64(if that helps).
I vaguely remember setting this all up on an xp box and it just working, so I'm guessing this might be a vista thing.
Any help would be appreciated, I seem to have hit a dead end on this one.
Regards,
Bobby