| Interface | Description |
|---|---|
| oracle.jdbc.pool.OracleConnectionCacheCallback |
Use Oracle Universal Connection Pool instead. Callback functionality for the Implicit Connection Cache
|
| Class | Description |
|---|---|
| oracle.jdbc.pool.OracleConnectionCacheManager |
Use Oracle Universal Connection Pool instead. Connection Cache Manager class for the Implicit Connection Caching Mechanism.
|
| oracle.sql.ARRAY |
Use java.sql.Array interface for declaration instead of using concrete class oracle.sql.ARRAY.
|
| oracle.sql.ArrayDescriptor |
Use factory method OracleConnection.createOracleArray to create an instance of java.sql.Array directly.
|
| oracle.sql.BFILE |
Use oracle.jdbc.OracleBfile interface for declaration instead of using concrete class oracle.sql.BFILE.
|
| oracle.sql.BLOB |
Use java.sql.Blob interface for declaration instead of using concrete class oracle.sql.BLOB.
|
| oracle.sql.CLOB |
Use java.sql.Clob interface for declaration instead of using concrete class oracle.sql.CLOB.
|
| oracle.sql.NCLOB |
Use java.sql.NClob interface for declaration instead of using concrete class oracle.sql.NCLOB.
|
| oracle.sql.OPAQUE |
Use oracle.jdbc.OracleOpaque interface for declaration instead of using concrete class oracle.sql.OPAQUE.
|
| oracle.sql.OpaqueDescriptor |
OPAQUE types cannot be created on the client side.
|
| oracle.sql.REF |
Use java.sql.Ref interface for declaration instead of using concrete class oracle.sql.REF.
|
| oracle.sql.STRUCT |
Use java.sql.Struct interface for declaration instead of using concrete class oracle.sql.STRUCT.
|
| oracle.sql.StructDescriptor |
Use factory method Connection.createStruct to create an instance of java.sql.Struct directly.
|
| Field | Description |
|---|---|
| oracle.jdbc.OracleConnection.CONNECTION_PROPERTY_J2EE13_COMPLIANT |
This property could be removed in the future and the default will be
true. So if this property is used as workaround to turn off compliant behavior, consider changing the application. |
| oracle.jdbc.OracleConnection.CONNECTION_PROPERTY_SET_NEW_PASSWORD | |
| oracle.jdbc.OracleConnection.CONNECTION_PROPERTY_STREAM_CHUNK_SIZE | |
| oracle.jdbc.OracleTypes.TIMESTAMPNS |
since 9.2.0. Use OracleTypes.TIMESTAMP instead.
|
| Method | Description |
|---|---|
| oracle.jdbc.aq.AQEnqueueOptions.setRelativeMessageId(byte[]) | |
| oracle.jdbc.aq.AQEnqueueOptions.setSequenceDeviation(AQEnqueueOptions.SequenceDeviationOption) | |
| oracle.jdbc.dcn.DatabaseChangeEvent.getRegistrationId() |
Use getRegId instead.
|
| oracle.jdbc.dcn.DatabaseChangeRegistration.getRegistrationId() |
This method is deprecated in 11.2. Use
getRegId() instead. |
| oracle.jdbc.OracleCallableStatement.getAnyDataEmbeddedObject(int) |
As of Oracle 11R1 there is full support for ANYTYPE and ANYDATA. Please use oracle.sql.ANYDATA for new code and plan on replacing any use of this method by the next major release. Note that in 11R1 this method is reimplemnted using the ANYDATA support and will now also function in all the drivers, not just oci. In the previous implementation it was possible to call registerOutParameter with a sqlType of either oracle.jdbc.OracleTypes.OPAQUE or oracle.jdbc.OracleTypes.STRUCT The new implemention requires the correct type which is OPAQUE.
|
| oracle.jdbc.OracleCallableStatement.getCustomDatum(int, CustomDatumFactory) | |
| oracle.jdbc.OracleCallableStatement.getOraclePlsqlIndexTable(int) |
since 18.1 Use java.sql.CallableStatement.getObject(int parameterIndex) method.
|
| oracle.jdbc.OracleCallableStatement.getPlsqlIndexTable(int) |
since 18.1. Use java.sql.CallableStatement.getObject(int parameterIndex) method.
|
| oracle.jdbc.OracleCallableStatement.registerIndexTableOutParameter(int, int, int, int) |
since 18.1. Use java.sql.CallableStatement.registerOutParameter (int parameterIndex, int sqlType, String typeName).
|
| oracle.jdbc.OracleCallableStatement.registerOutParameterBytes(int, int, int, int) |
As of Oracle 10g Release 1 all character values are measured in Java chars so this method is no longer supported. It now is the equivalent of calling registerOutParameter with the same args. Since the number of bytes is at least as large as the number of characters this will always work although it may waste memory. Use registerOutParameter with the number of Java chars instead.
|
| oracle.jdbc.OracleCallableStatement.registerOutParameterChars(int, int, int, int) |
As of Oracle 10g Release 1 all character values are measured in Java chars so this method is no longer needed. Call registerOutParameter with the same args instead.
|
| oracle.jdbc.OracleCallableStatement.setExecuteBatch(int) | |
| oracle.jdbc.OracleConnection.archive(int, int, String) |
This method will be removed in a future version.
|
| oracle.jdbc.OracleConnection.clearAllApplicationContext(String) |
This is deprecated since 12.1 in favor of the standard JDBC API setClientInfo(). It is not recommended to use this API intermingled with get/setClientInfo APIs.
|
| oracle.jdbc.OracleConnection.getDefaultExecuteBatch() |
As of 12.1 all APIs related to oracle-style statement batching are deprecated in favor of standard JDBC batching. We recommend using the standard model going forward as it is spec compliant and provides more information and control to the application.
|
| oracle.jdbc.OracleConnection.getEndToEndECIDSequenceNumber() |
This is deprecated since 12.1 in favor of getClientInfo(). It is not recommended to use this API intermingled with get/setClientInfo APIs.
|
| oracle.jdbc.OracleConnection.getEndToEndMetrics() |
This has been deprecated since 12.1 in favor of getClientInfo(). It is not recommended to use this API intermingled with get/setClientInfo APIs.
|
| oracle.jdbc.OracleConnection.getJavaObject(String) | |
| oracle.jdbc.OracleConnection.getSQLType(Object) | |
| oracle.jdbc.OracleConnection.getStmtCacheSize() |
Use getStatementCacheSize() instead.
|
| oracle.jdbc.OracleConnection.getUsingXAFlag() | |
| oracle.jdbc.OracleConnection.getXAErrorFlag() | |
| oracle.jdbc.OracleConnection.oracleSetSavepoint() | |
| oracle.jdbc.OracleConnection.pingDatabase(int) | |
| oracle.jdbc.OracleConnection.prepareCallWithKey(String) |
This is same as prepareCall, except if a Callable Statement with the given KEY exists in the Cache, then the statement is returned AS IT IS when it was closed and cached with this KEY. An object returned from the Cache based on Key will have its state set to "KEYED". If no such Callable Statement is found, then null is returned. Key cannot be null.
|
| oracle.jdbc.OracleConnection.prepareStatementWithKey(String) |
This is same as prepareStatement, except if a Prepared Statement with the given KEY exists in the Cache, then the statement is returned AS IT IS when it was closed and cached with this KEY. An object returned from the Cache based on Key will have its state set to "KEYED". If no such Prepared Statement is found, a null is returned. Key cannot be null.
|
| oracle.jdbc.OracleConnection.registerSQLType(String, Class) | |
| oracle.jdbc.OracleConnection.setApplicationContext(String, String, String) |
This has been deprecated since 12.1 in favour of setClientInfo(). It is not recommended to use this API intermingled with get/setClientInfo APIs.
|
| oracle.jdbc.OracleConnection.setDefaultExecuteBatch(int) |
As of 12.1 all APIs related to oracle-style statement batching are deprecated in favor of standard JDBC batching. We recommend using the standard model going forward as it is spec compliant and provides more information and control to the application.
|
| oracle.jdbc.OracleConnection.setEndToEndMetrics(String[], short) |
It has been deprecated since 12.1 in favor of setClientInfo(). It is not recommended to use this API intermingled with get/setClientInfo APIs.
|
| oracle.jdbc.OracleConnection.setStmtCacheSize(int) |
Use setStatementCacheSize() instead.
|
| oracle.jdbc.OracleConnection.setUsingXAFlag(boolean) | |
| oracle.jdbc.OracleConnection.setXAErrorFlag(boolean) | |
| oracle.jdbc.OracleConnection.startup(String, int) |
This method will be removed in a future version.
|
| oracle.jdbc.OracleConnection.unregisterDatabaseChangeNotification(int, String, int) | |
| oracle.jdbc.OracleDatabaseMetaData.getDriverMajorVersionInfo() |
-- use standard getDriverMajorVersion()
|
| oracle.jdbc.OracleDatabaseMetaData.getDriverMinorVersionInfo() |
-- use JDBC standard method getDriverMinorVersion
|
| oracle.jdbc.OracleDatabaseMetaData.getDriverVersionInfo() |
-- use standard getDriverVersion()
|
| oracle.jdbc.OracleDatabaseMetaData.getLobPrecision() | |
| oracle.jdbc.OracleDriver.isJDK14() | |
| oracle.jdbc.OraclePreparedStatement.getExecuteBatch() |
As of 12.1 all APIs related to oracle-style statement batching are deprecated in favor of standard JDBC batching. We recommend using the standard model going forward as it is spec compliant and provides more information and control to the application.
|
| oracle.jdbc.OraclePreparedStatement.sendBatch() |
As of 12.1 all APIs related to oracle-style statement batching are deprecated in favor of standard JDBC batching. We recommend using the standard model going forward as it is spec compliant and provides more information and control to the application.
|
| oracle.jdbc.OraclePreparedStatement.setCursor(int, ResultSet) | |
| oracle.jdbc.OraclePreparedStatement.setCustomDatum(int, CustomDatum) | |
| oracle.jdbc.OraclePreparedStatement.setExecuteBatch(int) |
As of 12.1 all APIs related to oracle-style statement batching are deprecated in favor of standard JDBC batching. We recommend using the standard model going forward as it is spec compliant and provides more information and control to the application.
|
| oracle.jdbc.OraclePreparedStatement.setPlsqlIndexTable(int, Object, int, int, int, int) |
since 18.1. Use java.sql.PreparedStatement.setObject(int parameterIndex, Object x).
|
| oracle.jdbc.OracleResultSet.getCustomDatum(int, CustomDatumFactory) | |
| oracle.jdbc.OracleResultSet.updateCustomDatum(int, CustomDatum) | |
| oracle.jdbc.OracleStatement.creationState() | |
| oracle.jdbc.OracleStatement.defineColumnType(int, int, int, short) | |
| oracle.jdbc.OracleStatement.defineColumnTypeBytes(int, int, int) | |
| oracle.jdbc.OracleStatement.defineColumnTypeChars(int, int, int) | |
| oracle.jdbc.pool.OracleConnectionCacheCallback.handleAbandonedConnection(OracleConnection, Object) |
Use Oracle Universal Connection Pool instead.
|
| oracle.jdbc.pool.OracleConnectionCacheCallback.releaseConnection(OracleConnection, Object) |
Use Oracle Universal Connection Pool instead.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleDataSource, Properties) |
Use Oracle Universal Connection Pool instead. Creates a connection cache using an auto-generated Connection Cache name, and the supplied Connection Cache Properties. The Connection Cache created is associated with the DataSource Object provided.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.disableCache(String) |
Use Oracle Universal Connection Pool instead. Disable a given connection cache
|
| oracle.jdbc.pool.OracleConnectionCacheManager.enableCache(String) |
Use Oracle Universal Connection Pool instead. Enable a given connection cache
|
| oracle.jdbc.pool.OracleConnectionCacheManager.existsCache(String) |
Use Oracle Universal Connection Pool instead. Check if connection cache exists.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getCacheNameList() |
Use Oracle Universal Connection Pool instead. Get all the cache names managed by this connection cache manager
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getCacheProperties(String) |
Use Oracle Universal Connection Pool instead. Get the connection cache properties corresponding to the cache name.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getConnectionCacheManagerInstance() |
Use Oracle Universal Connection Pool instead. Returns the static ConnectionCacheManager Instance. If necessary a new instance is created and returned to the caller.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getNumberOfActiveConnections(String) |
Use Oracle Universal Connection Pool instead. Get the number of connections already in use (checked out connections)
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getNumberOfAvailableConnections(String) |
Use Oracle Universal Connection Pool instead. Get the number connections in the cache, that are available for use
|
| oracle.jdbc.pool.OracleConnectionCacheManager.getStatistics(String) |
Use Oracle Universal Connection Pool instead. Get the statistics about the implicit connection cache. The stats contains the number of connections opened and the number of connections closed.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.purgeCache(String, boolean) |
Use Oracle Universal Connection Pool instead. Purges Connections in the Connection Cache. A boolean flag indicates whether all connections in the cache are cleaned up(including checkedout connections) or just the connections in the cache
|
| oracle.jdbc.pool.OracleConnectionCacheManager.refreshCache(String, int) |
Use Oracle Universal Connection Pool instead. Refreshes Connections in the Connection Cache.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.reinitializeCache(String, Properties) |
Use Oracle Universal Connection Pool instead. Reinitialize a connection cache using the new set of properties supplied
|
| oracle.jdbc.pool.OracleConnectionCacheManager.removeCache(String, long) |
Use Oracle Universal Connection Pool instead. Removes the Connection Cache, associated with the given Connection Cache Name. When a timeout value is specified, the remove processing pauses for the specified period of time, before proceeding to remove the connection cache.
|
| oracle.jdbc.pool.OracleConnectionCacheManager.setConnectionPoolDataSource(String, ConnectionPoolDataSource) |
Use Oracle Universal Connection Pool instead. Sets the ConnectionPoolDataSource that may be used to create the implicit connection cache. If the connections are already created on the connection cache, then an exception is thrown. If no connections are opened, then the new ConnectionPoolDataSource is used and may overwrite the previous one, if any.
|
| oracle.jdbc.pool.OracleDataSource.close() |
Use Oracle Universal Connection Pool instead.
Close DataSource API. This removes the associated Connection Cache and frees resources. This must be the last method to invoke, after the user is finished using a cache enabled DataSource. |
| oracle.jdbc.pool.OracleDataSource.getConnection(Properties) |
Use Oracle Universal Connection Pool instead.
Attempt to obtain a database connection from the Implicit Connection Cache using Connection Attributes |
| oracle.jdbc.pool.OracleDataSource.getONSConfiguration() |
Use Oracle Universal Connection Pool instead.
Return the ONS configuration string that is used for remote ONS subscription, in the form specified in setONSConfiguration(String). This is used by Fast Connection Failover and Runtime Load Balancing. |
| oracle.jdbc.pool.OracleDataSource.setConnectionCacheProperties(Properties) |
Use Oracle Universal Connection Pool instead.
Setter method to set one or more Implicit Connection Cache properties. If a null value is set, default values will take effect. Below are the list of properties supported. These are the keys (case sensitive) to be used when setting their appropriate values. |
| oracle.jdbc.pool.OracleDataSource.setConnectionCachingEnabled(boolean) |
Use Oracle Universal Connection Pool instead.
Setter method to enable Implicit Connection Caching |
| oracle.jdbc.pool.OracleDataSource.setMaxStatements(int) | |
| oracle.jdbc.pool.OracleDataSource.setONSConfiguration(String) |
Use Oracle Universal Connection Pool instead.
Set the configuration string used for remote ONS subscription. The parameter string closely resembles the content of the ONS configuration file "ons.config", and contains a list of "<name>=<value>" pairs separated by newline character '\n', where <name> can be one of "nodes", "walletfile", or "walletpassword". The parameter string should at least specify the ONS configuration attribute "nodes", as a list of host:port pairs separated by comma ','. SSL would be used when the "walletfile" attribute is specified as an Oracle wallet file. An example ONS configuration string: This is used primarily by Fast Connection Failover and Runtime Load Balancing. |
| oracle.jdbc.pool.OraclePooledConnection.getStmtCacheSize() | |
| oracle.jdbc.pool.OraclePooledConnection.setStmtCacheSize(int) | |
| oracle.sql.BLOB.empty_lob() |
use getEmptyBLOB instead
|
| oracle.sql.BLOB.getBinaryOutputStream() |
This method is deprecated. Use setBinaryStream(1L).
|
| oracle.sql.BLOB.putBytes(long, byte[]) |
This method is deprecated -- use setBytes
|
| oracle.sql.BLOB.trim(long) |
This method id deprecated -- use truncate
|
| oracle.sql.CLOB.empty_lob() |
use getEmptyCLOB instead
|
| oracle.sql.CLOB.getAsciiOutputStream() |
This method is deprecated. Use setAsciiStream( 1L );
|
| oracle.sql.CLOB.getCharacterOutputStream() |
This method is deprecated. Use setCharacterStream( 1L ).
|
| oracle.sql.CLOB.putString(long, String) |
This method is deprecated -- use setString.
|
| oracle.sql.CLOB.trim(long) |
This method is deprecated. Use truncate().
|
| oracle.sql.DatumWithConnection.getConnection() |
since 9.0.0. Use
|
| oracle.sql.StructDescriptor.createDescriptor(SQLName, Connection, boolean, boolean) | |
| oracle.sql.TIMESTAMPLTZ.toBytes(Connection, Time, Calendar) | |
| oracle.sql.TIMESTAMPLTZ.toDate(Connection, byte[], Calendar) | |
| oracle.sql.TIMESTAMPLTZ.toDATE(Connection, byte[], Calendar) | |
| oracle.sql.TIMESTAMPLTZ.toString(Connection, byte[], Calendar) | |
| oracle.sql.TIMESTAMPLTZ.toTime(Connection, byte[], Calendar) | |
| oracle.sql.TIMESTAMPLTZ.toTimestamp(Connection, byte[], Calendar) |
| Constructor | Description |
|---|---|
| oracle.jdbc.OracleDatabaseMetaData(OracleConnection) |
-- Please use the factory method java.sql.Connection.getMetaData()
|
| oracle.jdbc.pool.OracleOCIConnectionPool(String, String, String) | |
| oracle.sql.RAW(Object) |
in 9.2. The behavior of this constructor when passed a String argument will be changed in the next major release after 9.2. There will be no change in the behavior when passed an argument of any other type. The static methods newRAW and oldRAW capture the new and old behavior. It is deprecated only to warn of the impending change in behavior. The deprecation will be removed in the next major release after 9.2. The constructor will remain and will be supported. See release notes for more info.
|
| oracle.sql.TIMESTAMPLTZ(Connection, Time, Calendar) |