Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    6

    Unanswered: PL/SQL - JAVA Integration

    Hi all,

    I am new to Oracle PL/SQL but I am in the mid of producing design plan for a new web-based application (more specifically, back office system). I am thinking of using:

    - Oracle Database
    - Oracle PL/SQL (for batch process)
    - Java Technology (for web tier)

    The reason to decide on PL/SQL and Java for batch processing and web tier is due to the strength of PL/SQL in performance and JAVA as good platform for web layer. Please correct if I am wrong.

    I am urgently require to decide on the technology used for my new application. The followings are my questions and hope that those who have done the similar could advise me:

    1) Do you agree that JAVA is not suitable for batch processing (mostly business logic that performing complex calculation, file download, multiple table updates etc.) due to its poor performance?

    2) What are the recommended (combination of) technologies used for application that rely heavily on batch processes and Web Interface?

    3) Could anyone explain how JAVA integrate (or calling and return result) with PL/SQL?

    Billion Thanks.

    Regards,
    KTT

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It depends.

    As a general rule the web tier (Apache) can not & does not talk to any RDBMS

    Which Application Server do you plan on deploying?

    "Batch Processing" is contentless term. Which is better depends upon what needs to be done. At some tasks Java would be a better choice. For other tasks PL/SQL would be the better choice.

    Java can be written to inter-operate with Oracle, but it is easier said than done.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2008
    Posts
    6
    Quote Originally Posted by anacedent
    It depends.

    As a general rule the web tier (Apache) can not & does not talk to any RDBMS

    Which Application Server do you plan on deploying?

    "Batch Processing" is contentless term. Which is better depends upon what needs to be done. At some tasks Java would be a better choice. For other tasks PL/SQL would be the better choice.

    Java can be written to inter-operate with Oracle, but it is easier said than done.
    Thank you for your comment, anacedent.

    We plan to develop "mission" and "time"-critical application which involving many batch processes (processes require intensive update of tables) such as calculation of fee, update of many tables in single process, generating report while running batch process, or download file and update to tables etc. Basically there is time limit for those processes to be completed before next day. I am using APACHE TOMCAT.

    If you have done the same JAVA-PL/SQL Integration before, kindly share your experience. Thank you.

  4. #4
    Join Date
    Apr 2008
    Posts
    6
    Quote Originally Posted by anacedent
    It depends.

    As a general rule the web tier (Apache) can not & does not talk to any RDBMS

    Which Application Server do you plan on deploying?

    "Batch Processing" is contentless term. Which is better depends upon what needs to be done. At some tasks Java would be a better choice. For other tasks PL/SQL would be the better choice.

    Java can be written to inter-operate with Oracle, but it is easier said than done.
    Thank you for your comment, anacedent.

    We plan to develop "mission" and "time"-critical application which involving many batch processes (processes require intensive update of tables) such as calculation of fee, update of many tables in single process, generating report while running batch process, or download file and update to tables etc. Basically there is time limit for those processes to be completed before next day. I am using APACHE TOMCAT.

    If you have done the same JAVA-PL/SQL Integration before, kindly share your experience. Thank you.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    In my opinion, one of the most significant decisions to be made involves
    where the business rules reside & where they are enforced. The two
    choices are either in the application server (in Java) or in the database
    (in PL/SQL). Both alternatives are "better" choices depending which
    criteria is deemed more important. Either can provide a workable solution.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •