AppletTalk.com Forum Index AppletTalk.com
Java discussions newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Java and JSP to MySQL database

 
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases
View previous topic :: View next topic  
Author Message
Ivan
Guest





PostPosted: Sat Nov 08, 2003 3:28 am    Post subject: Java and JSP to MySQL database Reply with quote



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
Back to top
Petarian
Guest





PostPosted: Sat Nov 08, 2003 5:45 pm    Post subject: Re: Java and JSP to MySQL database Reply with quote



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:

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





Back to top
Display posts from previous:   
Post new topic   Reply to topic    AppletTalk.com Forum Index -> Java and Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.