Argh... Hate when I post these to the wrong list
-----Original Message-----
From: Greg Cook [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, September 24, 1998 9:54 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Java interface to MySQL
You can also try Terrence W. Zeller's JDBC driver for MySql
Probably at `http://www.tcx.se/' under contributed software.
I dunno which JDBC is best, though
[Greg Cook]
I have tested several of the MySQL JDBC drivers here.
The fastest is the gwe driver. The most stable is the mm driver.
The mm driver also has the nice feature of allowing multiple open ResultSets per
connection. The mm drivers actually buffer the entire ResultSet then feed them to you
as you .next() em. On large transfers the gwe driver is much faster response, but the
mm drivers are 250% more stable than the gwe under heavy loads. The gwe drivers close
the socket and reopen for _every_ stmt.close() and con.close() coded. Under high
retrieve, update, retrieve, search loads the gwe throws broken SocketExceptions. The
gwe would be the better of the two if someone could convince the author to finish
reading in the socket stream if the ResultSet is closed before all of the rows are
read instead of closing and reopening the socket.
Greg Cook
Vnews.net
Unsubscription, archives, FAQ - http://www.xcf.berkeley.edu/lists.html
