Agreed. Using the stored proc presents problems if you use Entity Beans to
access the data. I argue that you don't need the entity beans if you use
stored proces--stored procedures provide much the same encapsulation that an
Entity Bean provides, no? How many layers of encapsulation does a given
project really need, and should the data encapsulation layer be spread
across two (or more) machines?
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: Monday, February 04, 2002 4:37 PM
Subject: Re: [EJB-INT] EJB and Stored-Procedures
> The point I was raising is that you would violate the data encapsulation
that
> the Entity Beans provide, if you use stored procs to access the same data
> (assuming this stored proc is used by some other EJB). This will not make
any
> difference if the stored procs perform read-only operations or doesn't
access
> data maintained by other EBs. But, if they change the data that an entity
bean
> is supposed to provide access to, then you might be in trouble.
>
> -karthik.
>
> Ted Neward wrote:
>
> > 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".
