Java database interaction mechanism

Abstract: This document describes on a unique mechanism and process that enable to make use of Oracle references cursors in Java Database programming in developing highly scalable businessapplications with greater performance.
About the Author: Ravi Kumar Buragapu is a Technical Lead in Wipro Technologies. His interest in IT led him from his Ph.D. in Electronics to object-oriented programming,and then to distributed computing and software architecture.
“This document is confidential. The information contained herein is not to be distributed, revealed or disseminated outside to any companyor any other party without the prior expressed consent and written permission of the Author, buragapuravi@yahoo.com”
Ravi Kumar B Page 1 1/20/2005
A white paper on Java Database InteractionMechanism
CONTENTS
Introduction ……………………………………………………………………..…3
Purpose ……………………………………………………………….……………….…3
Synopsis …………………………………………………………………………..……..3
Database Interaction Mechanism………………………………………..…….4
Conclusion …………………………...……………………………………………..….8
Ravi Kumar B Page 2 1/20/2005
A white paper on Java Database Interaction Mechanism
Introduction
The conventional approaches in performing Database operations in Java throughStatement and Prepared Statement etc. are not scalable when they require performing complex Database operations on huge data.
Even though the standard database interaction mechanisms uses the connectionpooling, the connection objects are not persistent, this leads creation of the Prepared Statement in each Database request by sending the complete SQL’s and their associated parameters to the Database.In order to provide solutions to the aggressive business needs it is requiring process large and complex Database operations through huge Databases.
The bets solution to the emerging business needswhich require to perform huge data transfer through complex Database operations will be through Oracle Stored Procedure with Callable Statements. This approach...