Best way to execute DML/DDL to Oracle from JAVA?

[prafful]

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?

[Shestakov]

Java code (or java scrips) --> java code on some Java application server like WebLogic, Dynamo, OAS, Jrun(?) --> Oracle database.

Ws have a lot experiences on Java and PL/SQL

[pando]

just make sure dont let the APP Server generate the SQLs!

[prafful]

Any experience with Castor (object to table mapper)?

[Shestakov]

Originally posted by pando
just make sure dont let the APP Server generate the SQLs!

We don't say about which layer generate sql code, but I said about:
what architure we need to have
We can place needed part of sql code in database, if it will be good for application perfomance and that's it.

[pando]

FYI I was pointing to prafful