Thanks for the posting William - could you be so kind and share Mr. Weedon's
solution here. I couldn't finf this in the inprise newsgroup.
Thanks.
-----Original Message-----
From: Louth, William (Exchange) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 12:58 PM
To: [EMAIL PROTECTED]
Subject: Re: Who is generating the key when you are using CMP?
Hi Subu,
On the Inprise Application Server (IAS) newsgroup there is a post from
Jonathan Weedon on how to solve this problem in a relatively clean manner.
news://newsgroups.borland.com/inprise.public.appserver Re: oracle's seuence
and cmp entity beans - "Jonathan K. Weedon" , 13 Apr 2000
kind regards,
William Louth
> -----Original Message-----
> From: Vdaygiri, Subu [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 25, 2000 5:36 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Who is generating the key when you are using CMP?
>
> I am having similar problem as yours. Any solution for CMP beans using
> sequences from Oracle for primary key ?
>
> > -----Original Message-----
> > From: Lars Hagrot [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, April 25, 2000 2:23 PM
> > To: [EMAIL PROTECTED]
> > Subject: Who is generating the key when you are using CMP?
> >
> >
> > When you build a real system ( not a tutorial) you will recognize the
> > problem below.
> >
> > If you have an Entity Bean and use CMP there must always be a unique
> > key. Where does it come from?
> >
> > 1) from the "user" (and passed as parameter to the create method)?
> > 2) from the EJB-Container or some Session bean (how does it know it is
> > unique)?
> > 3) from the database ( for example "max(col)" or "identity")?
> >
> > In 1) and 2) you can assign the key in the create method.
> > But in 3) you must do a query or insert a row to get the key but how
> > can I tell the Container do do that. I am supposed to assign
> > the key in
> > the create method.
> >
> > Is there any standards for this problem?
> > Does this imply that example 3) must be implemented as BMP?
> >
> > What is the best solution if it has to be scalable and shall work with
> > cluster of EJB-Servers?
> >
> > Regards
> >
> > Lars Hagrot
> >
> > --
> > Lars Hagrot E-mail: [EMAIL PROTECTED]
> > Object Technology Mentoring Phone: +46 8 50714409
> > Enea Data AB Fax: +46 8 658 57 90
> > Hornsgatan 166
> > S-117 28 Stockholm
> > Sweden
> >
> > ==============================================================
> > =============
> > 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".
***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************
===========================================================================
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".
