| CARVIEW |
Select Language
HTTP/2 200
content-type: text/html; charset=UTF-8
last-modified: Tue, 15 Jul 2025 01:08:13 GMT
x-oracle-dms-ecid: 006EV4TtBDyFw0KimTXvWJ000IDC004u8W
custom_cache_rule_location: Default
x-oracle-dms-rid: 0:1
device_type: Any
x-content-type-options: nosniff
host_service: FutureTenseContentServer:12c
custom_akamai_autopurge: NO
content-language: en-US
x-akamai-transformed: 9 59616 0 pmb=mRUM,2
vary: Accept-Encoding
content-encoding: gzip
cache-control: max-age=1800
expires: Wed, 16 Jul 2025 19:01:49 GMT
date: Wed, 16 Jul 2025 18:31:49 GMT
content-length: 19187
server-timing: cdn-cache; desc=HIT
server-timing: edge; dur=192
server-timing: origin; dur=0
akamai-request-bc: [a=23.11.215.15,b=2123686,c=g,n=IN_KA_BANGALORE,o=20940],[c=c,n=IN_TN_CHENNAI,o=20940]
akamai-grn: 0.0fd70b17.1752690708.2067a6
set-cookie: akaas_aud-seg-ocom-prod=2147483647~rv=94~id=237f29dbc62c81f27365c20cb206564b; path=/; Secure; SameSite=None
x-frame-options: sameorigin
content-security-policy: frame-ancestors 'self' https://my.oracle.com https://eeho.fa.us2.oraclecloud.com https://blogs.oracle.com *.khapps.com *.khapps.jp *.lsapps.oracle.com *.lsapps.oracle.jp *.dev-lsapps.oracle.com https://oraclesso.sharepoint.com https://oracle.sharepoint.com https://partners.oracle.com https://partners-stage.oracle.com https://partners-test.oracle.com https://partners-sit.oracle.com https://partners-dev.oracle.com
x-content-type-options: nosniff
x-xss-protection: 1
origin-cache-control: no-store
origin-edge-control: NO_HEADER_PRESENTED
actual-object-ttl: -1
server-timing: ak_p; desc="1752690708975_386651919_2123686_19222_12565_3_5_15";dur=1
JDBC Drivers | Oracle
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
JDBC and UCP Capabilities
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. The Oracle JDBC key capabilities that were added over the many releases are listed below.
| Java Standards and Frameworks | Supports JDK8, JDK11, JDK17, JDK19, and JDK21 and implements JDBC 4.2 and JDBC 4.3 by ojdbc17.jar (23.6 onwards), ojdbc11.jar (23ai, 21c), ojdbc10.jar (19c), and ojdbc8.jar (23ai, 21c, 19c). Universal Connection Pool (ucp17.jar, ucp11.jar, ucp.jar) for Java applications, Oracle R2DBC driver v1.1.1 implementing R2DBC SPI, GraalVM Native Image support in the JDBC driver, Virtual Threads (Project Loom), Asynchronous Extension to Universal Connection Pool, JDBC Reactive Extensions - A set of methods that extend the JDBC standard to offer asynchronous database access, and Oracle Cloud Infrastructure Toolkit for IntelliJ v1.0.1 |
| Connection |
Support for multi cloud centralized config providers (Azure, OCI, and WebServer), Support for OCI IAM token authentication, Support for OAUTH2 for DB authentication and Azure AD integration, Support for passwords up to 1024 bytes, Easy Connect Plus for easier TCPS connections and passing connection properties, ojdbc.properties file to set connection properties, multiple ways for setting TNS_ADMIN, setting server's domain name (DN) cert as a connection property, support of new wallet property (my_wallet_directory), and Easy Connect support for LDAPS/LDAP
|
| Performance | Support for Database Pipelining, Support for True Cache, JDBC Standard Batching APIs are enhanced to use database pipeline under the covers, JDBC Reactive Extensions, UCP Reactive Extensions (23ai), Oracle connection manager (CMAN) in traffic director mode (CMAN-TDM), and Improvements to response time with executeBatch() & executeLargeBatch(), and Support for Bequeath (BEQ) protocol |
| Scalability | Support for Directory-based Sharding, Support for Raft Replication, Java Data Source for Sharded Databases Access, UCP support for XA transactions with Oracle Database Sharding, Oracle RAC data affinity, shard routing APIs for mid-tiers, shared pool for multitenant and sharded database, and run time load balancing (RLB) |
| High Availability | Session Migration with AC for Batch and Templates (i.e., stable restorable attributes), Transparent Application Continuity (TAC), Session-State-Stable cursor support, Draining with batches, Support of concrete classes with Application Continuity (AC), AC with DRCP, FAN support, and Transaction Guard (TG) |
| Security | Support for Longer Passwords(1024bytes), Support for Thumbprint based certification selection, Support for RADIUS and RADIUS two-factor authentication, Easy Connect for LDAP/LDAPS, Support for Kerberos Constrained Delegation, Automatic Provider Resolution (OraclePKIProvider), support for Key Store Service (KSS); HTTPS proxy support, TLSv1.2 Support, Kerberos, Oracle Wallets, and JKS |
| Data Types | AI Vector Search and VECTOR datatype support, Native Boolean datatype in oracle.jdbc.OracleType, New Utility methods (getJsonSchema() and isDualityView()) for Duality view support, Support for New JSON Data Type, Accessibility to PL/SQL associative arrays, Oracle REF CURSOR as IN bind parameter. |
| Diagnosability and Observability | Self-driven diagnosability (a single ojdbcX.jar for production, debug, and metrics), Diagnose on first failure (records critical execution state in memory and dumps the recording on error) |
| Open-Source Projects | Config/Resource providers for Azure, OCI and Open Telemetry, Oracle Database Operator for Kubernetes v1.0.0, App Stack for Java v0.1.0, Reactive Streams Ingest (RSI) in Streaming mode and Data Loader mode, OCI Toolkit for Eclipse v1.3.4, and OCI Toolkit for IntelliJ v1.0.1 |
Tutorials
Test Drive Oracle Database 19c in the Cloud
Documentation
- JDBC Developers Guide
- UCP Developers Guide
- Book: Oracle Database Programming Using Java and Web Services by Kuassi Mensah
-
OJVM - Database Embedded JVM (OJVM)
-
Technical Briefs - What’s in Oracle Database 23ai for Java Developers? (PDF) New
- What is in 21c for Java Developers? (PDF)
- Java Performance, Scalability, Availability, Security, and Manageability with Oracle Database 12c Release 2 (12.2.0.1) (PDF)
- Connection Management Strategies for Java applications using JDBC and UCP (PDF)
- Java Programming with Oracle Database 12c RAC and Active Data Guard (PDF)
- Planned/Unplanned downtime & Runtime Load balancing with UCP in WebSphere (PDF)
- Planned/Unplanned downtime & Runtime Load balancing with UCP in Tomcat (PDF)
- SSL With Oracle JDBC Thin Driver (PDF)
Resources
-
Other Product Offerings - Github location for Oracle JDBC Driver Extensions New
- Github location for App Stack for Java
- Github location for IntelliJ Plugin
- Github location for Eclipse Plugin
- Github location for Oracle Database Kubernetes Operator
- Github location for Oracle R2DBC
-
Live Labs - Build GenAI Java Apps with Oracle AI Vector Search, Spring AI, and Cohere New
- Hook Up Telegram Messenger with Spring Boot and Oracle Autonomous Database
- React+SpringBoot+ADB = My Todo Native Cloud App Workshop
- React+Helidon+ADB = Native Cloud App Workshop
- Oracle Database Kubernetes Operator + DevOps LiveLab
-
Other Resources - JDBC Developer Asked Questions (FAQ)
- UCP Frequently Asked Questions (FAQ)
- QuickStart Java applications with Oracle Autonomous Database
- QuickStart Java applications with Oracle Database (On-premises)
Related
-
Blogs - Quick Peek into New Features/Capabilities from Oracle JDBC 23ai New
- What’s in 'Oracle DB 23c Free Developer Release' for Java Developers?
- Oracle Database Operator for Kubernetes on Google Cloud New
- Getting started with Oracle’s official contribution to LangChain4J New
- Retrieval-Augmented Generation (RAG) with LangChain4j, OpenAI, and the Oracle Database 23ai New
- Using Hibernate Vector module with Oracle Vector Data Type and with Oracle AI Vector Search
- A Step-by-Step Guide to OpenTelemetry for Java Developers
- Streamline Java Application Observability with the Oracle JDBC OpenTelemetry Provider
- Getting Started with the Oracle Database 23ai and a Java Microservice using Spring Boot 3, Spring Data JPA, Hibernate
- JSON, Java, and the Oracle Database Part 1 and JSON Datatype and JSON Relational Duality Part 2
- Database CI/CD with the Oracle DB Operator for Kubernetes, GitHub Actions and Liquibase
- SSL Connection to Oracle DB using JDBC, TLSv1.2, JKS or Oracle Wallets (12.2 and lower)
- Follow @KuassiMensah on Medium
- Follow @JuarezJunior on Medium
- Follow @NormanAberin on Medium
- Follow @Nirmala.Sundarappa on Medium