Re: Where should the business logic reside in the beans or in

A stored procedure seems logical, as long as both operations are done within a transaction!

--Olu E.

Seigmund Akinwande Johnson wrote:
>
> I am currently deploying a web based app which requires some business logic
> and database, I would like to know how to determine where the business logic
> resides.
>
> Example
>
> If a customer withdraws more that X amount of dollars from an account insert
> a record which contains
> the customer id and the amount, into another table, this requires calls to
> the database.
>
> Now my question is should I write a stored procedure to do everything in
> one call
> ( hence business logic is in the database) or use Java objects in a
> middleware which will call the stored procedures separately, so the business
> logic is in the stored procedure.
>
> I am completely database oriented and feel strongly about making this in
> one network trip instead of
> having the business logic in the middleware and making 2 separate calls.
>
> --
> Developer
> BSDIS
> 773-834-2652
Received on Sat Nov 06 1999 - 05:28:25 CST