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".
