Seam with Stored Procedures design

[mokua]

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

[stells]

Hello!

I am in a like situation right now. :)

What decision have you made?

[mail.micke]

You could use the SPs with a framework like iBATIS, I don't know enough about hibernate/jpa to comment regarding those frameworks.

- micke

[luxspes]

We are doing this in 2 projects, one uses IBatis mapped to POJOs, and the other uses Spring-Jdbc mapping to java.util.Map, so far I feel that Spring-Jdbc with its JdbcTemplate is more comfortable, specially if your project is small, but IBatis is more maintanable if your project is big, both play nice with Seam using Spring as bridge.

[luxspes]

LOL! Here is the post, this thread and this thread are so similar!

I posted an example of how I call Stored Proces in Seam using Spring as a bridge with Jdbc in that other thread