You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by James Smith <jk...@email.arizona.edu> on 2003/07/02 16:49:08 UTC
Re: Stored procedure (RFI proposal)
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" <du...@yahoo.com>
To: "Tag Libraries Users List" <ta...@jakarta.apache.org>
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 <da...@soin.co.cr> 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" <kp...@kdpsoftware.co.uk>
> > To: "Taglibs (E-mail)"
> > <ta...@jakarta.apache.org>
> > 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:
> > taglibs-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > taglibs-user-help@jakarta.apache.org
> >
>
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
Re: Stored procedure (RFI proposal)
Posted by Vic Cekvenich <vi...@baseBeans.com>.
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 <jk...@email.arizona.edu> 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" <du...@yahoo.com>
>>To: "Tag Libraries Users List"
>><ta...@jakarta.apache.org>
>>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 <da...@soin.co.cr> 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" <kp...@kdpsoftware.co.uk>
>>>>To: "Taglibs (E-mail)"
>>>><ta...@jakarta.apache.org>
>>>>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:
>>>>taglibs-user-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail:
>>>>taglibs-user-help@jakarta.apache.org
>>>>
>>>>
>>>>
>>>__________________________________
>>>Do you Yahoo!?
>>>SBC Yahoo! DSL - Now only $29.95 per month!
>>>http://sbc.yahoo.com
>>>
>>>
>>>
>>>
>---------------------------------------------------------------------
>
>
>>>To unsubscribe, e-mail:
>>>
>>>
>>taglibs-user-unsubscribe@jakarta.apache.org
>>
>>
>>>For additional commands, e-mail:
>>>
>>>
>>taglibs-user-help@jakarta.apache.org
>>
>>
>>
>>
>>
>---------------------------------------------------------------------
>
>
>>To unsubscribe, e-mail:
>>taglibs-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail:
>>taglibs-user-help@jakarta.apache.org
>>
>>
>>
>
>
>__________________________________
>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
Re: Stored procedure (RFI proposal)
Posted by Michael Duffy <du...@yahoo.com>.
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 <jk...@email.arizona.edu> 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" <du...@yahoo.com>
> To: "Tag Libraries Users List"
> <ta...@jakarta.apache.org>
> 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 <da...@soin.co.cr> 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" <kp...@kdpsoftware.co.uk>
> > > To: "Taglibs (E-mail)"
> > > <ta...@jakarta.apache.org>
> > > 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:
> > > taglibs-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > > taglibs-user-help@jakarta.apache.org
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > SBC Yahoo! DSL - Now only $29.95 per month!
> > http://sbc.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
> >
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> taglibs-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> taglibs-user-help@jakarta.apache.org
>
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org