jdbc class not found exception with tomcat in linux

Thread view:

vamp4l - 28 Nov 2005 23:00 GMT

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

Reply to this Message

VisionSet - 28 Nov 2005 23:14 GMT

> 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

--
Mike W

Reply to this Message

IchBin - 28 Nov 2005 23:29 GMT

> Hey, I'm getting the
>
[quoted text clipped - 8 lines]
> needs to go?
> thanks

As far as I now it goes into

TomcatBase\common\lib

Signature

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-)

Reply to this Message

vamp4l - 28 Nov 2005 23:58 GMT

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:.

Reply to this Message

IchBin - 29 Nov 2005 03:03 GMT

> hmm...i dont have a common folder but i put it in the lib folder in my
> WEB-INF/lib dir
[quoted text clipped - 4 lines]
> 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.

Signature

Reply to this Message

jdbc class not found exception with tomcat in linux

Free Magazines