Hi Folks,

What in your opinion is the best way to execute DML/DDL for oracle from JAVA code in web based application?

We have been using two different architecture for above scenario.

1) Front end Java (object)--> middle tier top link (object - relational mapping) --> back end Oracle (Relation database)

2) Front end Java (object)--> PLSQL --> back end Oracle (Relation database)

We have experienced that PL/SQL store procedure gives best
performance.

Any related experiences/ideas to share?