JDBC and UCP

OOW 2012: What is New for JDBC and UCP with the latest Oracle database technology? See and register for sessions, hand-on labs where you can learn and practice http://db360.blogspot.com/2012/09/my-guide-for-oracle-openworld-2012.html

• 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.

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)?

Javadoc, and Book(s)
	UCP Transition Guide (pointer to UCP doc in right pane)
	Javadoc JDBC 11.2.0.1
	Javadoc JDBC 11.1.0.6
	Javadoc JDBC 10.2.0.1
	Javadoc JDBC 10.1.0.2
	Oracle Database Programming Using Java and Web Services by Kuassi Mensah

Technical Information &White Papers
	JDBC Drivers, SQLJ and JPublisher Downloads
	JDBC Frequently Asked Questions (FAQ) updated with 11.2 features
	JDBC Memory Management
	SSL With Oracle JDBC Thin Driver
	JDBC Logging
	Application Failover in Oracle Database 11g
	Java and Web Services Developer’s Perspective on Oracle Database 10g
	Connecting the Java World to Grid-Enabled Databases (article)
	Best of Breed JDBC Drivers for J2EE Web Services and the Grid (Technical Whitepaper PDF)
	Keep Your Connections (article)
	Oracle Database 10g JDBC Developer's Guide

Back to the main Java DB, JDBC and Database Web Services page