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

Reply via email to