I don't know much about the Oracle 9i but in the first question,
it is probably better to try and use the EJB over the stored procedure.
First, the stored procedure will not be portable across DBMS vendors.
Second, you are introducing another language with source tree to
maintain. Third, if your design changes and you wish to perform some
of the functionality outside of the database or you need to access
external resources then there will be more effort required to support
these changes if you have your logic in stored procedures.
>From: Nitin Goyal <[EMAIL PROTECTED]>
>Reply-To: A mailing list for Enterprise JavaBeans development
><[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Fw: EJB Design Issue
>Date: Fri, 16 Feb 2001 11:25:12 +0530
>
>Hi,
>
>Resending for lack of response:
>
>I would like to know the preferreable design strategy in the scenario
>mentioned
>below. Specifically:
>
>
>1. It is possible to encapsulate business logic in an EJB as well as a
>database
>stored procedure. A typical example is HireEmployee, which can be modelled
>as a
>SessionBean or a DB Procedure. Which one is preferrable and why?
>
><vendor>
>2. In the Oracle 9i Architecture, it is possible to deploy the EJBs in the
>iAS
>server or directly in the database. Which is the preferred approcah and
>when?
></vendor>
>
>Regards
>-------------------------------------------------------------------------------
>Nitin Goyal
>Webrizon eSolutions Pvt. Ltd.,
>B-31, Sector 5, Noida-201301
>Uttar Pradesh. INDIA
>Tel (O) : 91.118.4546626/7 extn 245.
>Cell : 91.9810353030
>Tel (R) : 91.118.4451789 (914451789 from Delhi)
>email: [EMAIL PROTECTED]
>-------------------------------------------------------------------------------
>There is no failure except in no longer trying.
>
>===========================================================================
>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".
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.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".
