For Tomcat 3.2b6 I used:
my setup:
Apache 1.3.12
RH 6.2 Linux 2.2.14-5.0
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con =
DriverManager.getConnection("jdbc:mysql://localhost:3306/DatabaseName?user=dbuser&password=dbpassword");
put the jdbc drivers in the classes folder of your
app like:
cp -Rf $JDBC_HOME/org $MYAPP_HOME/WEB-INF/classes
That should do it, but I have noticed serious
performance degradation in switching from JServ
1.1.2 to Tomcat 3.2b6. I am not sure if I am missing
something in the docs, but JServ 1.1.2/GNUJsp 1.0 is
IMHO much faster (at least with the mm.mysql JDBC
driver apps I have written) If someone could point
me to some tuning tips/parameters I may have missed
in the standard docs I would really appreciate it.
Noel
----- Original Message -----
>From : Zebadiah Kimmel <[EMAIL PROTECTED]>
Sent : Thu, 16 Nov 2000 13:49:07 -0500
To :
[EMAIL PROTECTED],[EMAIL PROTECTED]
Subject : Re: How to configure Mysql with Tomcat.
The following code should work if your database's
rootpassword is empty:
Class.forName(dbDriver).newInstance();
connPool[i]=DriverManager.getConnection("jdbc:mysql://"+dbServer+"?user="+db
Login);
As for connecting with a non-empty password, I
don'tknow how to do that.
If you figure it out, please let me know.
--Zeba
At 09:58 AM 11/16/00 -0800, Tony Keith wrote:
>Hello,
>
>I wrote a simple servlet to insert a row into a
mysqldatabase table.
>I'm running Tomcat
>
>What are the steps to configure Tomcat to work
withthis servlet?
>The problem I'm having now is the driver isn't
found.
>
>Where do I place the driver? In the lib directory?
>
>How do I reference a new instance of the driver?
>This is how I reference it now:
>Class.forName("org.mm.mysql.Driver").newInstance();
>
>Will the connection information remain the same?
>Here is the connection information I currently use:
>con
=DriverManager.getConnection("jdbc:mysql://localhost/webdata",
>"user", "password");
>
>TIA
>--
>Tony Keith
__________________________________________________
Move your email to a better address.
Over 1,000 domains to choose from! FREE! PRIVATE!
http://www.MailSpace.com
