More problems with connecting to MySQL

[keegank]

Sorry for posting again.

I am trying to get my tomcat to talk to MySQL. I have downloaded the connector and from the documentation it seems I need to copy the file

mysql-connector-java-3.0.8-stable-bin

somewhere. But I am not sure where. Can you tell me where I need to put this file to be able to connect to the DB and also whether tere is anything else I need to do.

Sorry for being a pain but I am panicking massively.

Thanks

Andy

 

[libaax]

where you want to put it depends on who you you want to have access to it. If you put the jar file in {tomcat directory}\common\lib it will be
available to all your web apps. Theres no need to play around with your
CLASSPATH variable. otherwise put it in web-inf\lib

 

[libaax]

BTW: add the extension .jar

 

[keegank]

OK thanks. One more thing - if I have the .jar file in the /common/lib directory and my app still cannot connect to the db then are you saying it must be to do with my app and not the connector?

Andy

 

[libaax]

That's my guess...cause normally all apps should be able to access it there....check ur path settings though...
libaax