Re: How to configure Mysql with Tomcat. (problem Fixed!)

[Tony Keith]

Tony Keith wrote:

Once I copied the Mysql classes to the /WEB-INF/classes directory it worked.
I also was specifying the wrong path for the driver.
I had org.mm.mysql.Driver instead of org.gjt.mm.mysql.Driver.

Thanks for everyone's help.

Noel Morgan wrote:

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
 

I tried this but I still get the same error...
Is there any other configuration to the web.xml?

 
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
 
 

-- 
Tony Keith
Director of Information Technology
Paycom.net
4215 Glencoe Avenue, First Floor
Marina Del Rey, CA  90292
TEL: (310) 827-5880 ext. 304
FAX: (310) 827-5519

 

-- 
Tony Keith
Director of Information Technology
Paycom.net
4215 Glencoe Avenue, First Floor
Marina Del Rey, CA  90292
TEL: (310) 827-5880 ext. 304
FAX: (310) 827-5519