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]
