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.