> generally, if you see this problem, your driver is loaded > correctly; however, it is unable to connect to your mysql > server. i would test this by trying to telnet to port 3306 > on localhost and see if you get a connection. if you don't, > you need to make sure your mysql is allowing connections over > tcp/ip which, if i'm not mistaken, debian has turned off by > default. look in the /etc/my.cnf or maybe /etc/mysql/my.cnf > or some such for a skip-networking flag and comment it out if > necessary. restart mysql, try the telnet again. if it > works, restart tomcat and see if your app works. > Very good! You're the 'winner' with the right answer! I was thinking my mysqld setup was ok, since it worked flawlessly with PHP. I guess PHP and MySQL have some sort of secret 'marriage', and don't connect over TCP/IP?
[off-topic] Is that also the reason that php:mysql seems about twice as fast in executing queries in comparison to jdbc:mysql? I tested this on my Windows machine. [/off-topic] However, now I get the following exception: SQLException: Invalid authorization specification: Access denied for user: 'root@barrie' (Using password: YES) My guess is that I have to config mysqld in a way that it accepts this user (of which I'm pretty sure it has the correct login and password) from 'barrie' instead of 'localhost' (barrie and localhost essentially are the same Debian box). But that's not a question to ask to this list... Thanks Hoang! (and the rest of you who didn't give the right answer;). I tried your solutions, and at least I got rid of the parse error that also was in my catalina.out but that had a different cause). JW -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
