I like the model Direct Access Objects --> Stored Procedure -->DB because:
1) Generally speaking developers who do nothing but database work are more
likely to code more efficient database access than developers who are
focused on J2EE. This assumes that you have a database group that is
developing the stored procedures.
2) It's not too difficult to write a code generator to generate the DAO
layer from meta data for the stored procedures. I've done this before and
this worked very well. The DAOs can be generated so they free the software
developers from having to know anything about JDBC, SQL, and how to properly
get and release a (pooled) database connection.
3) As of to date, the DAO --> Stored Procedure --> DB model will generally
outperform EJBs that try to accomplish the same thing. If someone has a
counter example that's real and not hypothectical about the performance I
would love to hear it.
4) I find CMP QL to be much more restrictive than SQL. I also find working
with SQL in a stored procedure more straight forward than working with CMP
QL in an XML file.
Ask me if I would use the CMP(EJB)-->DB Architecture or SS Java Beans -->
Stored Procedure --> DB, why the CMP(EJB)-->DB Architecture of course. It's
much cooler to work on. :) Actually, I currently use CMPs for database
updates and DAOs for list retrievals.
my 1c
Danny
----- Original Message -----
From: "Raja, Srinivasan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 31, 2002 1:05 PM
Subject: Re: EJB and Stored-Procedures
> Can one favor
>
> CMP(EJB)--> DB Architecture (or)
>
> SS Java Beans --> Stored Procedure --> DB
>
> or does it vary business component to business component?
>
> Your views pls.
> Sri
>
>
> -----Original Message-----
> From: Ted Neward
> To: [EMAIL PROTECTED]
> Sent: 1/31/02 2:36 PM
> Subject: Re: EJB and Stored-Procedures
>
> How is this any different from normal entity beans? The only difference
> between a normal EB and one using a stored proc is that the stored proc
> will
> be faster about retrieving its data.
>
> Ted Neward
> {.NET || Java} Course Author & Instructor, DevelopMentor
> (http://www.develop.com)
> http://www.javageeks.com/tneward
>
> ----- Original Message -----
> From: "Karthikeyan M" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, January 31, 2002 9:26 AM
> Subject: Re: [EJB-INT] EJB and Stored-Procedures
>
>
> > 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".
> >
> >
>
> ========================================================================
> ===
> 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".
