There's a metric buttload of JDBC drivers out there, for every database:
http://industry.java.sun.com/products/jdbc/drivers
For MS SqlServer alone, they list 27; for ODBC, 19.
-- Bill K.
> -----Original Message-----
> From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 12:05 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
>
>
> If I were to pick the weakest link, it'd probably be the
> jdbc-odbc bridge.
> FYI, for my own stress tests, I was able to run 24 hours at
> 20+ hits/second
> using Tomcat 3.2.1, IBMJava2-13, Apache 1.3.19, mod_jk
> w/ajp13, into a MySQL
> 3.23.35 database. This was all running on a fairly cheap
> linux box -- RedHat
> 6.2, 2.2.17 kernel, 128MB RAM, everything on one IDE drive. I
> was using a
> test suite with 25 concurrent threads on another machine
> (WinNT) connected
> by a 100bT ethernet doing simple insert statements. I actually got the
> Tomcat/Linux box up to 54 inserts per second, but the load average
> skyrocketed so I cut it back to something reasonable. Almost 2 million
> records into my database without a glitch. I was actually
> very surprised by
> the performance, since I hadn't tweaked anything and I was
> using the default
> Tomcat config.
>
> Granted, my test was pretty simple. I was only using one
> servlet and no .jsp
> pages.
>
> Are there any alternatives to the jdbc-odbc bridge? I thought
> that you used
> to be able to use the Sybase drivers to connect to MS-SQL --
> but that may
> have been a long time ago and, obviously, nothing that was
> every officially
> supported.
>
> Thanks,
> --jeff
>
> ----- Original Message -----
> From: "Andy C" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 12, 2001 12:22 AM
> Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
>
>
> > ----- Original Message -----
> > From: "Jeff Kilbride" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>; "Andy C" <[EMAIL PROTECTED]>
> > Sent: Wednesday, April 11, 2001 11:25 PM
> > Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
> > > Hi Andy,
> > >
> > > Did you ever post your configuration? I would be
> interested in what OS;
> > > Tomcat/Apache versions; JVM; DB backend and driver; whether or not
> you're
> >
> > I have to admit that the configuration is a little complex,
> mostly because
> > of legacy
> > database and servlets left over from the JavaWebserver
> version. Here goes
> > though:
> >
> > Server is NT2000
> > Apache is 1.3.12 with mod_jk
> > Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it
> would fix the
> > problem.)
> > JVM is 1.1.6 (old version but it's the only one that would
> run a legacy
> > servlet)
> >
> > Databases are:
> > mysql 3.23.28 (Handles all the main jsp stories)
> > SQL server V7 (Handles servlet requests for release dates)
> >
> > JDBC bridge to mysql is mm-mysql-2.0.4
> > JDBC-ODBC bridge for SQL server (This could be the problem)
> >
> > Hope this is of interest.
> >
> > Andy C
> > Editor R2 Project
> > http://www.r2-dvd.org
> >
> >
>
