using JSQConnect is also very very good (incl connection pooling). The only disadvantage is that you have to buy a license. but for a "big" website with a lot of db activity this disadvantage is to overlook.
maarten -----Oorspronkelijk bericht----- Van: Mitchell Teixeira [mailto:[EMAIL PROTECTED] Verzonden: maandag 11 juli 2005 19:38 Aan: Tomcat Users List Onderwerp: RE: Tomcat 5.5 and SQL Server Hi - I'm eavesdropping this thread (obviously) so that I can learn more about Tomcat across all aspects, esp. since I need SQL Server connectivity! What is c3p0?? Does it replace some existing part of Tomcat? Thanks - MitchellT --- Brian McGovern <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.11/45 - Release Date: 9-7-2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.8.11/45 - Release Date: 9-7-2005 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
