You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@beehive.apache.org by Wendy <we...@yahoo.com> on 2007/02/22 00:51:07 UTC
JDBC control questions
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)?
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?
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.
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.
Re: JDBC control questions
Posted by Chad Schoettger <ch...@gmail.com>.
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 <we...@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 <we...@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.
>
>
Re: JDBC control questions
Posted by Wendy <we...@yahoo.com>.
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 <we...@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.
Re: JDBC control questions
Posted by Chad Schoettger <ch...@gmail.com>.
Hello,
Hope this helps,
- Chad
On 2/21/07, Wendy <we...@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.
>
>