-
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?
-
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
-
just make sure dont let the APP Server generate the SQLs!
-
Any experience with Castor (object to table mapper)?
-
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.
-
FYI I was pointing to prafful
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|