Changes in This Release for Oracle Database JDBC Developer's Guide
This section contains the changes in this book for Oracle Database Release 23ai.
New Features
This section lists the new features for this release:
Note:
For a complete list of Oracle JDBC driver features, refer to the Feature List section.- Support for Oracle AI Vector Search
See Also:
Working with Vectors - Support for Sessionless Transactions
See Also:
Sessionless Transactions - Support for Jakarta APIs
See Also:
Supported JDK and JDBC Versions - Support for SNI
See Also:
SNI Support for TLS Connections - Support for PEM
See Also:
Support for PEM in JDBC - Support for Caching SSLContext Instance
- Support for Fixed Character Semantic
See Also:
Support for Fixed Character Semantic - JDBC Service Provider Extensions
See Also:
JDBC Service Provider Extensions - Enhanced Support for token-based authentication
- Support for LDAP/LDAPS in the Easy Connect Plus URL
See Also:
Support for LDAP and LDAPS - Support for RADIUS Challenge-Response Authentication
- Kerberos Authentication Enhancements
See Also:
Kerberos Authentication Enhancements - Support for Kerberos Constrained Delegation
- Support for Using Alias and Thumbprint of Certificates
- Performance Enhancement of Standard Update Batching
See Also:
About Processing the Batch - Support for Pipelined Database Operations
- Support for Data Load Mode in RSI
- Support for Annotations
See Also:
Support for Annotations - Support for Oracle True Cache
See Also:
Support for Oracle True Cache - Support for the Bequeath Protocol
See Also:
Support for the Bequeath Protocol - Support for the SQL
BOOLEANData Type - Enhanced, Cloud-Ready Diagnosability Features
See Also:
Diagnosability in JDBC - Support for Multi-Pool DRCP
See Also:
Multi-Pool Support in DRCP - Support for Resumable Cursors with Transparent Application Continuity (TAC)
See Also:
Support for Resumable Cursors - Transaction Guard Support during
DBMS_ROLLINGOperationsTransaction Guard support for rolling upgrades, using the
DBMS_ROLLINGpackage, ensures that commit outcomes are guaranteed across the entire upgrade process.See Also:
Database Development Guide - Support for Enqueue and Dequeue of JSON Array Payload Type
See Also:
Package oracle.sql.json - Support for Passwords of Length 1024 Bytes
See Also:
Support for Longer Passwords - Starting from Oracle Database Release 23ai, connection pooling support is implicitly provided to JDBC applications that do not use connection pools. So, even if your application does not close a connection explicitly, Database Resident Connection Pool (DRCP) servers are automatically assigned to and from an application connection at run time, when the application initiates and completes database operations.
See Also:
Oracle Database Development Guide
Deprecated Features
This section lists the deprecated features in this release.
Deprecation of the JDBC OCI Driver
The JDBC OCI Driver or Type 2 Client Driver, is deprecated in Oracle Database 23ai. Most Java applications that use Open Database Connectivity (ODBC) with Oracle JDBC drivers use the Thin driver. To enable Oracle to allocate resources to better address customer requirements, Oracle is deprecating the JDBC-OCI driver.
Deprecation of Blob, Clob, and BFile Methods
Oracle is deprecating the methods open(), close(), and isClosed() in the interfaces oracle.jdbc.OracleBlob, oracle.jdbc.OracleClob, and oracle.jdbc.OracleBfile.
These methods are replaced with the openLob(), closeLob() and isClosedLob() methods. The method close() conflicts with the type java.lang.AutoCloseable. Removing the proprietary method close() makes it possible for OracleBlob, OracleClob, and OracleBfile interfaces to extend the AutoCloseable interface at some future time. The open() and isClosed() methods will be removed and replaced to maintain rational names for these methods.