Closing one connection closes all connections?

Поиск
Список
Период
Сортировка
От Ian McFarland
Тема Closing one connection closes all connections?
Дата
Msg-id 34979724-4E2A-11D7-B1F0-0003938E4906@neo.com
обсуждение исходный текст
Ответы Re: Closing one connection closes all connections?
Список pgsql-jdbc
Greetings,

I'm getting interesting behavior from connection pooling when I use
PostgreSQL + pg73jdbc2ee.jar: specifically, closing one connection from
the pool seems to close all connections: (This example using Tomcat.)


Test 0.
Comparing two connection objects from PostgreSQL driver:
org.apache.commons.dbcp.PoolableConnection@895cb9,
org.apache.commons.dbcp.PoolableConnection@26a4a2: Equal? false
con.isClosed(): false
con2.isClosed(): false
Closing con with con.close()
con.isClosed(): true
con2.isClosed(): true
End of test 0.

The connection in question is being returned from a
datasource.getConnection() call. As a separate issue, sometimes this
same call will in fact return the same instance of a connection in two
subsequent calls. I haven't gone and looked at the spec yet, but this
seems to me to be incorrect behavior. (As does the behavior illustrated
above.)

Where is the canonical source for the JDBC driver, anyway? I'd love to
look through the source for it and see if I can track down this issue.

Are people using connection pooling with PostgreSQL successfully in
production code? Do I have the wrong version of the JAR? I tried to
find more on this in the list archives, but wasn't able to so far.
Sorry if this is a FAQ and I'm overlooking something.

Cheers,
-Ian


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Rich Cullingford
Дата:
Сообщение: More on updates with first() vs absolute()
Следующее
От: Sangyoon Oh
Дата:
Сообщение: Return Type Table.