Tim
This issue kinda falls into the context of presenting user with listings of
data from EBs.
1. With SB + JDBC you shoot off a query using DAO pattern (which has
the necessary JDBC) as mentioned in the Sun J2EE Blue Prints
2. Get back the result with the minimum required number of fields
(order number and date maybe)
3. Get the user to choose the Order number from where onwards the SB
can delegate to the EBHome.
This way, we can have efficieny and modularity. In case DB changes do occur,
DAO needs to be modified and not the SB calls. I AM doing this right now for
one of our catalogs and it is much better than when I used to use the other
option.
Again, this is a touchy area and as you mentioned a lot depends on
volume/frequencies/size.
Cheer
Madhu
-----Original Message-----
From: Tim Shaw [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:29 AM
To: [EMAIL PROTECTED]
Subject: Re: EB Design Question
I think a finder of all EB's with the given status is the better approach -
using SB + JDBC, you will still have to either create the EB for
manipulation or manipulate the 'row' using JDBC.
Note that it is not generally recommended to manipulate EB's directly from
the client - better to do the finder from a SFSB and use this bean as a
facade onto the 'next' EB. This approach also works for the pure-JDBC option
- with no changes to the client.
A lot depends on volumes/frequencies/size ...
tim
> -----Original Message-----
> From: Chaganthi, Madhusudan R. [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, June 22, 2000 3:47 PM
> To: [EMAIL PROTECTED]
> Subject: Re: EB Design Question
>
> Chuck
>
>
> What would be sql query which would accomplish the functionality of
> ejbFindNextWithStatus().
>
> I think that method definition is not quite possible with CMP.
>
> The second option seems to be good though its better achieved through a
> SSB+JDBC than a finder on an entity bean.
>
> Am I right ??
>
> Madhu
>
> -----Original Message-----
> From: Chuck Butkus [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 22, 2000 10:17 AM
> To: [EMAIL PROTECTED]
> Subject: Re: EB Design Question
>
>
> You should probably use an entity bean.
>
> You just need to create a finder method to get
> the next row with a certain status
> (e.g. ejbFindNextWithStatus()).
>
> Optionally you could create a finder method to
> get all of the rows with a certain status
> (e.g. ejbFindByStatus()) and then let the client
> choose which entity to update.
>
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Aravind Naidu
> Sent: Wednesday, June 21, 2000 5:03 PM
> To: [EMAIL PROTECTED]
> Subject: EB Design Question
>
>
> Hi,
> I have a design problem with Entity Beans.
>
> I have rows in a database that are flagged with say a status field. These
> rows get filled in nightly with a batch job.
>
> I need to extract via an Entity bean or SSB with JDBC, the NEXT record
> with
> a particular status for the client to manipulate and update it's status.
> How do I do this ?
>
>
> -- Aravind
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
> ==========================================================================
> =
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
This e-mail, and any attachment, is confidential. If you have received it in
error, please delete it from your system, do not use or disclose the
information in any way, and notify me immediately. The contents of this
message may contain personal views which are not the views of the BBC,
unless specifically stated.
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
