tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tony Keith <to...@paycom.net>
Subject Re: How to configure Mysql with Tomcat.
Date Thu, 16 Nov 2000 20:12:46 GMT
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 <zkimmel@zebware.com>
> Sent    : Thu, 16 Nov 2000 13:49:07 -0500
> To      :
> tomcat-user@jakarta.apache.org,tonyk@paycom.net
> 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



Mime
View raw message