Changes in This Release for Oracle Database JDBC Developer's Guide
This preface contains:
Changes in Oracle Database 18c
The following are changes in Oracle Database JDBC Developer's Guide for Oracle Database 18c.
New Features
The following features are new in this release:
-
Wallet Support in JDBC for Database Cloud Services
-
Support for Key Store Service
-
Support for HTTP Proxy Configuration
-
Enhanced support for 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
asIN
bind variables -
Support for Lightweight Connection Validation
-
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
-
Support for Verifying JSON Data
Deprecated Features
The following features are deprecated in this release, and may be desupported in a future release:
-
The following APIs from the
OraclePreparedStatement
andOracleCallableStatement
classes have been deprecated as part of enhanced support for Associative Arrays:-
setPlsqlIndexTable
-
setPlsqlIndexTableAtName
-
registerIndexTableOutParameter
-
getOraclePlsqlIndexTable
-
getPlsqlIndexTable
-
-
Concrete classes in the
oracle.sql
packageThe 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 JDBCRowSet
package to replace this feature. -
defineColumnType
methodMost 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
propertySee 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 APIsEndToEndMetrics
related APIs are deprecated in this release.See JDBC DMS Metrics for more information.
Desupported Features
The following features are no longer supported by Oracle:
Desupport of JPublisher
All Oracle JPublisher features are desupported and unavailable in Oracle Database 18c. Oracle recommends that you use the alternatives listed here:
-
To continue to use Web service callouts, Oracle recommends that you use the Oracle JVM Web Services Callout utility, which is a replacement for the Web Services Callout utility.
-
To replace other JPublisher automation capabilities, including mapping user-defined SQL types or SQL types, wrapping PL/SQL packages and similar capabilities, Oracle recommends that developers use explicit steps, such as precompiling code with SQLJ precompiler, building Java STRUCT classes, or using other prestructured options.
See Also:
My Oracle Support Note 1937939.1 for more information about JDeveloper deprecation and desupport:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1937939.1
See Also:
Oracle Database Upgrade Guide to see a list of all desupported features in this release of Oracle Database