Best way to execute DML/DDL to Oracle from JAVA?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

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

  1. #1
    Join Date
    Oct 2001
    Posts
    122

    Question

    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?





  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    just make sure dont let the APP Server generate the SQLs!

  4. #4
    Join Date
    Oct 2001
    Posts
    122

    Cool

    Any experience with Castor (object to table mapper)?

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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
  •  



Click Here to Expand Forum to Full Width