Re: jdbc pooling question
От | Marcus Andree S. Magalhaes |
---|---|
Тема | Re: jdbc pooling question |
Дата | |
Msg-id | 61025.200.174.148.100.1073857927.squirrel@webmail.webnow.com.br обсуждение исходный текст |
Ответ на | Re: jdbc pooling question ("Neil Murray" <nhm@mimecast.net>) |
Список | pgsql-jdbc |
> > I posed a similar question to the forum a couple of weeks back and got > no answer. I have similar problems, but my biggest bugbear is the fact > that the Jdbc3PoolingDataSource (I use the JDBC3 drivers) does not throw > any timeout exception if you use getConnection() and there are no Yes. That's exactly what we found here. If there are no connections available, the getConnection will wait, wait and wait. The caller class has no way to set a timeout... > available connections in the pool. The reason why there are no > connections left in the pool is a matter I need to investigate further, > but I could be experiencing a similar problem to you. > I double checked the code and found a couple places where we did the following: if (statement != null) statement.close(); if (connection != null) connection.close(); but the ResultSet wasn't closed. This left me wandering if an opened resultset could be the leak source. > My team is working on our own connection pool - which will provide a bit > more transparency. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html
В списке pgsql-jdbc по дате отправления: