beehive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Schoettger" <chad.schoett...@gmail.com>
Subject Re: JDBC control questions
Date Fri, 23 Feb 2007 15:35:43 GMT
The JDBC control can not be invoked from a pojo, you can however test
your jdbc controls using JUnit in a standalone environment.  See
http://beehive.apache.org/docs/1.0.2/controls/testing.html for a
detailed description of how to do that.

- Chad

On 2/22/07, Wendy <wenlai_w@yahoo.com> wrote:
>
> Thank you very much, this really helps me.
> I have another question: can jdbc control be invoked in a plain old java
> class? if yes, how can I initialize the jdbc control? I tried to use
> @Control annotation, but it throws a NullPointerException.
>
>
> Chad Schoettger-2 wrote:
> >
> > Hello,
> >
> > Hope this helps,
> >   - Chad
> >
> >
> > On 2/21/07, Wendy <wenlai_w@yahoo.com> wrote:
> >>
> >> Hi, I'm a new user for Jdbc control. I have some questions about it and
> >> hope
> >> to get advices from jdbc control experts.
> >> 1. there's a method findCustomeByName, the logic is if only firstname
> >> passed
> >> in, then search by firstname, if only lastname passed in, then search by
> >> lastname, if both are passed in, then search by firstname and last name.
> >> How
> >> can I implement this functionality in jdbc control with a method define
> >> as
> >> findCustomerByName(String firstname, String lastname)?
> >
> > If you want this kind of logic you have a number of options:
> > 1) Create a stored procedure which encapsulates the logic and
> >    invoke the stored procedure from your JDBC control method.
> > 2) Create three JDBC control methods (one for each case) and
> >    invoke the proper one based on logic in the page flow controller
> >    or a custom control.
> > 3) In the SQL annotation for the JDBC control method, use the {sql:} form
> >    of substitution and pass in the necessary SQL fragment to find the
> >    customer.
> >
> > If you haven't already, you may want to take a look at the JDBC
> > Control Developer guide, it can be found at:
> >
> > http://beehive.apache.org/docs/1.0.2/system-controls/jdbc/guide.html
> >
> >
> >> 2. when are onAcquire() and onRelease() methods in jdbc control exactly
> >> invoked? If I have a page flow using a jdbc control,when the jdbc
> >> connection
> >> is established and when it is closed?
> > From a page flow control resources are scoped to the HttpRequest.
> > onAcquire will be invoked the first time in a request that a control
> > method is invoked.  Once the Request has completed the onRelease()
> > method is invoked.  So for each request which uses the JDBC control, a
> > connection will be established and released.  There is a new JDBC
> > control API which can be used to tune this behavior, setConnection(),
> > however; it is not in Beehive 1.0.2, but will be included in a future
> > release.
> >
> >> 3. Is it possible to use jdbc control in an EJB, i.e. stateless session
> >> bean?  If yes, how can I do it? Please give me some code examples.
> > This currently is not supported.
> >
> >>
> >> Thank you very much.
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/JDBC-control-questions-tf3270091.html#a9091777
> >> Sent from the Beehive - Dev mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context: http://www.nabble.com/JDBC-control-questions-tf3270091.html#a9107048
> Sent from the Beehive - Dev mailing list archive at Nabble.com.
>
>

Mime
View raw message