Both TopLink and Cocobase support stored procedures in their CMP engines. Question is, what app server are you using ? Cocobase is ubiquitous (almost) but TopLink only supports WebSphere and WebLogic (last I used it).
//Nicholas --- Karthikeyan M <[EMAIL PROTECTED]> wrote: > 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". > ===== Nicholas Whitehead Home: (973) 377 9335 Cell: (201) 615 2716 Work(@ JP Morgan): (212) 235 5783 [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.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".
