Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Error with: MySQL+Tomcat

  Asked By: Diane    Date: Jul 07    Category: Java    Views: 760

It's been days I'm trying to use Tomcat 5.0.28, MySQL 4.1 and
Connector/J 3.1 throgh JSTL but it didn't work out. I've tried almost
every thing with every configuration.

the latest exception occured was:
Unable to get connection, Data source invalid: "java.sql.SqlException:
No Suitable Driver"

yes, i copied every single required jar file into the proper
directory, changed server.xml and web.xml a thousand times.

Does anyone have any suggestion?
Does anybody know a configuration of both(MySQL and Tomcat) that works
correctly along JSTL?



4 Answers Found

Answer #1    Answered By: Channarong Boonliang     Answered On: Jul 07

Where did you copy the Connector/J? The best place to put the Connector/J JAR
file is the
common/lib directory under the Tomcat's home directory. Putting the JAR file
under WEB-INF/lib
won't work  in some circumstances (i.e. class loader problems).

Answer #2    Answered By: Abagail Cohen     Answered On: Jul 07

Tomcat doesn't use the system's CLASSPATH global variable,
make sure that your Connector/J is in the common directory of
Tomcat installation.

Answer #3    Answered By: Daisy Phillips     Answered On: Jul 07

As per my knowledge, if u find any data-sourse.xml or like that check that file. which database u connected/usernam/pwd such things..

go to this link..


Answer #4    Answered By: Keiko Mori     Answered On: Jul 07

Thank you so much for your considerations, but I've
read alot of documents including "jndi....How-To" and
many more. also I've copied  the jar  file in
{TOMCAT}\common\lib and no use.

I'm trying to focus more on APACHE GERONIMO 1.1 J2EE
has anyone tested it before with any database?

Didn't find what you were looking for? Find more on Error with: MySQL+Tomcat Or get search suggestion and latest updates.