Do you mean you want to batch commands, the way the java.sql.Statement.addBatch allows you to? That would be useful to lots of people, I'll bet. I think that would require tag changes, too.
I can see a <sql:batch> tag that could have multiple <sql:update> children. Do they do such a thing in Jakarta's DBTags taglib? - MOD --- James Smith <[EMAIL PROTECTED]> wrote: > I was actually dealing with a similar problem > yesterday; I wanted to write a > tag that called not a stored procedure, but several > SQL statements in a row, > using a dataSource, just like I would use for > <sql:xxxx> tags. After > looking through the source code, I noticed that the > abstract classes > org.apache.taglibs.standard.tag.common.sql.QueryTagSupport > and > org.apache.taglibs.standard.tag.common.sql.UpdateTagSupport > both used the > exact same code to access a data source. So, I was > wondering if in future > versions of the tag library, we could have an > abstract tag that extended > BodyTagSupport and did all the work of getting the > dataSource and database > connection, and then QueryTagSupport and > UpdateTagSupport (I didn't look at > TransactionTagSupport that closely, but I'm assuming > it does something > similar) could inherit from that class, as could any > other tags that would, > say, call multiple SQL statements or call a stored > proc using a JSTL > dataSource. Since I haven't looked at the source > code for the standard > taglibs under Tomcat 5-alpha, I don't know if this > idea would still be > compatible with the newer code, but if it is, I > think it would be useful. > Just an idea! Thanks, > > James Smith > Application Systems Analyst, Treistman Center > College of Fine Arts, University of Arizona > > ----- Original Message ----- > From: "Michael Duffy" <[EMAIL PROTECTED]> > To: "Tag Libraries Users List" > <[EMAIL PROTECTED]> > Sent: Wednesday, July 02, 2003 4:40 AM > Subject: Re: Stored procedure > > > > > > Not if the underlying implementation isn't using > > CallableStatement. Stored procs can have in, out, > and > > inout parameters. They can also return multiple > > ResultSets. > > > > When I look at the java.sql.CallableStatement > > javadocs, it seems clear to me that it's a very > > different animal from Statement and > PreparedStatement. > > The taglibs that support it will look very > different > > from the JSTL sql taglib. JMHO - MOD > > > > --- Daniel Montero <[EMAIL PROTECTED]> wrote: > > > I believe you can just do something like > > > <sql:query datasource="jdbc/myds" sql="exec > my_proc" > > > /> > > > > > > just like any other sql statement. > > > > > > > > > > > > ----- Original Message ----- > > > From: "Kevin Passey" <[EMAIL PROTECTED]> > > > To: "Taglibs (E-mail)" > > > <[EMAIL PROTECTED]> > > > Sent: Tuesday, July 01, 2003 9:40 AM > > > Subject: Stored procedure > > > > > > > > > > Hi, > > > > > > > > Are there any taglibs which I can use to call > a > > > stored procedure. > > > > > > > > Thanks > > > > > > > > Kevin > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > > [EMAIL PROTECTED] > > > > > > > > > __________________________________ > > Do you Yahoo!? > > SBC Yahoo! DSL - Now only $29.95 per month! > > http://sbc.yahoo.com > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
