Hi All !

Let us say I have a SQLJ Java application and there is unit of work that does 50,000 SELECT statements, and 10,000 INSERT statements.
I need to determine if the unit of work (UOW) should be performed using code executing on the application server (WebSphere Application Server) , or should it be executing code on the database server, using a stored procedure.
I would be interested in knowing how others have dealt with this architectural decision. Do you make a high level decision that dictates where the database access logic resides ? Or Do you make the decision as per the UOW requirement ? small UOW - application server will do, large UOW - database server.

Thanks
Anil

An appliction server deals with the transactions. IMO it is not meant to perform set-oriented batch processes with long UOWs, but for short-duration UOWs (on individual objects). So yes, I follow this guide: I am also interested in knowing how others deal with this.