Home » SQL & PL/SQL » SQL & PL/SQL » PLSQL - JAVA Integration (Oracle 10g, UNIX)
PLSQL - JAVA Integration [message #308060] Thu, 20 March 2008 23:27
Messages: 2
Registered: March 2008
Location: Malaysia
Junior Member
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.

Previous Topic: SQL Query to create a report
Next Topic: ora-03001 unimplemented feature
Goto Forum:

Current Time: Tue Aug 22 04:24:16 CDT 2017

Total time taken to generate the page: 0.11882 seconds