Jdbc3PoolingDataSource and Statement relationship???
| От | Derek Dilts |
|---|---|
| Тема | Jdbc3PoolingDataSource and Statement relationship??? |
| Дата | |
| Msg-id | F67EB38120F7BB4BB972C786095802070245CF64@ipcbu-exchange.amer.unity.cisco.com обсуждение исходный текст |
| Ответы |
Re: Jdbc3PoolingDataSource and Statement relationship???
Re: Jdbc3PoolingDataSource and Statement relationship??? |
| Список | pgsql-jdbc |
To whom it may concern:
I am getting a Connection from Jdbc3PoolingDataSource.getConnection(), creating and executing a statement, then making a call to Connection.close().
My question is this ... are those statements being closed by Postgres's pooling implementation like they should be, or do I have to keep track and close each Statement b/4 closing the Connection.
I have read the documentation about pooling and Postgres's implementation of the DataSource interface, http://www.postgresql.org/docs/7.3/static/jdbc-datasource.html. I am aware that by using the pool, Connections actually never close and remain open for the life of the pool. However, I am assuming that when my application calls Connection.close(), any associated Statements will be cleaned-up/closed. Is this assumption correct? If so, please point me to any documentation that might explain this. If not, please advise!
Thanks,
Derek
Cisco Systems
972-813-1574
В списке pgsql-jdbc по дате отправления: