High-Performance Oracle JDBC Programming

Date Added: Apr 2009
Format: HTML

The performance of Oracle-driven JDBC programs can be improved by controlling connection and statement pooling features. These pooling techniques such as connection pooling and statement pooling can help in advancing the performance of database-intensive applications since it allows the reuse of objects. The application need to work together with the database severely, regularly re-establishing connections with the same parameters. Connection pooling and statement pooling discussed in this paper are methods for improving the application performance. The performance of data-intensive Java DataBase Connectivity (JDBC) programs interacting with Oracle Database via the Oracle JDBC thin drive can be improved by taking advantage of pooling connections and statements. The Oracle Universal Connection Pool (UCP) for JDBC offers full-features connection pool execution for caching JDBC connections. It also supports JDBS 4.0 high-availability and performance features including pool refreshing and connection validating, which are not related to Oracle Real Application Clusters. UCP also provides the ability to authenticate connections on borrow. Discussed in this paper is the set of properties provided by UCP JDBC connection pool that can optimize pooling behavior. Oracle UCP for JDBC is offered with various features that provide a connection pool implementation for caching JDBS connections. It talks about taking advantage of statement pooling making use of features related to Oracle's JDBS drivers and JDBC 4.0 methods added to the Statement interface.