jdbc class not found exception with tomcat in linux

[vamp4l]

Hey, I'm getting the

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

exception when i try to execute database queries
ive read a bit about it, but i cant figure out how to set my tomcat up
to work properly
i have the .jar file that is supposedly needed, ive tried to put it in
a bunch of different folders with no luck
any suggestions on how to set up the classpath and where the .jar file
needs to go?
thanks

 

[VisionSet]

any suggestions on how to set up the classpath and where the .jar file
needs to go?

\tomcat\common\lib\mysql-connector-java-3.1.10-bin.jar

 

[IchBin]

Hey, I'm getting the

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

exception when i try to execute database queries
ive read a bit about it, but i cant figure out how to set my tomcat up
to work properly
i have the .jar file that is supposedly needed, ive tried to put it in
a bunch of different folders with no luck
any suggestions on how to set up the classpath and where the .jar file
needs to go?
thanks

As far as I now it goes into

TomcatBase\common\lib



--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

 

[vamp4l]

hmm...i dont have a common folder but i put it in the lib folder in my
WEB-INF/lib dir
i also tried making a common directory and putting it there
i also tried setting the classpath in the .bashrc file
any idea why this isnt working? or any other suggestions?

export
CLASSPATH=/home/blah/Tomcat/common/lib/mysql-connector-java-3.0.14-production-bin.jar:.

 

[IchBin]

hmm...i dont have a common folder but i put it in the lib folder in my
WEB-INF/lib dir
i also tried making a common directory and putting it there
i also tried setting the classpath in the .bashrc file
any idea why this isnt working? or any other suggestions?

export
CLASSPATH=/home/blah/Tomcat/common/lib/mysql-connector-java-3.0.14-production-bin.jar:.

Under Windows Tomcat has a Tomcat5.5\common\lib' subdirectory
where you would put it. Must be different Linux. I have been been a few
years away
from Linux to remember their setup.

You can Google for it like, Tomcat and Database or MySQL and Tomcat. I
found one out there at
http://www.yolinux.com/TUTORIALS/LinuxTutorialTomcat.html#MYSQL

Here is another good link. They are saying the same thing I said about
where the connector goes..
http://alanning.freeshell.org/text/jpetstore/jpetstore_win32_install_walkthrough.html#Tomcat

You may want to search MYSQL website for more info.

--


Thanks in Advance...
IchBin, Pocono Lake, Pa, USA
http://weconsultants.servebeer.com/JHackerAppManager
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)