The following features are new in this release:

• Wallet Support in JDBC for Database Cloud Services

  See Automatic SSL Connection Configuration

• Support for Key Store Service

  See Support for Key Store Service

• Support for HTTP Proxy Configuration

  See Support for HTTPS Proxy Configuration

• Enhanced support for PL/SQL Associative Arrays

  See Accessing PL/SQL Associative Arrays

• Support for Oracle Connection Manager in Traffic Director Mode

  See Support for Oracle Connection Manager in Traffic Director Mode

• Support for REF CURSOR as IN bind variables

  See Oracle REF CURSOR Type Category

• Support for Lightweight Connection Validation

  See Support for Lightweight Connection Validation

• Support for Transparent Application Continuity

  See Support for Transparent Application Continuity

• Support for concrete classes with Application Continuity

  See Support for Concrete Classes with Application Continuity

• Support for Database Resident Connection Pooling with Application Continuity

  See Application Continuity with DRCP

• Support for Verifying JSON Data

  See Support for Verifying JSON Data

The following features are deprecated in this release, and may be desupported in a future release:

• The following APIs from the OraclePreparedStatement and OracleCallableStatement classes have been deprecated as part of enhanced support for Associative Arrays:

  • setPlsqlIndexTable

  • setPlsqlIndexTableAtName

  • registerIndexTableOutParameter

  • getOraclePlsqlIndexTable

  • getPlsqlIndexTable

• Concrete classes in the oracle.sql package

  The concrete classes in the oracle.sql package are deprecated. Use the new JDBC interfaces instead of these classes.

  See MoS Note 1364193.1 for more information about these interfaces.

• In Oracle Database 12c release 2 (12.2), the oracle.jdbc.rowset package was deprecated. Oracle recommends that you use the Standard JDBC RowSet package to replace this feature.

  See Also:

  http://docs.oracle.com/javase/8/docs/api/javax/sql/rowset/package-summary.html

• defineColumnType method

  Most of the variants of the defineColumnType method are deprecated. The supported variants are for:

  • LOB to LONG conversions

  • Configure the LOB prefetch size

  See the JDBC Javadoc for more information.

• CONNECTION_PROPERTY_STREAM_CHUNK_SIZE property

  See the JDBC Javadoc for more information.

• Oracle Update Batching

  Oracle update batching was deprecated in Oracle Database 12c Release 1 (12.1). Since Oracle Database 12c Release 2 (12.2), Oracle update batching is a no operation code (no-op). This means that if you implement Oracle update batching in your application, using the Oracle Database 18c JDBC driver, then the specified batch size is not set and results in a batch size of 1. With this batch setting, your application processes one row at a time. Oracle strongly recommends that you use the standard JDBC batching if you are using the Oracle Database 18c JDBC driver.

  See Standard Update Batching section for more information.

• EndToEndMetrics related APIs

  EndToEndMetrics related APIs are deprecated in this release.

  See JDBC DMS Metrics for more information.

The following features are no longer supported by Oracle: