Menu
▾
▴
[Proxool-user] Running Out Of Connections
|
From: Paul Z. <pze...@co...> - 2010-03-31 13:09:18
|
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 12 (filtered medium)"> <style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} span.EmailStyle17 {mso-style-type:personal; font-family:"Calibri","sans-serif"; color:windowtext;} span.EmailStyle18 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1" /> </o:shapelayout></xml><![endif]--> </head> <body lang=EN-US link=blue vlink=purple> <div class=Section1> <p class=MsoNormal>Hello,<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal>We are experiencing an intermittent problem with running out of connections when our site is accessed by one of our offices in India. We are in the US. There are about 12 people using the system in India and we have 50 + people on the system on our LAN and never run out of connections during the day. It does not appear to be an issue with the closing of the connection back to the pool. This application has been in use for a couple years and we are now just seeing this problem.<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal>I checked out error log and I see this error reported over and over before the pool runs out.<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal>2010-03-31 03:34:01,836 ERROR (JDBCExceptionReporter.java:72) - [IWS]Error expanding '*': all columns incomparable, '*' expanded to zero columns.<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal>We are running SQL Server 2000. I have tried to research this error and I have not come up with much on it. Can anyone give me some direction on what I can do to try and pin point the problem? We are currently running proxool-0.9.0RC3<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal>Thanks,<o:p></o:p></p> <p class=MsoNormal><o:p> </o:p></p> <p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p> <p class=MsoNormal><span style='color:black'>Paul Zepernick<o:p></o:p></span></p> <p class=MsoNormal><span style='color:black'>Information Technology<o:p></o:p></span></p> <p class=MsoNormal><span style='color:black'>Commerce Benefits Group<o:p></o:p></span></p> <p class=MsoNormal><o:p> </o:p></p> </div> <!--[object_id=#commercebenefitsgroup.com#]--><FONT face=Tahoma size=2><FONT color=#0000ff> <P><I><SPAN style="FONT-FAMILY: Arial"><FONT color=#000000>The information contained in this transmission contains confidential information that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party unless required to do so by law or regulation and is required to destroy the information after its stated need has been fulfilled.</FONT></SPAN></I></P> <P><I><SPAN style="FONT-FAMILY: Arial"><FONT color=#000000>If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of these documents is strictly prohibited. If you have received this information in error, please notify the sender immediately by return email and arrange for the return or destruction of these documents.</FONT></SPAN></I></P> <P class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT color=#000000><FONT face="Times New Roman"> <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></FONT></P> <P align=center></FONT></FONT></P></body> </html> |