how to close sql:query resultset
once you use sql:query var=test and then c:forEach is there a way to close that var 'test' ? or we just leave it? i think this is a waste of resource --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 10/15/2002 -- To unsubscribe, e-mail: mailto:taglibs-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:taglibs-user-help;jakarta.apache.org
Re: how to close sql:query resultset
On Wed, 23 Oct 2002, Mark Goking wrote: once you use sql:query var=test and then c:forEach is there a way to close that var 'test' ? or we just leave it? i think this is a waste of resource 'test' doesn't represent a ResultSet; it represents a temporary cache of your data, and it will be garbage collected as necessary. The goal was to prevent the exposure of hard resources (like database connections) to JSP page authors -- and thus let page authors avoid having to worry about resource deallocation. -- Shawn Bayern JSTL in Action http://www.jstlbook.com -- To unsubscribe, e-mail: mailto:taglibs-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:taglibs-user-help;jakarta.apache.org
RE: how to close sql:query resultset
ah ic. are JSTL sql tags capable of executing multiple update queries in once tag? sql:update UPDATE TABLE SET FIELD = 'test'; DELETE FROM TABLE WHERE FIELD = 'my'; /sql:update ?? just wondering. i may have missed out on some new updates if they do support this feature ;) mark --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 10/15/2002 -- To unsubscribe, e-mail: mailto:taglibs-user-unsubscribe;jakarta.apache.org For additional commands, e-mail: mailto:taglibs-user-help;jakarta.apache.org