But they aren't portable across database vendors so if this is an issue you should avoid stored procedures.
I'm also not sure exactly what "ISOMORPHIC" means in this context. Actually the functionality of stored procedures would comprise a superset of the functionality of plain SQL. For example in Oracle take a look at DBMS_PIPE. >From: Nicholas <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: Re: Why Ejb? >Date: Tue, 16 Jul 2002 14:02:44 -0700 > >No No No ! > >Does anyone on this list actually use stored >procedures ? > >When you invoke a stored procedure, it participates in >the current transaction identically to a dynamic or >embedded SQL statement. (Yes, you can mess it up by >issuing a commit or a rollback in the SP, but that >would be silly.) 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. > >My new mantra: SQL ISOMORPHIC TO SP > >//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". _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.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".
