JDBC and UCP

What's New for JDBC and UCP in Oracle Database 11g Release 2

• Ease of Upgrade for Timestamp and Time Zone; LOB Prefetching and Zero-copy I/O for Oracle SecureFiles; Support for Edition Base Redefinition via oracle.jdbc.editionName; Support for Internet Protocol Version 6 (IPv6) addrsses in JDBC URL and machine names that resolve to IPV6 addresses; PreparedStatement.getMetaData() Method; RAC Fast Application Notification API; Universal Connection Pool.

Reminder, New Features for JDBC in Oracle Database 11g Release 1

• Broad Support for JDBC 4.0 Specification; Pre-Fetch in First Roundtrip (Ad Hoc Queries); saves database roundtrips; Programmatic DB Startup & Shutdown; Query Change Notification & Client Result Cache (JDBC-OCI) - Query Annotation; Advanced Security support in JDBC-Thin; Native AQ interface resulting in 40-300% speed up of queue operations wit JDBC.

What's New for UCP in Oracle Database 11g Release 2

• A Single/Universal Connection Pool Supports any type of Java connection: JDBC, JCA, and LDAP; Support or any Database (Oracle, non-Oracle); Support forany App Server (Oracle, non-Oracle); Support for stand-alone deployment (Java SE, BPEL, Toplink, Tomcat); Seamless Integration with RAC and Data Guard; DataGuard Support for Fast Connection Failover (FCF) and Runtime Connection Load Balancing (RCLB); Support for Workload Management (WLM); Connection Affinity to RAC instance and XA Affinity.

To learn more, read the Java Developer's Perspective on Oracle Database 11g white paper.

JDBC Memory Management

Non Intrusive JDBC Tracing

Run java -jar jnettrace.jar <server name> <server port> <local listening port> eg: java -jar jnettrace.jar stade08 9221 8090 then modify the Jdbc program (i.e., URL) to use the same port and host name as above. This will create a client_<hex number>.trc in the local directory which is the client side sqlnet trace. Download jnettrace.jar

JDBC Logging

SSL With Oracle JDBC Thin

Is Your Java Application FailoverProof (i.e., RAC Aware)?