JDBC and UCP

In this release, Oracle JDBC implements the JDBC 4.0 specification (but SQLXML) on top of Java SE 6 (i.e., JDK 1.6). The drivers may be used with Java SE 5 (i.e., JDK 1.5) but will not have access to JDBC 4.0 capabilities. Other enhancements include security, perfomance, manageability, etc. To learn more, read the Java Developer's Perspective on Oracle Database 11g white paper.

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

SSL With Oracle JDBC Thin

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

oracle.jdbc.driver package desupport

Interoperability Matrix Database 11.1.0.x Database 10.2.0.x Database 10.1.0.x

Database 9.2.0.x

JDBC 11.1.0.x
Yes
Yes
Yes
Yes
JDBC 10.2.0.x
Yes
Yes
Yes
Yes
JDBC 10.1.0.x
Yes
Yes
Yes
Yes
JDBC 9.2.0.x
Yes
Yes
Yes
Yes
 

Doc, Javadoc, and Book(s)

Universal Connection Pool for JDBC, Developer's Guide

JDBC Developer's Guide and Reference
Javadoc JDBC 11.1.0.6
Javadoc JDBC 10.2.0.1
Javadoc JDBC 10.1.0.2
Javadoc JDBC 9.2.0.5
Oracle Database Programming Using Java and Web Services by Kuassi Mensah

OOW 2007 Presentations
Oracle Database 11g JDBC Pearls
Oracle Database 11g Best Practices
Middleware Strategies for HA in RAC Environments

Technical Information &White Papers
JDBC Drivers, SQLJ and JPublisher Downloads
JDBC Frequently Asked Questions (FAQ) updated with 11.1 features
SSL With Oracle JDBC Thin Driver
JDBC Logging
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

SQLJ

SQLJ is Back!

The initial motivation for desupporting SQLJ was its low adoption by the J2EE commnity however, we found out that it has been largely adopted by database developers. Following numerous complaints, and listening to his customers, Oracle has reverted the SQLJ Desupport decision; we have cancelled the Metalink Desupport Notice. Starting with Oracle Database 10g 10.1.0.4 patch set release, the SQLJ translator has been re-enabled. Customers have also full access to SQLJ functionalities using -sqlj option of the JPublisher utility (releace 10g and onwards).

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


 
Free Download

Left Curve
Learn More
Right Curve
 · Java in the Oracle Database @ Work: Customer Case Studies (PDF)

Left Curve
Sample Code
Right Curve
 · JDBC How-To's
 · JDBC & SQLJ Samples

Left Curve
Discussion Forums
Right Curve
 · OracleJVM and Java Stored Procedures
 · J2EE/OC4J
 · JDBC/SQLJ
 · Web Services

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy