Am Montag, 11. November 2002 18:40 schrieb Hans Bergsten: > 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.
Thank You, as far as I know, that behaviour is not documented in the jstl-documentations. > 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. I am using the setDataSource tag in order to get the database connection pool which is provided by tomcat: <sql:setDataSource var="mydb" dataSource="jdbc/foodb" /> However, there might be a different source for my problem as not just the connection pool told me that it's out of connection but also the database engine itself. Thank You for Your help, Hans -- To unsubscribe, e-mail: <mailto:taglibs-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:taglibs-user-help@;jakarta.apache.org>
