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".
