I also had the same problem with that driver. JTDS is a much much better driver. Also look at your connection pooling software, using the commons DBCP is also a little shady. I switched to c3p0 and all the connection problems disappeared. Furthermore with c3p0 when the sql server reboots c3p0 is smart enough to reestablish connections.
-B -----Original Message----- From: Woodchuck [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 1:23 PM To: Tomcat Users List Subject: Re: Tomcat 5.5 and SQL Server also, make sure your SQL Server is patched up with the latest SQL Server service pack. woodchuck --- Tim Funk <[EMAIL PROTECTED]> wrote: > FWIW .. there is a new version of the SQLServer JDBC driver from > Microsoft. > > -Tim > > Mitchell Teixeira wrote: > > Hi - I've heard nothing but bad things about the Microsoft JDBC > driver for > > SQL Server. I don't have any suggestions how to fix your problem > in-place, > > just a suggestion to switch drivers. > > > > I've been using this JTDS open souce JDBC driver, suggested by our > vendor > > and it is very stable: > > > > http://jtds.sourceforge.net/ > > > > It was super easy to install and configure. I hope it will help > you! > > > > Regards, > > MitchellT > > > > > > > > --- "Anderson, M. Paul" <[EMAIL PROTECTED]> wrote: > > > > > >>I am running Tomcat 5.5 with SQL Server on a separate machine. > >> > >>I am getting the following error at random times: > >> > >>Java.lang.Exception: java.sql.SQLException: [Microsoft][SQLServer > 2000 > >>Driver for JDBC]Connection rest by peer: socket write error. > >> > >>I have been unable to determine a trigger for this error - it just > seems > >>to happen randomly. When it occurs, no user can then log in to the > >>application - I must reboot the SQL server machine to get a > connection > >>to be made for subsequent logins. > >> > >>Has anyone seen this and can point me to a solution? > >> > >>Thanks, > >>Paul > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > ____________________________________________________ Sell on Yahoo! Auctions - no fees. Bid on great items. http://auctions.yahoo.com/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
