4 Replies Latest reply on Nov 21, 2008 8:02 PM by Francisco Jose Peredo Noguez

    Seam with Stored Procedures design

    Richard Ombati Newbie

      Hi Everyone,


      The situation looks like this:
      Developing a web-app interface to an Enterprise System currently running as a stand-alone application.
      Most logic is in stored procedures on Oracle db.


      Further,the web interface should interact with the db through the Stored Procedures.


      The options i can think of include:




      • Creating DTOs representing the views in the db

      • Just use Hash maps and Lists to shuttle the data between the view and the db



      Unfortunately, both options don't appear right .


      Any suggestions will be greatly appreciated.


      TIA.


      Richard