Re: double Statement.close() (on AIX 5.1) - Mailing list pgsql-jdbc

From Victor Sergienko
Subject Re: double Statement.close() (on AIX 5.1)
Date
Msg-id 11118821312.20040224155205@mail.ru
Whole thread Raw
In response to Re: double Statement.close() (on AIX 5.1)  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Hello Dave,

  I understand that. However, the other JDBC drivers we use don't have
such an issue. Their connection pool might remember the statement's
owner thread or something excessive like that.
  Anyway, it's not about close()s on Connection, just on Statement or
PreparedStatement.
  And moreover, implementation issues should not affect interface.

DC> You are absolutely correct this should not happen. You do however
DC> realize that close on a PooledConnection returns it to the pool?
 [skip]

>> As JDK java.sql.Statement.close() documentation specifies, calling
>> Statement.close() on already close()d statement should have no effect.
>> It's the way Oracle and MS SQL drivers behave, but PG driver throws
>> this exception.
 [skip]
>> Thank you.

Thank you and thank Kris.

--
Best regards,
 Victor                            mailto:singalen@mail.ru


pgsql-jdbc by date:

Previous
From: Pablo Velasquez Rivas
Date:
Subject: Re: Postgres and JBuilderX on Linux
Next
From: Pablo Velasquez Rivas
Date:
Subject: Losing Connections