Hello,
Hope this helps,
- Chad
On 2/21/07, Wendy <[EMAIL PROTECTED]> 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.
