RE: Tomcat 5.5 and SQL Server
What driver are you using between Tomcat and SQL server? -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:35 To: Tomcat Users List Subject: Tomcat 5.5 and SQL Server 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat 5.5 and SQL Server
com.microsoft.jdbc.sqlserver.SQLServerDriver -Original Message- From: Sue Roe [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:43 AM To: 'Tomcat Users List' Subject: RE: Tomcat 5.5 and SQL Server What driver are you using between Tomcat and SQL server? -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:35 To: Tomcat Users List Subject: Tomcat 5.5 and SQL Server 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - 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]
RE: Tomcat 5.5 and SQL Server
From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] 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. Any antivirus on either machine? Especially anything that might hook the network stack? Anything in SQL Server's server log? If you run the SQL Profiler and set up a trace that logs exceptions and warnings, do you see anything? - Peter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat 5.5 and SQL Server
Ok. I haven't any experience with that, but I can say we were having similar sporadic errors here with a Driver from Inet software (Merlia.jar),and having upgraded it recently, the issue seems to have been resolved. I was told that it was something to do with SQL Server throwing the connections out, occasionally. So possibly it's a driver bug, not maintaining your connections. That's as much as I know! Good luck... -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:47 To: Tomcat Users List Subject: RE: Tomcat 5.5 and SQL Server com.microsoft.jdbc.sqlserver.SQLServerDriver -Original Message- From: Sue Roe [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:43 AM To: 'Tomcat Users List' Subject: RE: Tomcat 5.5 and SQL Server What driver are you using between Tomcat and SQL server? -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:35 To: Tomcat Users List Subject: Tomcat 5.5 and SQL Server 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Tomcat 5.5 and SQL Server
From: Sue Roe [EMAIL PROTECTED] Reply-To: Tomcat Users List tomcat-user@jakarta.apache.org To: 'Tomcat Users List' tomcat-user@jakarta.apache.org Subject: RE: Tomcat 5.5 and SQL Server Date: Mon, 11 Jul 2005 17:10:01 +0100 Ok. I haven't any experience with that, but I can say we were having similar sporadic errors here with a Driver from Inet software (Merlia.jar),and having upgraded it recently, the issue seems to have been resolved. I was told that it was something to do with SQL Server throwing the connections out, occasionally. So possibly it's a driver bug, not maintaining your connections. That's as much as I know! Good luck... -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:47 To: Tomcat Users List Subject: RE: Tomcat 5.5 and SQL Server com.microsoft.jdbc.sqlserver.SQLServerDriver -Original Message- From: Sue Roe [mailto:[EMAIL PROTECTED] Sent: Monday, July 11, 2005 11:43 AM To: 'Tomcat Users List' Subject: RE: Tomcat 5.5 and SQL Server What driver are you using between Tomcat and SQL server? -Original Message- From: Anderson, M. Paul [mailto:[EMAIL PROTECTED] Sent: 11 July 2005 16:35 To: Tomcat Users List Subject: Tomcat 5.5 and SQL Server 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - 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] ***Disclaimer*** The contents of this Email may be privileged and are confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Should you wish to use Email as a mode of communication, CMi plc and its subsidiaries are unable to guarantee the security of Email content outside of our own computer systems. This footnote also confirms that this Email message has been checked by MIMESweeper for the presence of computer viruses. Whilst we run anti-virus software, you are solely responsible for ensuring that any Email or attachment you receive is virus free. We disclaim any liability for any damage you suffer as a consequence of receiving any virus. Checkmate International plc (CMi) Registered in England No: 1899857 Registered Office 4th Floor, 35 New Bridge Street, London, EC4V 6BW - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] the driver these guy's provided works pretty well. http://jtds.sourceforge.net/faq.html _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Tomcat 5.5 and SQL Server
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]
Re: Tomcat 5.5 and SQL Server
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]
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]
RE: Tomcat 5.5 and SQL Server
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]
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]
RE: Tomcat 5.5 and SQL Server
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]