beehive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wendy <>
Subject Re: JDBC control questions
Date Thu, 22 Feb 2007 19:57:41 GMT

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 <> 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:
>> 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:
>> Sent from the Beehive - Dev mailing list archive at

View this message in context:
Sent from the Beehive - Dev mailing list archive at

View raw message