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
• JDBC Service Provider Extensions

  See Also:

  JDBC Service Provider Extensions
• Enhanced Support for token-based authentication

  See Also:

  Support for Token-Based Authentication for IAM and Support for Token-Based Authentication for Azure AD
• Support for LDAP/LDAPS in the Easy Connect Plus URL

  See Also:

  Support for LDAP and LDAPS
• Support for RADIUS Challenge-Response Authentication

  See Also:

  Support for Challenge-Response Authentication
• Kerberos Authentication Enhancements

  See Also:

  Kerberos Authentication Enhancements
• Support for Kerberos Constrained Delegation

  See Also:

  Support for Kerberos Constrained Delegation
• Support for Pipelined Database Operations

  See Also:

  Support for Pipelined Database Operations
• Support for Data Load Mode in RSI

  See Also:

  About Reactive Streams Ingestion (RSI) Modes
• 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 BOOLEAN Data Type

  See Also:

  Class oracle.jdbc.OracleTypes and Table of Mappings
• 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_ROLLING Operations

  Transaction Guard support for rolling upgrades, using the DBMS_ROLLING package, ensures that commit outcomes are guaranteed across the entire upgrade process.

  See Also:

  Database Development Guide
• Support for Longer Passwords

  Starting with this release, Oracle Database supports passwords up to 1024 bytes in length. In previous releases, the Oracle Database password length was up to 30 bytes. The increased maximum password length provides the following benefits:

  • It accommodates passwords that are used by Oracle Identity Cloud Service (IDCS) and Identity Access Management (IAM). The increase to 1024 bytes enables uniform password rules for all Cloud deployments.
  • The 30-byte limitation was too restrictive when password multi-byte characters used more than 1 byte in an NLS configuration.

  The Oracle Database 23ai JDBC drivers support this increase in the password length.

• 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

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.