On Thu, 2 May 2002, Soefara Redzuan wrote: > But why is it even necessary to use <sql:transaction> ? Is it enough > that the JSP uses the same database connection for all <sql: > tags on > the page ? I think so.
<sql:query> and <sql:update> don't accept individual Connections; they operate on DataSources, and you're not guaranteed to get the same Connection each time you retrieve one from a DataSource. <sql:transaction> guarantees that the same connection is used for all child <sql:query> and <sql:update> tags. -- Shawn Bayern "JSP Standard Tag Library" http://www.jstlbook.com (coming this summer from Manning Publications) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>