Akhil Kashyap wrote:Hi
Out of these two, Business logic(BL) in DB(Stored Procedures) or in EJB layer (Java), please guide me which is the best practice and why...?
It always depends upon the business requirement, but if you have multiple tables involve in that particular transaction and also complex business logic at database end then Stored Procedure would be the good choice, otherwise EJB will be fine for the BL!!!
- If you are using multiple databases in a single transaction then EJB will be good for BL.