Johann Uhrmann wrote: > Hi, > > are database connections automatically closed by the jstl on pages > which use the <sql:setDataSource ...> tag? > > I use this tag to connect to a database connection pool and the pool > is running out of available connections from time to time.
The <sql:setDataSource> action creates a DataSource _without_ pooling, in the most common case (you can use it to expose a pooled DataSource, created by some other code, but that's rarely how it's used). The <sql:query>, <sql:update> and <sql:transaction> actions always close the Connection they get from the DataSource. So if you're using <sql:setDataSource> in the typical way, plus the other JSTL SQL actions, I doubt that the problem lies with JSTL. You may want to elaborate on "I use this tag to connect to a database connection pool" and also tell us if you use the pool from some other code than the JSTL SQL actions. Hans -- Hans Bergsten [EMAIL PROTECTED] Gefion Software http://www.gefionsoftware.com JavaServer Pages http://TheJSPBook.com -- To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:taglibs-user-help@;jakarta.apache.org>
