Develop Java applications with Oracle Database

Develop Java applications with Oracle Database

Using JDBC, the Universal Connection Pool (UCP) and the embedded JVM (OJVM) through technical articles, white papers, code samples, FAQs and more.

Show Me How

Getting Started with JDBC

Connect to ATP with JDBC

Database Embedded JVM (OJVM)

Database Embedded JVM (OJVM)

 

JDBC Benefits

Whether on the cloud or on-premises, developing Java applications with Oracle Autonomous Databases is fast and simple. Java developers can take advantage of the latest features, such as Oracle Autonomous Database, performance self-tuning, high availability, in-memory processing, and pluggable databases to design and develop a high performant, scalable, and reliable applications. Oracle Database 19c  and 18c JDBC drivers introduce a new property file (ojdbc.properties) along with few other features that simplifies the connection to Autonomous Transaction Processing (ATP) and Autonomous Data Warehousing (ADW).

Java Standards Supports JDK8, JDK9, JDK10, JDK11 and compliant to JDBC 4.2 by JDBC driver (ojdbc8.jar and ojdbc10.jar (19c only)) and Universal Connection Pool (ucp.jar)
Performance Reactive Streams Ingest (RSI) for streaming data into the Oracle DB (19c feature), Oracle connection manager in traffic director mode, Universal Connection Pool (UCP), statement caching, network compression, light weight connection validation and more
High Availability Transparent Application Continuity (TAC), support of concrete classes with Application Continuity (AC), AC with DRCP, FAN support, and Transaction Guard (TG)
Scalability Oracle RAC data affinity, sharding APIs, shared pool for multitenant and sharded database, shard routing APIs for mid-tiers, and run time load balancing (RLB)
Data Types Accessibility to PL/SQL associative arrays, REF CURSOR as IN bind variable, API for verifying JSON column
Connection and Security Easyconnect URL enhancements for easier TCPS connections and for passing connection properties, supporting a file (e.g., ojdbc.properties) to set connection properties, multiple ways to set TNS_ADMIN (e.g., part of connection URL, connection property, environment variable), setting server's domain name (DN) cert as a connection property, automatic provider resolution for OraclePKIProvider, automatic key store service (KSS) resolution, HTTPS proxy support, TLSv1.2 Support, Kerberos, Oracle Wallets, and JKS
Test Drive Oracle Database 19c in the Cloud