Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Connection.isClosed()

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-06-05 12:01:59.0Z
David Ottow Posted on 1997-06-03 10:35:17.0Z
Message-ID: <3393F365.5BBD@trema.com>
Date: Tue, 03 Jun 1997 12:35:17 +0200
From: David Ottow <dottow@trema.com>
Organization: Trema Laboratories SARL
X-Mailer: Mozilla 3.01 (X11; I; SunOS 5.6 sun4u)
MIME-Version: 1.0
Subject: Connection.isClosed()
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Newsgroups: sybase.public.jdbcconnect
Lines: 28
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:735
Article PK: 252487

Hi,

I'm using the latest (May 30th) release of jConnect and everything is
just fine and dandy except for one thing...

My application keeps 4 or 5 connections open for a while... they're
never closed, in fact, as we've found that boosts performance a lot! If
somebody has the application open for a while without using it, however,
we run into problems... say they go get a cup of java, or something...

So they come back, and our code checks that the connection is not closed
by calling...ya guessed it... connection.isClosed()!!

Welll... that doesn't seem to come back to us... it just hangs there...

Any ideas?

Thanks,

David Ottow
dottow@trema.com


~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~
Trema Laboratories SARL | David F. Ottow
http://www.trema.com | Phone: +33-4-92-38-81-06
1300, Route des Crêtes | Fax: +33-4-92-38-81-99
06560 Valbonne | Cell: +33-6-80-42-12-40
FRANCE | Email: dottow@trema.com


Lance Andersen Posted on 1997-06-05 12:01:59.0Z
Message-ID: <3396AAB7.4422@sybase.com>
Date: Thu, 05 Jun 1997 08:01:59 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: David Ottow <dottow@trema.com>
Subject: Re: Connection.isClosed()
References: <3393F365.5BBD@trema.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.jdbcconnect
Lines: 46
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:720
Article PK: 252472

David,

Are you sure that you are hanging in connection.isClosed()?
We only test a flag and then return in this method.

My suggestion is that you turn on the jConnect debugging/tracing
which is documented at:


http://www/products/internet/jconnect/docs/prjdbc_4.htm#HEADING4-179


-lance

David Ottow wrote:
>
> Hi,
>
> I'm using the latest (May 30th) release of jConnect and everything is
> just fine and dandy except for one thing...
>
> My application keeps 4 or 5 connections open for a while... they're
> never closed, in fact, as we've found that boosts performance a lot! If
> somebody has the application open for a while without using it, however,
> we run into problems... say they go get a cup of java, or something...
>
> So they come back, and our code checks that the connection is not closed
> by calling...ya guessed it... connection.isClosed()!!
>
> Welll... that doesn't seem to come back to us... it just hangs there...
>
> Any ideas?
>
> Thanks,
>
> David Ottow
> dottow@trema.com
>
> ~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~-=-~
> Trema Laboratories SARL | David F. Ottow
> http://www.trema.com | Phone: +33-4-92-38-81-06
> 1300, Route des Crêtes | Fax: +33-4-92-38-81-99
> 06560 Valbonne | Cell: +33-6-80-42-12-40
> FRANCE m

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================