beehive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wendy <wenla...@yahoo.com>
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 <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