Oracle JDBC API Reference
11g Release 2 ("11.2.0.3.0")

Deprecated API


Contents
Deprecated Interfaces
oracle.jdbc.pool.OracleConnectionCacheCallback
          Use Oracle Universal Connection Pool instead. Callback functionality for the Implicit Connection Cache 
 

Deprecated Classes
oracle.jdbc.pool.OracleConnectionCacheManager
          Use Oracle Universal Connection Pool instead. Connection Cache Manager class for the Implicit Connection Caching Mechanism. 
 

Deprecated Fields
oracle.jdbc.OracleTypes.TIMESTAMPNS
          since 9.2.0. Use OracleTypes.TIMESTAMP instead. 
 

Deprecated Methods
oracle.jdbc.OracleConnection.archive(int, int, String)
          This method will be removed in a future version. 
oracle.jdbc.driver.OracleLog.charsToUcs2Bytes(char[], int, int)
          when using jdk 1.4. Use java.util.logging instead. 
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.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.createCache(String, OracleDataSource, Properties)
          Use Oracle Universal Connection Pool instead. Creates a connection cache using the supplied Connection Cache name, and the Connection Cache Properties. The Connection Cache created is associated with the DataSource Object provided. 
oracle.jdbc.OracleStatement.creationState()
            
oracle.jdbc.pool.OracleConnectionCacheManager.disableCache(String)
          Use Oracle Universal Connection Pool instead. Disable a given connection cache 
oracle.sql.BLOB.empty_lob()
          use getEmptyBLOB instead 
oracle.sql.CLOB.empty_lob()
          use getEmptyCLOB instead 
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.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.sql.CLOB.getAsciiOutputStream()
          This method is deprecated. Use setAsciiStream( 1L ); 
oracle.sql.CLOB.getAsciiOutputStream(long)
          This method is deprecated. Use setAsciiStream. 
oracle.sql.BLOB.getBinaryOutputStream()
          This method is deprecated. Use setBinaryStream(1L). 
oracle.sql.BLOB.getBinaryOutputStream(long)
          This method is deprecated -- use setBinaryStream 
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.sql.CLOB.getCharacterOutputStream()
          This method is deprecated. Use setCharacterStream( 1L ). 
oracle.sql.CLOB.getCharacterOutputStream(long)
          This method is deprecated. Use setCharacterStream. 
oracle.sql.DatumWithConnection.getConnection()
          since 9.0.0. Use getJavaSqlConnection() or getInternalConnection(), or Use getOracleConnection() instead. 
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.getConnection(String, String, Properties)
          Use Oracle Universal Connection Pool instead.

Attempt to obtain a database connection from the Implicit Connection Cache using user, passwd and Connection Attributes 

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.OracleCallableStatement.getCustomDatum(int, CustomDatumFactory)
            
oracle.jdbc.OracleResultSet.getCustomDatum(int, CustomDatumFactory)
            
oracle.jdbc.OracleResultSet.getCustomDatum(String, CustomDatumFactory)
            
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.OracleConnection.getJavaObject(String)
            
oracle.jdbc.OracleDatabaseMetaData.getLobPrecision()
            
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.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.dcn.DatabaseChangeEvent.getRegistrationId()
          Use getRegId instead. 
oracle.jdbc.dcn.DatabaseChangeRegistration.getRegistrationId()
          This method is deprecated in 11.2. Use getRegId() instead. 
oracle.jdbc.OracleConnection.getSQLType(Object)
            
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.OracleConnection.getStmtCacheSize()
          Use getStatementCacheSize() instead. 
oracle.jdbc.pool.OraclePooledConnection.getStmtCacheSize()
            
oracle.jdbc.OracleConnection.getUsingXAFlag()
            
oracle.jdbc.OracleConnection.getXAErrorFlag()
            
oracle.jdbc.pool.OracleConnectionCacheCallback.handleAbandonedConnection(OracleConnection, Object)
          Use Oracle Universal Connection Pool instead. 
oracle.jdbc.OracleDriver.isJDK14()
            
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.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.sql.BLOB.putBytes(long, byte[])
          This method is deprecated -- use setBytes 
oracle.sql.BLOB.putBytes(long, byte[], int)
          This method is deprecated -- use setBytes 
oracle.sql.CLOB.putString(long, String)
          This method is deprecated -- use setString. 
oracle.jdbc.pool.OracleConnectionCacheManager.refreshCache(String, int)
          Use Oracle Universal Connection Pool instead. Refreshes Connections in the Connection Cache. 
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.OracleConnection.registerSQLType(String, Class)
            
oracle.jdbc.OracleConnection.registerSQLType(String, String)
            
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.OracleConnectionCacheCallback.releaseConnection(OracleConnection, Object)
          Use Oracle Universal Connection Pool instead. 
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.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.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.OraclePreparedStatement.setCursor(int, ResultSet)
            
oracle.jdbc.OraclePreparedStatement.setCustomDatum(int, CustomDatum)
            
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 "=" pairs separated by newline character '\n', where 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:

      "nodes=host1:4200,host2:4200\nwalletfile=wfile\nwalletpassword=wpwd"
    

This is used primarily by Fast Connection Failover and Runtime Load Balancing.

 
oracle.jdbc.aq.AQEnqueueOptions.setRelativeMessageId(byte[])
            
oracle.jdbc.aq.AQEnqueueOptions.setSequenceDeviation(AQEnqueueOptions.SequenceDeviationOption)
            
oracle.jdbc.OracleConnection.setStmtCacheSize(int)
          Use setStatementCacheSize() instead. 
oracle.jdbc.pool.OraclePooledConnection.setStmtCacheSize(int)
            
oracle.jdbc.OracleConnection.setStmtCacheSize(int, boolean)
          Use setStatementCacheSize() instead. 
oracle.jdbc.pool.OraclePooledConnection.setStmtCacheSize(int, boolean)
            
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.sql.TIMESTAMPLTZ.toBytes(Connection, Date, Calendar)
            
oracle.sql.TIMESTAMPLTZ.toBytes(Connection, DATE, Calendar)
            
oracle.sql.TIMESTAMPLTZ.toBytes(Connection, Time, Calendar)
            
oracle.sql.TIMESTAMPLTZ.toBytes(Connection, Timestamp, Calendar)
            
oracle.sql.TIMESTAMPLTZ.toString(Connection, byte[], Calendar)
            
oracle.sql.BLOB.trim(long)
          This method id deprecated -- use truncate 
oracle.sql.CLOB.trim(long)
          This method is deprecated. Use truncate(). 
oracle.jdbc.OracleConnection.unregisterDatabaseChangeNotification(int)
            
oracle.jdbc.OracleConnection.unregisterDatabaseChangeNotification(int, String, int)
            
oracle.jdbc.OracleResultSet.updateCustomDatum(int, CustomDatum)
            
oracle.jdbc.OracleResultSet.updateCustomDatum(String, CustomDatum)
            
 

Deprecated Constructors
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, Calendar, String)
            
oracle.sql.TIMESTAMPLTZ(Connection, Date, Calendar)
            
oracle.sql.TIMESTAMPLTZ(Connection, DATE, Calendar)
            
oracle.sql.TIMESTAMPLTZ(Connection, String)
            
oracle.sql.TIMESTAMPLTZ(Connection, String, Calendar)
            
oracle.sql.TIMESTAMPLTZ(Connection, Time, Calendar)
            
oracle.sql.TIMESTAMPLTZ(Connection, Timestamp, Calendar)
            
 


Oracle JDBC API Reference
11g Release 2 ("11.2.0.3.0")

Copyright © 1998, 2007, Oracle. All rights reserved.