One instance it makes sense is if you use a JSP for your controller. A JSP compiles into a Servlet anyways so sometimes it makes it easier to write a JSP that is nothing more than controller functionality (no display) then to write and configure a Servlet. I know that the SQL taglib saved me HUGE amounts of time on a small project that I worked on just because of the fact that I used it this way.
-Tim -----Original Message----- From: Martin van Dijken [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 6:02 AM To: Tag Libraries Users List Subject: RE: Stored procedure (RFI proposal) Agreed, I think it a horrific thing to do data manipulation in a JSP tag in the first place. Personally I think the whole SQL-taglib is something that never should have been invented in the first place. Martin > -----Original Message----- > From: Vic Cekvenich [mailto:[EMAIL PROTECTED] > Sent: zaterdag 12 juli 2003 1:21 > To: [EMAIL PROTECTED] > Subject: Re: Stored procedure (RFI proposal) > > > Of course... data access in a presentation view is bad practice, much > better to unit test a bean (with DAO, such as iBatis.com) in > an MVC way. > Then you can reuse you bean for Soap, etc., not just JSP and > keep your > JSP code clean. > > > Michael Duffy wrote: > > >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 > > > > > > -- > Vic Cekvenich, > Struts Instructor, > 1-800-917-JAVA > > Advanced <a href ="baseBeans.com">Struts Training</a> and > project recovery in North East. > Open Source <a href ="baseBeans.com">Content Management</a> > basicPortal sofware > Best practice<a href ="baseBeans.com">Struts Support</a> > v.1.1 helper ScafflodingXPress > > --------------------------------------------------------------------- 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]