Re: [Proxool-user] Running Out Of Connections

[Christian N. <chr...@em...>]

Hi Paul.

It is highly unlikely that this is a problem directly related to Proxool.
Proxool should not be affected by where a request comes from.

You should probably start by comparing the usage patterns of the Indian
office with the usage patterns in US. Maybe they are using functionality
that the US office is not using? Maybe this functionality contains a bug
(e.g. not closing connections properly)? Also make sure that somebody in
India has not made a script or something that connects to the system
repeatedly.

I have never seen that error before. You need to analyze the SQL that
preceded the error to find out more about this.

Regards
Christian

On Wed, Mar 31, 2010 at 2:51 PM, Paul Zepernick <
pze...@co...> wrote:

>  Hello,
>
>
>
> 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.
>
>
>
> I checked out error log and I see this error reported over and over before
> the pool runs out.
>
>
>
> 2010-03-31 03:34:01,836 ERROR (JDBCExceptionReporter.java:72) - [IWS]Error
> expanding '*': all columns incomparable, '*' expanded to zero columns.
>
>
>
> 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
>
>
>
> Thanks,
>
>
>
>
>
> Paul Zepernick
>
> Information Technology
>
> Commerce Benefits Group
>
>
>
> *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.*
>
> *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.*
>
>
>
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
> _______________________________________________
> Proxool-user mailing list
> Pro...@li...
> https://lists.sourceforge.net/lists/listinfo/proxool-user
>
>