isClosed and large numbers of connections

I am working on a java application that uses sybase. It employs an in-
house database connection pool which uses the Connection.isClosed
method for checking to see if a connection is valid still.
Occasionally this call hangs on a blocking socket read. I am trying to
find out why.

I see from sp_configure that a maximum of 2000 concurrent sessions are
allowed. Over the course of a day the number of sessions taken by this
app gets close to 1000. Can anyone think of specific reasons why this
might be a problem?

Some on our project has said there will be no problem until that limit
is reached then the client will get an error when trying to get a new
connection. The attempt would be rejected, presumably with an error
along the lines of maximum number of connections reached.

Someone else on the project said they had heard that sybase can have
problems when the connection limit is large and reaches half its
configured value, which is the situation I have.

Regards,

Andrew Marlow
.

Relevant Pages

  • Re: Sybase DB - Ende nach der 2. Abfrage
    ... > Trotzdem schaffe ich nur grob 2 Abfragen auf die DB bevor einfach nix ... > mehr geht und die Verbindung nicht mehr klappt. ... > die Sybase auf einen MSSQL klappt wunderbar beliebig oft. ... dass Dein Data Provider ein Problem mit dem Connection ...
    (de.comp.datenbanken.misc)
  • Re: connection string causes blank page
    ... > I am developing a website in ASP that connects to a Sybase database. ... nor the connection. ... Further, the Sybase ... > I have also tried using a Data Source .ids file within the connection ...
    (microsoft.public.inetserver.asp.general)
  • connection string causes blank page
    ... I am developing a website in ASP that connects to a Sybase database. ... nor the connection. ... I have also tried using a Data Source .ids file within the connection string ...
    (microsoft.public.inetserver.asp.general)
  • Re: Database Connection Management
    ... Hopefully Sybase can provide this for you, but if not you'll need to ... >a app.lock/update count/app.unlock (then use connection if available or wait ... you could use a synchronization object known as a semaphore. ... >> for your scenario you could set n at 3 or 5 depending on the web app. ...
    (microsoft.public.dotnet.framework.aspnet)
  • DBD::Sybase 1.05_1 and Perl threads
    ... connecting to Sybase IQ 12.6. ... In my Perl script, I spawn several threads, each making a single ... connection to a separate database. ... Prepare and execute SQL ...
    (perl.dbi.users)