> I think you need to define what you mean by SPs. If > the SPs have [business] logic built into them, I > suppose this may obviate/interfere with the > implementation of Entity beans.
Why mixing such type of SPs with entity beans. There is no such need. They can be used with session beans as it is. > > However, at their base structure, SPs can simply > replace standard SQL, either in declarative bean > managed persistence or CMP. Why do you want to replace well tested SPs with SQL. I dont find any wisdom in it. > There is no reason why CMP > cannot use stored procedures, and in some cases, may > benefit from doing so, portability set aside. You are creating Entity beans and using SPs when entity beans alone can do the task. Why to introduce more complexity. You can call SPs with in the call back fn. or any business fn. No body is stopping you. But whats the gain ?? > > My basic assertion is that SPs are simply an > architectural and syntactical alternative to embedded > or dynamic SQL. That is to say, they can do the same > things (Create, Read, Update, Delete). ?? > On that basis, what's the quibble ? > > file://Nicholas > > --- Vikram Naik <[EMAIL PROTECTED]> wrote: > > SO to conclude... > > If we have SPs already defined we shouldn't > > go for ENTITY BEANS > > !!!!!!!!!!!!! > > > > > > > > Vikram Naik > > > > > > -----Original Message----- > > From: A mailing list for Enterprise JavaBeans > > development > > [mailto:[EMAIL PROTECTED]]On Behalf Of > > Ashwani Kalra > > Sent: Tuesday, July 16, 2002 3:37 PM > > To: [EMAIL PROTECTED] > > Subject: Re: Why Ejb? > > > > You will have to use wrapper/facade in SLSB/SFSB > > from which you can take > > advanatage of the transactions and security. You can > > manage the transaction > > in SPs also and propagate errors to the session bean > > methods. > > Scalability issue will then shift to session beans. > > > > ----- Original Message ----- > > From: "Vikram Naik" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, July 16, 2002 3:46 PM > > Subject: Re: Why Ejb? > > > > > > > Hi, > > > Thanks for the quick reply... > > > Apart from getting generated SQL's what > > about the transactions > > and > > > scalability ???? > > > > > > Vikram Naik > > > > > > > > > -----Original Message----- > > > From: A mailing list for Enterprise JavaBeans > > development > > > [mailto:[EMAIL PROTECTED]]On Behalf Of > > Ashwani Kalra > > > Sent: Tuesday, July 16, 2002 3:19 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: Why Ejb? > > > > > > Two reasons : > > > 1.EJB(cmp) makes code independent of the Database. > > > 2. You dont have to code sql queries for > > inserting/updating etc. > > > > > > If you already have Sps then you can completely > > avoid Entity EJBs and use > > > DAO to call SPs. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > Cheers > > > Ashwani Kalra > > > http://www.geocities.com/ashwani_kalra/ > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > > > > ----- Original Message ----- > > > From: "Vikram Naik" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, July 16, 2002 3:22 PM > > > Subject: Why Ejb? > > > > > > > > > > Hello All, > > > > > > > > Why should we opt of EjBs when stored procedures > > can give us better > > > > performance? > > > > > > > > Your opinions will be highly appreciated. > > > > > > > > Thanks & Regards, > > > > Vikram Naik > > > > > > > > > > > > > > =========================================================================== > > > > 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". > > > > > > > > =========================================================================== > > 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". > > > > > ===== > Nicholas Whitehead > Home: (973) 377 9335 > Cell: (201) 615 2716 > Work: (212) 622 5639 > [EMAIL PROTECTED] > > __________________________________________________ > Do You Yahoo!? > Yahoo! Autos - Get free new car price quotes > http://autos.yahoo.com > > =========================================================================== > 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".
