AppletTalk.com

Ivan · Guest

Dear all,

I am planning to build my web application with the following
architecture:

Redhat Linux 9.0 platform
Apache Tomcat Web Server
MySQL database
JSP with Java for writing the web page

But unfortunately, I encountered some problems in properly linking my
JSP to the mysql database. I have installed the JDBC connector
interface already.
I would apperciate if anyone can give me some hints on the proper set
up and configuring of the architecture.

Thanks a lot.

Ivan

Petarian · Guest

What error(s) are you getting. The most common reason for this to not
work is:

1) MySQL Jar files are not in your class path. Put mysql.jar in

$TOMCAT/webapps/$YOUR_APP/WEB-INF/lib

2) You have specified an incorrect connection string. Your class name
for JDBC driver should be:

com.mysql.jdbc.Driver

and the connection URL should be:

jdbc:mysql://<HOSTNAME>:<PORT>/<DBNAME>

We are using exact same configuration on our site and everything is
working fine.

Regards,
Pete

--

You don't pay to get spam, why pay to clean it?
Visit http://www.spammarshall.com to create an account for free
<http://www.spammarshall.com>

Ivan wrote: