Have you read NICHOLAS'S replies carefully before writing your comments. I dont think so. Please go through it again.
Sanjay ----- Original Message ----- From: "Ashwani Kalra" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 17, 2002 9:45 AM Subject: Re: Why Ejb? > > No No No ! > ????? > > > > > Does anyone on this list actually use stored > > procedures ? > We have used in in our last project > > > > > When you invoke a stored procedure, it participates in > > the current transaction identically to a dynamic or > > embedded SQL statement. > From where that transaction context comes if I dont use session beans etc > with transaction attributes set. > > (Yes, you can mess it up by > > issuing a commit or a rollback in the SP, but that > > would be silly.) > > If I am not using EJbs , why that would be silly. Where I will commit my > transaction. > > > So, when you start a JTA managed > > transaction, calls to stored procedures are still > > within the context of that transaction. They are not > > subject to different rules. > > > > Moreover, the same goes for security (in most > > databases). SPs do not have any magic security > > override, except that users may have permission to > > issues SP requests, but not have access to the > > underlying tables/views/other SPs. This does not > > affect the security model in J2EE at all. > > What about the role based security which you can set in DD. Say some users > /clients are not allowed to call some fns. By security I dont mean if user > is having right to call particular SP or not. I am talking of higher > level/business level security. > > > > > My new mantra: SQL ISOMORPHIC TO SP > The question is to use SPs or entity ejb not sql or SPs > > > > > > file://Nicholas > > --- Ashwani Kalra <[EMAIL PROTECTED]> wrote: > > > 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". > > > > > > > > > ===== > > 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". > > =========================================================================== 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".
