Also, Shouldn't the decision on how the entities handle the data be made carefully when stored procs are involved. Stored procedure is more like a background access to data that an entity bean is supposed to provide uniform access. If a stored procedure alters the data of another entity bean, what will happen the next time someone invokes business methods on the other entity bean? This is more so when optimizations are involved in how the ejbLoad() and ejbStore() are executed.
-karthik. Dmitri Colebatch wrote: > afaik none of the CMP engines around will elt you map to stored procedures, > but I cant see any reason why a BMP entity bean couldn't use them. I'm > assuming that the stored procedures will achieve the same functionality as > insert/update etc. > > the only thing I can think of is that you might find you are forced into > using very coarse entity beans because of the stored procedure setup (I"m > assuming they prevent you from breaking any foreign key constraints etc.). > > my 2c > > cheers > dim > > ----- Original Message ----- > From: "Benoit Aumars" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 12:34 AM > Subject: EJB and Stored-Procedures > > > Hi, > > I hope someone might give me some comments about how a > > stored-procedure can be used with an entity bean. > > > > I have an application which use a database with the following rules : > > 1. no users have an INSERT, UPDATE, or DELETE access into the database. > > 2. put every SQL statement, i.e. INSERT, UPDATE, DELETE, or SELECT, > into > > a > > stored-procedure. > > 3. all stored-procedures are owned by DBO. > > 4. users are only allowed to execute a SELECT statement or > > run/execute a stored-procedure. > > > > Here are my questions : > > a. how to use a stored-procedure with an entity bean ? > > b. the database contains about 125 tables, with about 10 tables > contains > > more > > than 10.000 records. How this can be 'mapped' ? > > > > > > Thanks, > > Benoit Aumars. > > > > > =========================================================================== > > 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".
