Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


oracle.jdbc
Interface OracleConnection

All Superinterfaces:
java.sql.Connection, java.sql.Wrapper
All Known Implementing Classes:
OracleConnectionWrapper

public interface OracleConnection
extends java.sql.Connection

This interface defines the Oracle extensions to the standard JDBC interface java.sql.Connection. You can use java.sql.Connection in your application where you do not make use of the Oracle extensions. However, when your application uses the Oracle extensions to java.sql.Connection you must use oracle.jdbc.OracleConnection.

OracleConnection extends standard JDBC connection functionality to create and return Oracle statement objects, set flags and options for Oracle performance extensions, and support type maps for Oracle objects.

Basic example : Once you connect to the database and, in the process, create your Connection object (see OracleDriver), the next step is to create a Statement object. The createStatement method of your JDBC Connection object returns an object of the JDBC Statement type.
Here is an example of how to create the Statement object (conn being your connection object):

Statement stmt = conn.createStatement();

Note that there is nothing Oracle-specific about this statement; it follows standard JDBC syntax.

Since:
8.1.7

Nested Class Summary
static class OracleConnection.CommitOption
           
static class OracleConnection.DatabaseShutdownMode
           
static class OracleConnection.DatabaseStartupMode
           

 

Field Summary
static int ABANDONED_CONNECTION_CALLBACK
           
static byte ACCESSMODE_BOTH
           
static byte ACCESSMODE_JAVAPROP
           
static byte ACCESSMODE_SYSTEMPROP
           
static int ALL_CONNECTION_CALLBACKS
           
static int CACHE_SIZE_NOT_SET
           
static java.lang.String CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT
          When using Oracle style batching, JDBC determines when to flush a batch to the database.
static byte CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_AUTOCOMMIT
          Use this connection property to change the default value of autoCommit.
static byte CONNECTION_PROPERTY_AUTOCOMMIT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_AUTOCOMMIT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_COMMIT_OPTION
          This connection property lets you define a default commit option that will be used when calling connection.commit();.
static byte CONNECTION_PROPERTY_COMMIT_OPTION_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_COMMIT_OPTION_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS
          Convert NCHAR literals to Unicode literals when equal "true".
static byte CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME
          The user has to provide fully qualified ADT name ([username].[adt name]) for all ADT operations.
static byte CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DATABASE
           
static byte CONNECTION_PROPERTY_DATABASE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DATABASE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH
          The value of this property is used as the default batch size when using Oracle style batching.
static byte CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE
          The value of this property is used as the default LOB prefetch size for this connection.
static byte CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH
          The value of this property is used as the default number of rows to prefetch.
static byte CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_USE_NIO
          In case of Jdbc-OCI drivers the data is copied from C layer to Java using Jni array copy api.
static byte CONNECTION_PROPERTY_DEFAULT_USE_NIO_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DEFAULT_USE_NIO_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DEFAULTNCHAR
          If the value of this property is "true", the default mode for all character data columns will be NCHAR.
static byte CONNECTION_PROPERTY_DEFAULTNCHAR_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DEFAULTNCHAR_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE
          Disable the method OracleStatement.defineColumnType when equal "true".
static byte CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE
          The value passed to the server for the OCI_ATTR_DRIVER_NAME.
static byte CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_EDITION_NAME
          This connection property can be used to specify a name for the "application edition" which will then appear in the database in the 'USERENV' context.
static byte CONNECTION_PROPERTY_EDITION_NAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_EDITION_NAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_FIXED_STRING
          If the value of this property is "true", JDBC will use FIXED CHAR semantic when setObject is called with a String argument.
static byte CONNECTION_PROPERTY_FIXED_STRING_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_FIXED_STRING_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_INCLUDE_SYNONYMS
          If the value of this property is "true", JDBC will include synonyms when getting information about a column.
static byte CONNECTION_PROPERTY_INCLUDE_SYNONYMS_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_INCLUDE_SYNONYMS_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_INTERNAL_LOGON
          The value of this property is used as the user name when performing an internal logon.
static byte CONNECTION_PROPERTY_INTERNAL_LOGON_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_INTERNAL_LOGON_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_J2EE13_COMPLIANT
          If the value of this property is "true", JDBC uses strict compliance for some edge cases.
static byte CONNECTION_PROPERTY_J2EE13_COMPLIANT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_J2EE13_COMPLIANT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP
          This connection property lets you define how the driver will map SQL DATE values in the database to Java types.
static byte CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE
          The size in bytes of the largest internal char or byte data buffer that the driver should cache.
static byte CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_OCI_DRIVER_CHARSET
           
static byte CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_OCI_ENV_HANDLE
           
static byte CONNECTION_PROPERTY_OCI_ENV_HANDLE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_OCI_ENV_HANDLE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_OCI_ERR_HANDLE
           
static byte CONNECTION_PROPERTY_OCI_ERR_HANDLE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_OCI_ERR_HANDLE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE
           
static byte CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_OCIDLL
          Set the name of the native library for the oci driver.
static byte CONNECTION_PROPERTY_OCIDLL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_OCIDLL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_PASSWORD
          The value of this property is used as the password when connecting to the database.
static byte CONNECTION_PROPERTY_PASSWORD_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_PASSWORD_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_PRELIM_AUTH
          If this property is set to "true", JDBC drivers connect in PRELIM_AUTH mode, which is the only mode that is permitted when the database is down.
static byte CONNECTION_PROPERTY_PRELIM_AUTH_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_PRELIM_AUTH_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_PROCESS_ESCAPES
          If the value of this property is "false" then the default setting for Statement.setEscapeProccessing is false.
static byte CONNECTION_PROPERTY_PROCESS_ESCAPES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_PROCESS_ESCAPES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_PROTOCOL
           
static byte CONNECTION_PROPERTY_PROTOCOL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_PROTOCOL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_PROXY_CLIENT_NAME
          The value of this property is used to specify the name of the proxy client during proxy authentication.
static byte CONNECTION_PROPERTY_PROXY_CLIENT_NAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_PROXY_CLIENT_NAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_REPORT_REMARKS
          If the value of this property is "true", OracleDatabaseMetaData will include remarks in the meta data.
static byte CONNECTION_PROPERTY_REPORT_REMARKS_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_REPORT_REMARKS_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_RESOURCE_MANAGER_ID
           
static byte CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_RESTRICT_GETTABLES
          If the value of this property is "true", JDBC will return a more refined value for DatabaseMeta.getTables.
static byte CONNECTION_PROPERTY_RESTRICT_GETTABLES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_RESTRICT_GETTABLES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR
          This is applicable only for the thin driver.
static byte CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_SERVER
           
static byte CONNECTION_PROPERTY_SERVER_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_SERVER_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY
          If the value of this property is "true", the JDBC PreparedStatement setFloat and setDouble API's convert float and double values to the internal binary format for BINARY_FLOAT or BINARY_DOUBLE before sending to the database.
static byte CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_SET_NEW_PASSWORD
          Property which sets enables the user to set a new password during connection.
static byte CONNECTION_PROPERTY_SET_NEW_PASSWORD_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_SET_NEW_PASSWORD_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_STREAM_CHUNK_SIZE
          Stream chunk size for input streams.
static byte CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE
           
static byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL
           
static byte CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL
           
static byte CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION
           
static byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS
           
static byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL
           
static byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME
          Use this connection property to specify the location of the Kerberos credential cache.
static byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL
          To turn on Kerberos mutual authentication, set this property to "true".
static byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES
          Use this connection property to turn on the authentication adaptors.
static byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL
          Use this property to specify the level of security for the integrity service.
static byte CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES
          Use this connection property to specify the list of integrity algorithms that you want to activate.
static byte CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT
           
static byte CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED
          Use this connection property to specify the encryption seed (between 10 and 70 random characters).
static byte CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK
          Thin uses out of band breaks by default from 11g onwards.
static byte CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL
          Use this property to specify the level of security for the encryption service.
static byte CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES
          Use this connection property to specify the list of encryption algorithms that you want to activate.
static byte CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX
           
static byte CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_PROFILE
           
static byte CONNECTION_PROPERTY_THIN_NET_PROFILE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_PROFILE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO
          The thin driver uses the zero-copy IO codepath for SecureFile Lobs by default from 11gR2 onwards.
static byte CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_READ_TIMEOUT
          Read timeout while reading from the socket.
static byte CONNECTION_PROPERTY_THIN_READ_TIMEOUT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_READ_TIMEOUT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES
           
static byte CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM
           
static byte CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH
           
static byte CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM
           
static byte CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_VERSION
           
static byte CONNECTION_PROPERTY_THIN_SSL_VERSION_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_SSL_VERSION_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_TCP_NO_DELAY
          If the value of this property is "true", the TCP_NODELAY property is set on the socket when using the Thin driver.
static byte CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_ENAME
           
static byte CONNECTION_PROPERTY_THIN_VSESSION_ENAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_ENAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_INAME
           
static byte CONNECTION_PROPERTY_THIN_VSESSION_INAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_INAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_MACHINE
          Use this connection property to change the value that will show up in the "machine" column of the "v$session" table for this connection.
static byte CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_OSUSER
          By default, the driver retrieves the OS username from the "user.name" system property which is set by the JVM.
static byte CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROCESS
          Use this connection property to change the value that will show up in the "process" column of the "v$session" table for this connection.
static byte CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM
          Use this connection property to change the value that will show up in the "program" column of the "v$session" table for this connection.
static byte CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL
          Use this connection property to change the value that will show up in the "terminal" column of the "v$session" table for this connection.
static byte CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT
          Obtain TIMESTAMP WITH TIME ZONE value in GMT than adjusting the same to local time zone.
static byte CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME
          setTime used to set the date component to 01 Jan, 1900 by default in earlier versions (version < 10g).
static byte CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN
          If the value of this property is "true", then JDBC will prefetch rows even though there is a LONG or LONG RAW column in the result.
static byte CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE
          If true, the statement data buffers are cached on a per thread basis.
static byte CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_USER_NAME
          The value of this property is used as the user name when connecting to the database.
static byte CONNECTION_PROPERTY_USER_NAME_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_USER_NAME_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_WALLET_LOCATION
          Use this property to specify the wallet location.
static byte CONNECTION_PROPERTY_WALLET_LOCATION_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_WALLET_LOCATION_DEFAULT
           
static java.lang.String CONNECTION_PROPERTY_WALLET_PASSWORD
          Use this property to set the wallet password which is only required if you don't enable enable auto-login in the wallet.
static byte CONNECTION_PROPERTY_WALLET_PASSWORD_ACCESSMODE
           
static java.lang.String CONNECTION_PROPERTY_WALLET_PASSWORD_DEFAULT
           
static int CONNECTION_RELEASE_HIGH
           
static int CONNECTION_RELEASE_LOCKED
           
static int CONNECTION_RELEASE_LOW
           
static int DATABASE_CLOSED
          Define return values for pingDatabase api The physical database connection is closed.
static int DATABASE_NOTOK
          Define return values for pingDatabase api The physical database connection is not closed but the database is not reachable.
static int DATABASE_OK
          Define return values for pingDatabase api The physical database connection is not closed and the database is reachable.
static int DATABASE_TIMEOUT
          Define return values for pingDatabase api The call timed out before any positive or negative acknowledgement was received.
static java.lang.String DCN_BEST_EFFORT
           
static java.lang.String DCN_IGNORE_DELETEOP
           
static java.lang.String DCN_IGNORE_INSERTOP
           
static java.lang.String DCN_IGNORE_UPDATEOP
           
static java.lang.String DCN_NOTIFY_CHANGELAG
           
static java.lang.String DCN_NOTIFY_ROWIDS
           
static java.lang.String DCN_QUERY_CHANGE_NOTIFICATION
           
static int END_TO_END_ACTION_INDEX
           
static int END_TO_END_CLIENTID_INDEX
           
static int END_TO_END_ECID_INDEX
           
static int END_TO_END_MODULE_INDEX
           
static int END_TO_END_STATE_INDEX_MAX
           
static int INVALID_CONNECTION
          Values used for close(int).
static java.lang.String NTF_AQ_PAYLOAD
           
static int NTF_DEFAULT_TCP_PORT
           
static java.lang.String NTF_GROUPING_CLASS
           
static java.lang.String NTF_GROUPING_CLASS_NONE
           
static java.lang.String NTF_GROUPING_CLASS_TIME
           
static java.lang.String NTF_GROUPING_REPEAT_FOREVER
           
static java.lang.String NTF_GROUPING_REPEAT_TIME
           
static java.lang.String NTF_GROUPING_START_TIME
           
static java.lang.String NTF_GROUPING_TYPE
           
static java.lang.String NTF_GROUPING_TYPE_LAST
           
static java.lang.String NTF_GROUPING_TYPE_SUMMARY
           
static java.lang.String NTF_GROUPING_VALUE
           
static java.lang.String NTF_LOCAL_HOST
           
static java.lang.String NTF_LOCAL_TCP_PORT
           
static java.lang.String NTF_QOS_PURGE_ON_NTFN
           
static java.lang.String NTF_QOS_RELIABLE
           
static java.lang.String NTF_TIMEOUT
           
static java.lang.String PROXY_CERTIFICATE
           
static java.lang.String PROXY_DISTINGUISHED_NAME
           
static java.lang.String PROXY_ROLES
           
static int PROXY_SESSION
          Values used for close(int).
static java.lang.String PROXY_USER_NAME
           
static java.lang.String PROXY_USER_PASSWORD
           
static int PROXYTYPE_CERTIFICATE
           
static int PROXYTYPE_DISTINGUISHED_NAME
           
static int PROXYTYPE_USER_NAME
           
static int RELEASE_CONNECTION_CALLBACK
           

 

Fields inherited from interface java.sql.Connection
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE

 

Method Summary
 java.sql.Connection _getPC()
          Return the underlying physical connection if this is a logical connection.
 void abort()
          Calling abort() on an open connection does the following: marks the connection as closed, closes any sockets or other primitive connections to the database, and insures that any thread that is currently accessing the connection will either progress to completion of the JDBC call or throw an exception.
 void applyConnectionAttributes(java.util.Properties connAttr)
          Applies the connection Attributes provided on the underlying PooledConnection.
 void archive(int mode, int aseq, java.lang.String acstext)
          Deprecated. This method will be removed in a future version.
 void cancel()
          Performs an immediate (asynchronous) termination of any currently executing operation on this connection.
 void close(int opt)
          If opt is OracleConnection.INVALID_CONNECTION : Closes the given Logical connection, as well the underlying PooledConnection without returning the connection to the cache when called with the parameter INVALID_CONNECTION.
 void close(java.util.Properties connAttr)
          Closes the given Logical connection, and returns the underlying PooledConnection to the implicit connection cache.
 void commit(java.util.EnumSet<OracleConnection.CommitOption> options)
          Commits the transaction with the given options.
 ARRAY createARRAY(java.lang.String typeName, java.lang.Object elements)
          Creates an ARRAY object with the given type name and elements.
 BINARY_DOUBLE createBINARY_DOUBLE(double value)
          Creates a BINARY_DOUBLE that has the given value.
 BINARY_FLOAT createBINARY_FLOAT(float value)
          Creates a BINARY_FLOAT that has the given value.
 DATE createDATE(java.sql.Date value)
          Creates a DATE that has the given value.
 DATE createDATE(java.sql.Date value, java.util.Calendar cal)
          Creates a DATE that has the given value.
 DATE createDATE(java.lang.String value)
          Creates a DATE that has the given value.
 DATE createDATE(java.sql.Time value)
          Creates a DATE that has the given value.
 DATE createDATE(java.sql.Time value, java.util.Calendar cal)
          Creates a DATE that has the given value.
 DATE createDATE(java.sql.Timestamp value)
          Creates a DATE that has the given value.
 DATE createDATE(java.sql.Timestamp value, java.util.Calendar cal)
          Creates a DATE that has the given value.
 INTERVALDS createINTERVALDS(java.lang.String value)
          Creates an INTERVALDS that has the given value.
 INTERVALYM createINTERVALYM(java.lang.String value)
          Creates an INTERVALYM that has the given value.
 NUMBER createNUMBER(java.math.BigDecimal value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(java.math.BigInteger value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(boolean value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(byte value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(double value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(float value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(int value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(long value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(short value)
          Creates a new NUMBER that has the given value.
 NUMBER createNUMBER(java.lang.String value, int scale)
          Creates a new NUMBER that has the given value and scale.
 TIMESTAMP createTIMESTAMP(java.sql.Date value)
          Creates a new TIMESTAMP with the given value.
 TIMESTAMP createTIMESTAMP(DATE value)
          Creates a new TIMESTAMP with the given value.
 TIMESTAMP createTIMESTAMP(java.lang.String value)
          Creates a new TIMESTAMP with the given value.
 TIMESTAMP createTIMESTAMP(java.sql.Time value)
          Creates a new TIMESTAMP with the given value.
 TIMESTAMP createTIMESTAMP(java.sql.Timestamp value)
          Creates a new TIMESTAMP with the given value.
 TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Date value, java.util.Calendar cal)
          Creates a new TIMESTAMPLTZ with the given value.
 TIMESTAMPLTZ createTIMESTAMPLTZ(DATE value, java.util.Calendar cal)
          Creates a new TIMESTAMPLTZ with the given value.
 TIMESTAMPLTZ createTIMESTAMPLTZ(java.lang.String value, java.util.Calendar cal)
          Creates a new TIMESTAMPLTZ with the given value.
 TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Time value, java.util.Calendar cal)
          Creates a new TIMESTAMPLTZ with the given value.
 TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Timestamp value, java.util.Calendar cal)
          Creates a new TIMESTAMPLTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(DATE value)
           
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value, java.util.Calendar cal)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value, java.util.Calendar cal)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value, java.util.Calendar cal)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value)
          Creates a new TIMESTAMPTZ with the given value.
 TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value, java.util.Calendar cal)
          Creates a new TIMESTAMPTZ with the given value.
 AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo)
          Dequeues an AQ message from the queue specified by its name.
 AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, java.lang.String typeName)
          Dequeues an AQ message from the queue specified by its name.
 void enqueue(java.lang.String queueName, AQEnqueueOptions opt, AQMessage mesg)
          Enqueues the given AQ message to the queue specified by its name.
 TypeDescriptor[] getAllTypeDescriptorsInCurrentSchema()
          Obtain all the type descriptors associated with object types or array in the schema of this connection.
 java.lang.String getAuthenticationAdaptorName()
          Returns the name of the adaptor that is used for authentication by the thin driver.
 boolean getAutoClose()
          The driver is always in auto-close mode.
 java.sql.CallableStatement getCallWithKey(java.lang.String key)
          getCallWithKey Searches the explicit cache for a match on key.
 java.util.Properties getConnectionAttributes()
          Returns the connection Attributes set on the underlying PooledConnection.
 int getConnectionReleasePriority()
          Returns the release priority set on the connection
 boolean getCreateStatementAsRefCursor()
          Retrieves the current setting of the createStatementAsRefCursor flag which you can set with the setCreateStatementAsRefCursor method.
 java.lang.String getCurrentSchema()
          Obtains the current schema of the current connection.
 DatabaseChangeRegistration getDatabaseChangeRegistration(int regid)
          Maps an existing registration identified by its ID 'regid' with a new DatabaseChangeRegistration object.
 java.lang.String getDataIntegrityAlgorithmName()
          Returns the name of the algorithm that is used for data integrity checking by the thin driver on the network.
 int getDefaultExecuteBatch()
          Retrieves the overall connection batch value of this connection.
 int getDefaultRowPrefetch()
          Retrieves the value of row prefetch for all statements associated with this connection and created after this value was set.
 java.util.TimeZone getDefaultTimeZone()
          Returns the TimeZone set through setDefaultTimeZone.
 java.lang.Object getDescriptor(java.lang.String sql_name)
          Gets a Descriptor object corresponding to a sql type.
 java.lang.String getEncryptionAlgorithmName()
          Returns the name of the algorithm that is used for data encryption by the thin driver on the network.
 short getEndToEndECIDSequenceNumber()
          Gets the current end to end tracing context id sequence number.
 java.lang.String[] getEndToEndMetrics()
          Gets the values of the end-to-end metrics, if any.
 boolean getExplicitCachingEnabled()
          getExplicitCachingEnabled Returns true if the explicit cache is currently enabled, false otherwise.
 boolean getImplicitCachingEnabled()
          getImplicitCachingEnabled Returns true if the implicit cache is currently enabled, false otherwise.
 boolean getIncludeSynonyms()
          Checks whether or not synonyms information is included in DatabaseMetaData.getColumns.
 java.lang.Object getJavaObject(java.lang.String sql_name)
          Deprecated.  
 java.util.Properties getProperties()
          Determines the connection properties.
 boolean getRemarksReporting()
          Checks whether or not a call of getTables or getColumns of the DatabaseMetaData interface will report the REMARKS column.
 boolean getRestrictGetTables()
          Gets the restriction status of the returned data in DatabaseMetaData.getTables.
 java.lang.String getSessionTimeZone()
          Obtain Oracle session time zone region name.
 java.lang.String getSessionTimeZoneOffset()
          Obtain the time zone offset in hours of the current database session.
 java.lang.String getSQLType(java.lang.Object obj)
          Deprecated.  
 int getStatementCacheSize()
          getStatementCacheSize Returns the current size of the application cache.
 java.sql.PreparedStatement getStatementWithKey(java.lang.String key)
          getStatementWithKey Searches the explicit cache for a match on key.
 int getStmtCacheSize()
          Deprecated. Use getStatementCacheSize() instead.
 short getStructAttrCsId()
          Obtain the Oracle identifier of the character set used in STRUCT attributes.
 TypeDescriptor[] getTypeDescriptorsFromList(java.lang.String[][] schemaAndTypeNamePairs)
          Obtain the type descriptors associated with object types or arrays from an array of scheama and type names.
 TypeDescriptor[] getTypeDescriptorsFromListInCurrentSchema(java.lang.String[] typeNames)
          Obtain the type descriptors associated with object types or array in a schema from an array of type names.
 java.util.Properties getUnMatchedConnectionAttributes()
          Returns the unmatched connection Attributes from the underlying PooledConnection.
 java.lang.String getUserName()
          Gets the user name of the current connection.
 boolean getUsingXAFlag()
          Deprecated.  
 boolean getXAErrorFlag()
          Deprecated.  
 boolean isLogicalConnection()
          Method that returns a boolean indicating whether its a logical connection or not.
 boolean isProxySession()
          Returns true if the current session associated with this connection is a proxy session.
 boolean isUsable()
          Identifies whether this connection is still usable for JDBC operations.
 void openProxySession(int type, java.util.Properties prop)
          Opens a new proxy session with the username provided in the prop argument and switches to this new session.

This feature is supported for both thin and oci driver.

Three proxy types are supported :
OracleConnection.PROXYTYPE_USER_NAME : In this type PROXY_USER_NAME needs to be provided in prop.
 void oracleReleaseSavepoint(OracleSavepoint savepoint)
          Removes the given OracleSavepoint object from the current transaction.
 void oracleRollback(OracleSavepoint savepoint)
          Undoes all changes made after the given OracleSavepoint object was set.
 OracleSavepoint oracleSetSavepoint()
          Creates an unnamed savepoint in the current transaction and returns the new OracleSavepoint object that represents it.
 OracleSavepoint oracleSetSavepoint(java.lang.String name)
          Creates a savepoint with the given name in the current transaction and returns the new OracleSavepoint object that represents it.
 int pingDatabase()
          Ping Database server to see if both database and the connection are actively up.
 int pingDatabase(int timeOut)
          Deprecated.  
 java.sql.CallableStatement prepareCallWithKey(java.lang.String key)
          Deprecated. 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.
 java.sql.PreparedStatement prepareStatementWithKey(java.lang.String key)
          Deprecated. 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.
 void purgeExplicitCache()
          purgeExplicitCache Removes all existing statements from the explicit cache, after which it will be empty.
 void purgeImplicitCache()
          purgeImplicitCache Removes all existing statements from the implicit cache, after which it will be empty.
 void putDescriptor(java.lang.String sql_name, java.lang.Object desc)
          Store the Object Descriptor for later usage.
 AQNotificationRegistration[] registerAQNotification(java.lang.String[] name, java.util.Properties[] options, java.util.Properties globaloptions)
          Registers your interest into being notified when a message is enqueued in a particular queue (or array of queues).
 void registerConnectionCacheCallback(OracleConnectionCacheCallback occc, java.lang.Object userObj, int cbkFlag)
          Registers the connection cache callback on the logical connection This is used in conjunction with the Implicit Connection Cache Properties.
 DatabaseChangeRegistration registerDatabaseChangeNotification(java.util.Properties options)
          Creates a new database change registration.
 void registerSQLType(java.lang.String sql_name, java.lang.Class java_class)
          Deprecated.  
 void registerSQLType(java.lang.String sql_name, java.lang.String java_class_name)
          Deprecated.  
 void registerTAFCallback(OracleOCIFailover cbk, java.lang.Object obj)
          Register an application TAF Callback instance that will be called when an application failover occurs.
 void setAutoClose(boolean autoClose)
          set auto-close mode.
 void setConnectionReleasePriority(int priority)
          Sets connection release priority.
 void setCreateStatementAsRefCursor(boolean value)
          When this is set to true, any new statements created from this connection will be created as a REF CURSOR.
 void setDefaultExecuteBatch(int batch)
          Sets a default batch value for the Oracle update batching model (the default value is 1).
 void setDefaultRowPrefetch(int value)
          Sets the value of row prefetch for all statements associated with this connection and created after this value was set.
 void setDefaultTimeZone(java.util.TimeZone tz)
          The TimeZone to be used while creating java.sql.Date, java.sql.Time & java.sql.Timestamp.
 void setEndToEndMetrics(java.lang.String[] metrics, short sequenceNumber)
          Sets the values of the end-to-end tracing metrics.
 void setExplicitCachingEnabled(boolean cache)
          setExplicitCachingEnabled Enables or disables the explicit cache.
 void setImplicitCachingEnabled(boolean cache)
          setImplicitCachingEnabled Enables or disables the implicit cache.
 void setIncludeSynonyms(boolean synonyms)
          Turns on or off retrieval of synonym information in DatabaseMetaData.
 void setPlsqlWarnings(java.lang.String setting)
          Enable/Disable PLSQL Compiler Warnings
 void setRemarksReporting(boolean reportRemarks)
          Turns on or off the reporting of the REMARKS columns by the getTables and getColumns calls of the DatabaseMetaData interface.
 void setRestrictGetTables(boolean restrict)
          Turns on or off the restriction of the returned data in DatabaseMetaData.getTables.
 void setSessionTimeZone(java.lang.String regionName)
          Set the session time zone.
 void setStatementCacheSize(int size)
          setStatementCacheSize Specifies the size of the size of the application cache (which will be used by both implicit and explicit caching).
 void setStmtCacheSize(int size)
          Deprecated. Use setStatementCacheSize() instead.
 void setStmtCacheSize(int size, boolean clearMetaData)
          Deprecated. Use setStatementCacheSize() instead.
 void setUsingXAFlag(boolean value)
          Deprecated.  
 void setWrapper(OracleConnection wrapper)
          Set the wrapping object.
 void setXAErrorFlag(boolean value)
          Deprecated.  
 void shutdown(OracleConnection.DatabaseShutdownMode mode)
          Shuts the database server down.
 void startup(OracleConnection.DatabaseStartupMode mode)
          Starts the database server up.
 void startup(java.lang.String startup_str, int mode)
          Deprecated. This method will be removed in a future version.
 void unregisterAQNotification(AQNotificationRegistration registration)
          Deletes a given AQ registration.
 void unregisterDatabaseChangeNotification(DatabaseChangeRegistration registration)
          Deletes a given database change registration.
 void unregisterDatabaseChangeNotification(int registrationId)
          Deletes a given database change registration in the server.
 void unregisterDatabaseChangeNotification(int registrationId, java.lang.String host, int tcpport)
          Deletes a given database change registration in the server.
 OracleConnection unwrap()
          Return the wrapped object if any else null.

 

Methods inherited from interface java.sql.Connection
clearWarnings, close, commit, createArrayOf, createBlob, createClob, createNClob, createSQLXML, createStatement, createStatement, createStatement, createStruct, getAutoCommit, getCatalog, getClientInfo, getClientInfo, getHoldability, getMetaData, getTransactionIsolation, getTypeMap, getWarnings, isClosed, isReadOnly, isValid, nativeSQL, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, releaseSavepoint, rollback, rollback, setAutoCommit, setCatalog, setClientInfo, setClientInfo, setHoldability, setReadOnly, setSavepoint, setSavepoint, setTransactionIsolation, setTypeMap

 

Methods inherited from interface java.sql.Wrapper
isWrapperFor, unwrap

 

Field Detail

ACCESSMODE_JAVAPROP

static final byte ACCESSMODE_JAVAPROP
See Also:
Constant Field Values

ACCESSMODE_SYSTEMPROP

static final byte ACCESSMODE_SYSTEMPROP
See Also:
Constant Field Values

ACCESSMODE_BOTH

static final byte ACCESSMODE_BOTH
See Also:
Constant Field Values

CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR

static final java.lang.String CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR
This is applicable only for the thin driver. Pass "true" to retain the V9 bind behavior for Long and potential long binds. "false" is the default behavior which would emulate the same behavior as in OCI driver.
See Also:
Constant Field Values

CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_ACCESSMODE

static final byte CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_USER_NAME

static final java.lang.String CONNECTION_PROPERTY_USER_NAME
The value of this property is used as the user name when connecting to the database. Note that there are other ways to set the username: in the URL or in a wallet but the value of this property overwrites any other value.
See Also:
Constant Field Values

CONNECTION_PROPERTY_USER_NAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_USER_NAME_DEFAULT

CONNECTION_PROPERTY_USER_NAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_USER_NAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DATABASE

static final java.lang.String CONNECTION_PROPERTY_DATABASE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DATABASE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DATABASE_DEFAULT

CONNECTION_PROPERTY_DATABASE_ACCESSMODE

static final byte CONNECTION_PROPERTY_DATABASE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_AUTOCOMMIT

static final java.lang.String CONNECTION_PROPERTY_AUTOCOMMIT
Use this connection property to change the default value of autoCommit.
See Also:
Constant Field Values

CONNECTION_PROPERTY_AUTOCOMMIT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_AUTOCOMMIT_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_AUTOCOMMIT_ACCESSMODE

static final byte CONNECTION_PROPERTY_AUTOCOMMIT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROTOCOL

static final java.lang.String CONNECTION_PROPERTY_PROTOCOL
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROTOCOL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_PROTOCOL_DEFAULT

CONNECTION_PROPERTY_PROTOCOL_ACCESSMODE

static final byte CONNECTION_PROPERTY_PROTOCOL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_STREAM_CHUNK_SIZE

static final java.lang.String CONNECTION_PROPERTY_STREAM_CHUNK_SIZE
Stream chunk size for input streams. The minimum size is 4096.
See Also:
Constant Field Values

CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_ACCESSMODE

static final byte CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY

static final java.lang.String CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY
If the value of this property is "true", the JDBC PreparedStatement setFloat and setDouble API's convert float and double values to the internal binary format for BINARY_FLOAT or BINARY_DOUBLE before sending to the database. If the property is not set or set to other than "true", the setFloat and setDouble API's convert float and double values to the internal format for NUMBER. See the javadoc for setBinaryFloat in oracle.jdbc.PreparedStatement. Use only for 10g or later databases.
See Also:
Constant Field Values

CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_ACCESSMODE

static final byte CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCIDLL

static final java.lang.String CONNECTION_PROPERTY_OCIDLL
Set the name of the native library for the oci driver. If not set, the default name, libocijdbcX (X is a version number), is used.
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCIDLL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_OCIDLL_DEFAULT

CONNECTION_PROPERTY_OCIDLL_ACCESSMODE

static final byte CONNECTION_PROPERTY_OCIDLL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL
Use this connection property to change the value that will show up in the "terminal" column of the "v$session" table for this connection. Note that this setting only applies to the thin driver.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_MACHINE

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_MACHINE
Use this connection property to change the value that will show up in the "machine" column of the "v$session" table for this connection. Note that this setting only applies to the thin driver.

If you don't specify a value, by default, the driver will attempt to retrieve your host name. If the attempt fails, it will use "jdbcclient".

See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_DEFAULT

CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_OSUSER

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_OSUSER
By default, the driver retrieves the OS username from the "user.name" system property which is set by the JVM. You can however override this value by using this connection property (thin driver only).

The OS username will show up in the "osuser" column of the "v$session" table for this connection.

If you don't specify any value and if the JVM's "user.name" system property is null, the value will be set to "jdbcuser".

New in 11gR1: the OS username is also used for OS authentication. This connection property can be used to specify the OS username in cases where the driver can't retrieve it from the JVM. For example if you create the following user in the database:

    > CREATE USER OPS$JDELAVAR IDENTIFIED EXTERNALLY;
    > GRANT CONNECT,RESOURCE,CREATE SESSION TO OPS$JDELAVAR;
    
Then you will be able to connect as "OPS$JDELAVAR" with the following code:
    String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=service)))";
    DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
    Properties props = new Properties();
    props.addProperty(OracleConnection.CONNECTION_PROPERTY_THIN_VSESSION_OSUSER,"jdelavar");
    Connection conn = DriverManager.getConnection(url, props);
    
Note that no password was provided because OS authentication is used; in other words, the database server assumes that the client's OS has authenticated the user which is a very naive assumption. Thus and for obvious security reasons, by default, remote OS authentication is disabled in the server. You need to add the following setting in your init.ora file in order to activate it:
REMOTE_OS_AUTHENT = TRUE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_DEFAULT

CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM
Use this connection property to change the value that will show up in the "program" column of the "v$session" table for this connection. Note that this setting only applies to the thin driver.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROCESS

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROCESS
Use this connection property to change the value that will show up in the "process" column of the "v$session" table for this connection. Note that this setting only applies to the thin driver.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_INAME

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_INAME
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_INAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_INAME_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_INAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_INAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_ENAME

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_ENAME
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_VSESSION_ENAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_VSESSION_ENAME_DEFAULT

CONNECTION_PROPERTY_THIN_VSESSION_ENAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_VSESSION_ENAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_PROFILE

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_PROFILE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_PROFILE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_PROFILE_DEFAULT

CONNECTION_PROPERTY_THIN_NET_PROFILE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_PROFILE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES
Use this connection property to turn on the authentication adaptors. The adaptors are "RADIUS", "KERBEROS" or "TCPS" which is SSL authentication.

For example, to turn on KERBEROS authentication:

    Properties prop = new Properties();
    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES,
                     "( KERBEROS )");  
    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL,
                     "true");
    // Specify where my krb5 configuration file is because JSSE can't find it:
    System.setProperty("java.security.krb5.conf","C:\\WINDOWS\\krb5.ini");
    

Or to turn on RADIUS:

    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES,
                     "( RADIUS)");
    
Or to turn on RADIUS, KERBEROS and SSL authentication adaptors:
    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES,
                     "( RADIUS, KERBEROS, SSL)");
    
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_DEFAULT

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL
To turn on Kerberos mutual authentication, set this property to "true".
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_DEFAULT

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME
Use this connection property to specify the location of the Kerberos credential cache.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_DEFAULT

CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL
Use this property to specify the level of security for the encryption service. In order of increasing security the parameter can be (note that the default is "ACCEPTED"):<bt>
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_DEFAULT

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES
Use this connection property to specify the list of encryption algorithms that you want to activate.

The supported algorithms are:

For example, if you require the connection to be encrypted with either AES256 or AES192, you would set the following properties:

    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES,
                     "( AES256, AES192 )");
    prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL,
                     "REQUIRED");
    
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_DEFAULT

CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL
Use this property to specify the level of security for the integrity service.

See javadoc for CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL.

See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_DEFAULT

CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES
Use this connection property to specify the list of integrity algorithms that you want to activate.

The supported algorithms are:


CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_DEFAULT

CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED
Use this connection property to specify the encryption seed (between 10 and 70 random characters). The encryption seed for the client should not be the same as that for the server. Note that you don't have to specify a seed on the client.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_DEFAULT

CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_TCP_NO_DELAY

static final java.lang.String CONNECTION_PROPERTY_THIN_TCP_NO_DELAY
If the value of this property is "true", the TCP_NODELAY property is set on the socket when using the Thin driver. See java.net.SocketOptions.TCP_NODELAY. Can be either a system property or a connection property
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_READ_TIMEOUT

static final java.lang.String CONNECTION_PROPERTY_THIN_READ_TIMEOUT
Read timeout while reading from the socket. This affects thin driver only. Timeout is in milliseconds.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_READ_TIMEOUT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_READ_TIMEOUT_DEFAULT

CONNECTION_PROPERTY_THIN_READ_TIMEOUT_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_READ_TIMEOUT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_DEFAULT

CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK
Thin uses out of band breaks by default from 11g onwards. If the user prefers to use Inband breaks instead of Out of Band ones then this property could be set to true.
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO
The thin driver uses the zero-copy IO codepath for SecureFile Lobs by default from 11gR2 onwards. To use the regular codepath, set this property to "false".
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME

static final java.lang.String CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME
setTime used to set the date component to 01 Jan, 1900 by default in earlier versions (version < 10g). However, this changed after 10.1 where the time date component in the time was also honored by Jdbc. This flag is introduced to retain the old behavior (as in 9.2)
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_ACCESSMODE

static final byte CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT

static final java.lang.String CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT
Obtain TIMESTAMP WITH TIME ZONE value in GMT than adjusting the same to local time zone. default is true.
See Also:
Constant Field Values

CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_ACCESSMODE

static final byte CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_DEFAULT

CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_VERSION

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_VERSION
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_VERSION_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_VERSION_DEFAULT

CONNECTION_PROPERTY_THIN_SSL_VERSION_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_SSL_VERSION_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_DEFAULT

CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_DEFAULT

CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_DEFAULT

CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_DEFAULT

CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_DEFAULT

CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_DEFAULT

CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NAMING_CONTEXT_INITIAL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_DEFAULT

CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NAMING_PROVIDER_URL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_DEFAULT

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_AUTHENTICATION_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_DEFAULT

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_PRINCIPAL_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS
See Also:
Constant Field Values

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_DEFAULT

CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_ACCESSMODE

static final byte CONNECTION_PROPERTY_THIN_NAMING_SECURITY_CREDENTIALS_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_WALLET_LOCATION

static final java.lang.String CONNECTION_PROPERTY_WALLET_LOCATION
Use this property to specify the wallet location. The driver will use this wallet to:

The wallet location can be set in two formats:

Note that if you don't use SSO wallets but PKCS12 wallets, you must provide the wallet password through the "oracle.net.wallet_password" property.

See Also:
Constant Field Values

CONNECTION_PROPERTY_WALLET_LOCATION_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_WALLET_LOCATION_DEFAULT

CONNECTION_PROPERTY_WALLET_LOCATION_ACCESSMODE

static final byte CONNECTION_PROPERTY_WALLET_LOCATION_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_WALLET_PASSWORD

static final java.lang.String CONNECTION_PROPERTY_WALLET_PASSWORD
Use this property to set the wallet password which is only required if you don't enable enable auto-login in the wallet. In this case "ewallet.p12" will be used instead of "cwallet.sso".
See Also:
Constant Field Values

CONNECTION_PROPERTY_WALLET_PASSWORD_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_WALLET_PASSWORD_DEFAULT

CONNECTION_PROPERTY_WALLET_PASSWORD_ACCESSMODE

static final byte CONNECTION_PROPERTY_WALLET_PASSWORD_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROXY_CLIENT_NAME

static final java.lang.String CONNECTION_PROPERTY_PROXY_CLIENT_NAME
The value of this property is used to specify the name of the proxy client during proxy authentication.

For example if a database user "proxyclient" is setup to connect through another user called "proxy", then you would set the value of this property to "proxyclient".

Note that this connection property can be used to obtain a proxy client connection from scratch and in this model there is only one database session involved instead of two when you first create a regular connection as "proxy" and then call openProxySession(...) to obtain a proxy client session. This is called the single-session proxy model which works with XA as opposed to the double-session proxy model.

See Also:
Constant Field Values

CONNECTION_PROPERTY_PROXY_CLIENT_NAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_PROXY_CLIENT_NAME_DEFAULT

CONNECTION_PROPERTY_PROXY_CLIENT_NAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_PROXY_CLIENT_NAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_USE_NIO

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_USE_NIO
In case of Jdbc-OCI drivers the data is copied from C layer to Java using Jni array copy api. Alternatively by setting this property to "true" the user can instruct the driver to copy data using NIO. Note that the feature would enabled if the underlying JVM supports NIO in JNI layer. The flag is turned off by default (set to false).
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_USE_NIO_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_USE_NIO_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_USE_NIO_ACCESSMODE

static final byte CONNECTION_PROPERTY_DEFAULT_USE_NIO_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_DRIVER_CHARSET

static final java.lang.String CONNECTION_PROPERTY_OCI_DRIVER_CHARSET
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_DEFAULT

CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_ACCESSMODE

static final byte CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_EDITION_NAME

static final java.lang.String CONNECTION_PROPERTY_EDITION_NAME
This connection property can be used to specify a name for the "application edition" which will then appear in the database in the 'USERENV' context. The value is sent to the server at connection time.

The following SQL query:

SELECT sys_context('USERENV', 'CURRENT_EDITION_NAME') 
    FROM dual
should return the same value.

Note that this property can also be set as a system property.

See Also:
Constant Field Values

CONNECTION_PROPERTY_EDITION_NAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_EDITION_NAME_DEFAULT

CONNECTION_PROPERTY_EDITION_NAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_EDITION_NAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_INTERNAL_LOGON

static final java.lang.String CONNECTION_PROPERTY_INTERNAL_LOGON
The value of this property is used as the user name when performing an internal logon. Usually this will be "SYS" or "SYSDBA".
See Also:
Constant Field Values

CONNECTION_PROPERTY_INTERNAL_LOGON_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_INTERNAL_LOGON_DEFAULT

CONNECTION_PROPERTY_INTERNAL_LOGON_ACCESSMODE

static final byte CONNECTION_PROPERTY_INTERNAL_LOGON_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME

static final java.lang.String CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME
The user has to provide fully qualified ADT name ([username].[adt name]) for all ADT operations. However, if the user does not provide fully qualified name, the user name provided during login is appended to the ADT name to obtain fully qualified name. This is also the behavior when this flag is set to false.

The user also has an option to append the CURRENT_USER value to the ADT name to obtain fully qualified name by setting this property to true. Note that it takes a network round trip to fetch the CURRENT_SCHEMA value.

The default value of this flag is false which means that the driver appends the user name used to login as the user name to append to the ADT name.

See Also:
Constant Field Values

CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_ACCESSMODE

static final byte CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE

static final java.lang.String CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_ACCESSMODE

static final byte CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ENV_HANDLE

static final java.lang.String CONNECTION_PROPERTY_OCI_ENV_HANDLE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ENV_HANDLE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_OCI_ENV_HANDLE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ENV_HANDLE_ACCESSMODE

static final byte CONNECTION_PROPERTY_OCI_ENV_HANDLE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ERR_HANDLE

static final java.lang.String CONNECTION_PROPERTY_OCI_ERR_HANDLE
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ERR_HANDLE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_OCI_ERR_HANDLE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_OCI_ERR_HANDLE_ACCESSMODE

static final byte CONNECTION_PROPERTY_OCI_ERR_HANDLE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_PRELIM_AUTH

static final java.lang.String CONNECTION_PROPERTY_PRELIM_AUTH
If this property is set to "true", JDBC drivers connect in PRELIM_AUTH mode, which is the only mode that is permitted when the database is down.
See Also:
Constant Field Values

CONNECTION_PROPERTY_PRELIM_AUTH_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_PRELIM_AUTH_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_PRELIM_AUTH_ACCESSMODE

static final byte CONNECTION_PROPERTY_PRELIM_AUTH_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_SET_NEW_PASSWORD

static final java.lang.String CONNECTION_PROPERTY_SET_NEW_PASSWORD
Property which sets enables the user to set a new password during connection.
See Also:
Constant Field Values

CONNECTION_PROPERTY_SET_NEW_PASSWORD_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_SET_NEW_PASSWORD_DEFAULT

CONNECTION_PROPERTY_SET_NEW_PASSWORD_ACCESSMODE

static final byte CONNECTION_PROPERTY_SET_NEW_PASSWORD_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH
The value of this property is used as the default batch size when using Oracle style batching.
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_ACCESSMODE

static final byte CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH
The value of this property is used as the default number of rows to prefetch.
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_ACCESSMODE

static final byte CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE
The value of this property is used as the default LOB prefetch size for this connection.

The LOB prefetch size can be overriden at the statement level through the setLobPrefetchSize(int) which is defined in oracle.jdbc.OracleStatement. The statement level LOB prefetch size can be overriden at the column level through the defineColumnType method.

The value can be "-1" to disable LOB prefetch for this connection, "0" to enable LOB prefetch for meta-data only or any value greater than 0 which represents a number of bytes for BLOBs and chars for CLOBs to be prefetched along with the locator during fetch operations. The default value for this property is "4000".

Since:
11.2
See Also:
OracleStatement.setLobPrefetchSize, Constant Field Values

CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_ACCESSMODE

static final byte CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_REPORT_REMARKS

static final java.lang.String CONNECTION_PROPERTY_REPORT_REMARKS
If the value of this property is "true", OracleDatabaseMetaData will include remarks in the meta data. This can result in a substantial reduction in performance.
See Also:
Constant Field Values

CONNECTION_PROPERTY_REPORT_REMARKS_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_REPORT_REMARKS_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_REPORT_REMARKS_ACCESSMODE

static final byte CONNECTION_PROPERTY_REPORT_REMARKS_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_INCLUDE_SYNONYMS

static final java.lang.String CONNECTION_PROPERTY_INCLUDE_SYNONYMS
If the value of this property is "true", JDBC will include synonyms when getting information about a column.
See Also:
Constant Field Values

CONNECTION_PROPERTY_INCLUDE_SYNONYMS_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_INCLUDE_SYNONYMS_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_INCLUDE_SYNONYMS_ACCESSMODE

static final byte CONNECTION_PROPERTY_INCLUDE_SYNONYMS_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESTRICT_GETTABLES

static final java.lang.String CONNECTION_PROPERTY_RESTRICT_GETTABLES
If the value of this property is "true", JDBC will return a more refined value for DatabaseMeta.getTables. By default JDBC will return things that are not accessible tables. These can be non-table objects or accessible synonymns for inaccessible tables. If this property is true JDBC will return only accessible tables. This has a substantial performance penalty.
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESTRICT_GETTABLES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_RESTRICT_GETTABLES_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESTRICT_GETTABLES_ACCESSMODE

static final byte CONNECTION_PROPERTY_RESTRICT_GETTABLES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT

static final java.lang.String CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT
When using Oracle style batching, JDBC determines when to flush a batch to the database. If this property is true, then the number of modified rows accumulated across all batches flushed from a single statement. The default is to count each batch separately.
See Also:
Constant Field Values

CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_ACCESSMODE

static final byte CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN

static final java.lang.String CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN
If the value of this property is "true", then JDBC will prefetch rows even though there is a LONG or LONG RAW column in the result. By default JDBC fetches only one row at a time if there are LONG or LONG RAW columns in the result. Setting this property to "true" can improve performance but can also cause SQLExceptions if the results are too big.
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_ACCESSMODE

static final byte CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROCESS_ESCAPES

static final java.lang.String CONNECTION_PROPERTY_PROCESS_ESCAPES
If the value of this property is "false" then the default setting for Statement.setEscapeProccessing is false.
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROCESS_ESCAPES_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_PROCESS_ESCAPES_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_PROCESS_ESCAPES_ACCESSMODE

static final byte CONNECTION_PROPERTY_PROCESS_ESCAPES_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_FIXED_STRING

static final java.lang.String CONNECTION_PROPERTY_FIXED_STRING
If the value of this property is "true", JDBC will use FIXED CHAR semantic when setObject is called with a String argument. By default JDBC uses VARCHAR semantics. The difference is in blank padding. With the default there is no blank padding so, for example, 'a' does not equal 'a ' in a CHAR(4). If true these two will be equal.
See Also:
Constant Field Values

CONNECTION_PROPERTY_FIXED_STRING_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_FIXED_STRING_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_FIXED_STRING_ACCESSMODE

static final byte CONNECTION_PROPERTY_FIXED_STRING_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULTNCHAR

static final java.lang.String CONNECTION_PROPERTY_DEFAULTNCHAR
If the value of this property is "true", the default mode for all character data columns will be NCHAR.
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULTNCHAR_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DEFAULTNCHAR_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DEFAULTNCHAR_ACCESSMODE

static final byte CONNECTION_PROPERTY_DEFAULTNCHAR_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESOURCE_MANAGER_ID

static final java.lang.String CONNECTION_PROPERTY_RESOURCE_MANAGER_ID
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_ACCESSMODE

static final byte CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE

static final java.lang.String CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE
Disable the method OracleStatement.defineColumnType when equal "true". When this connection property has the value true, the method defineColumnType is has no effect. This is highly recommended when using the Thin driver, especially when the database character set contains four byte characters that expand to two UCS2 surrogate characters, e.g. AL32UTF8. The method defineColumnType provides no performance benefit (or any other benefit) when used with the 10g Thin driver. This property is provided so that you do not have to remove the calls from your code. This is especially valuable if you use the same code with Thin driver and either the OCI or Server Internal driver.
See Also:
Constant Field Values

CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_ACCESSMODE

static final byte CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS

static final java.lang.String CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS
Convert NCHAR literals to Unicode literals when equal "true". The default is true.
See Also:
Constant Field Values

CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_ACCESSMODE

static final byte CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_J2EE13_COMPLIANT

static final java.lang.String CONNECTION_PROPERTY_J2EE13_COMPLIANT
If the value of this property is "true", JDBC uses strict compliance for some edge cases. In general Oracle's JDBC drivers will allow some operations that are not permitted in the strict interpretation of J2EE 1.3. Setting this property to true will cause those cases to throw SQLExceptions. There are some other edge cases where Oracle's JDBC drivers have slightly different behavior than defined in J2EE 1.3. This results from Oracle having defined the behavior prior to the J2EE 1.3 specification and the resultant need for compatibility with existing customer code. Setting this property will result in full J2EE 1.3 compliance at the cost of incompatibility with some customer code. Can be either a system property or a connection property.
See Also:
Constant Field Values

CONNECTION_PROPERTY_J2EE13_COMPLIANT_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_J2EE13_COMPLIANT_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_J2EE13_COMPLIANT_ACCESSMODE

static final byte CONNECTION_PROPERTY_J2EE13_COMPLIANT_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP

static final java.lang.String CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP
This connection property lets you define how the driver will map SQL DATE values in the database to Java types. Since Oracle SQL DATE includes a time component and java.sql.Date does not, mapping DATE to java.sql.Date looses information. It is more appropriate to map DATE to java.sql.Timestamp and that is the default behavior.

The 9i and 10g drivers mistakenly mapped DATE to java.sql.Date by default. Setting this property to false will cause the driver to map SQL DATE to java.util.Date with the corresponding loss of time information in each DATE value. This is for backwards compatibility only.

See Also:
Constant Field Values

CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_ACCESSMODE

static final byte CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE

static final java.lang.String CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE
If true, the statement data buffers are cached on a per thread basis. If false, the data buffers are cached on a per connection basis. These buffers can be quite large. It is important that the number of them be minimized.

In most cases you should use the per connection cache. However if your app has many more idle connections than active connections at any given moment then using the thread local cache may reduce the total JDBC driver memory footprint. If you are not having a problem with Java heap size, leave this alone.

See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_ACCESSMODE

static final byte CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE

static final java.lang.String CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE
The value passed to the server for the OCI_ATTR_DRIVER_NAME. This property is supported with both the OCI and Thin drivers. The attribute aids in diagnosability. In most cases you should not need to set it. The value is limited to a maximum of 8 printable 7-bit ASCII characters. The default value depends on which driver is used. The default value for the THIN driver is "jdbcthin" and the default value for the OCI driver is "jdbcoci".
See Also:
Constant Field Values

CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_DEFAULT

CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_ACCESSMODE

static final byte CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE

static final java.lang.String CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE
The size in bytes of the largest internal char or byte data buffer that the driver should cache. The driver uses char and byte buffers to retrieve query results. These buffers can be quite large and are cached. If some queries create particularly large buffers, this will force the driver to use this large buffer size for all queries. It is better to reduce the buffer size of those queries by setting their fetch_size to a smaller value, but if that is impractical, you can set this property to prevent these large buffers from being cached. The appropriate value depends on the heap size, number of connections open, number of statements open at once, and fraction of the heap that can be allocated to JDBC. A reasonable starting point for a middle-tier application server might be 2MB. But it bears repating that you are better off setting the fetch size of the problematic statements, if possible.
See Also:
USE_THREAD_LOCAL_BUFFER_CACHE, Constant Field Values

CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_DEFAULT
See Also:
Constant Field Values

CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_ACCESSMODE

static final byte CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_PASSWORD

static final java.lang.String CONNECTION_PROPERTY_PASSWORD
The value of this property is used as the password when connecting to the database.
See Also:
Constant Field Values

CONNECTION_PROPERTY_PASSWORD_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_PASSWORD_DEFAULT

CONNECTION_PROPERTY_PASSWORD_ACCESSMODE

static final byte CONNECTION_PROPERTY_PASSWORD_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_SERVER

static final java.lang.String CONNECTION_PROPERTY_SERVER
See Also:
Constant Field Values

CONNECTION_PROPERTY_SERVER_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_SERVER_DEFAULT

CONNECTION_PROPERTY_SERVER_ACCESSMODE

static final byte CONNECTION_PROPERTY_SERVER_ACCESSMODE
See Also:
Constant Field Values

CONNECTION_PROPERTY_COMMIT_OPTION

static final java.lang.String CONNECTION_PROPERTY_COMMIT_OPTION
This connection property lets you define a default commit option that will be used when calling connection.commit();. This can be useful in cases where you don't want to rewrite your application to specify a commit option at the call level, such as connection.commit(myCommitOption);.

This property can be set at the system level (all connections will use it) or at the connection level (only that particular connection will be affected). A call level commit option will override the default value.

Note that by default, if you don't set this property, the commit option is '0', zero, and the Oracle server's defaults apply. These defaults are: IMMEDIATE and WAIT (IO operations are done immediately and the call waits until the operation has completed to return).

See Also:
Constant Field Values

CONNECTION_PROPERTY_COMMIT_OPTION_DEFAULT

static final java.lang.String CONNECTION_PROPERTY_COMMIT_OPTION_DEFAULT

CONNECTION_PROPERTY_COMMIT_OPTION_ACCESSMODE

static final byte CONNECTION_PROPERTY_COMMIT_OPTION_ACCESSMODE
See Also:
Constant Field Values

DATABASE_OK

static final int DATABASE_OK
Define return values for pingDatabase api The physical database connection is not closed and the database is reachable. SQL requests my succeed.
See Also:
Constant Field Values

DATABASE_CLOSED

static final int DATABASE_CLOSED
Define return values for pingDatabase api The physical database connection is closed. SQL requests will fail.
See Also:
Constant Field Values

DATABASE_NOTOK

static final int DATABASE_NOTOK
Define return values for pingDatabase api The physical database connection is not closed but the database is not reachable. SQL requests will fail.
See Also:
Constant Field Values

DATABASE_TIMEOUT

static final int DATABASE_TIMEOUT
Define return values for pingDatabase api The call timed out before any positive or negative acknowledgement was received. SQL requests may or may not succeed.
See Also:
Constant Field Values

INVALID_CONNECTION

static final int INVALID_CONNECTION
Values used for close(int). The connection is no longer useable.
See Also:
Constant Field Values

PROXY_SESSION

static final int PROXY_SESSION
Values used for close(int). Close the proxy session, not the entire connection
See Also:
Constant Field Values

ABANDONED_CONNECTION_CALLBACK

static final int ABANDONED_CONNECTION_CALLBACK
See Also:
Constant Field Values

RELEASE_CONNECTION_CALLBACK

static final int RELEASE_CONNECTION_CALLBACK
See Also:
Constant Field Values

ALL_CONNECTION_CALLBACKS

static final int ALL_CONNECTION_CALLBACKS
See Also:
Constant Field Values

CONNECTION_RELEASE_LOCKED

static final int CONNECTION_RELEASE_LOCKED
See Also:
Constant Field Values

CONNECTION_RELEASE_LOW

static final int CONNECTION_RELEASE_LOW
See Also:
Constant Field Values

CONNECTION_RELEASE_HIGH

static final int CONNECTION_RELEASE_HIGH
See Also:
Constant Field Values

PROXYTYPE_USER_NAME

static final int PROXYTYPE_USER_NAME
See Also:
Constant Field Values

PROXYTYPE_DISTINGUISHED_NAME

static final int PROXYTYPE_DISTINGUISHED_NAME
See Also:
Constant Field Values

PROXYTYPE_CERTIFICATE

static final int PROXYTYPE_CERTIFICATE
See Also:
Constant Field Values

PROXY_USER_NAME

static final java.lang.String PROXY_USER_NAME
See Also:
Constant Field Values

PROXY_USER_PASSWORD

static final java.lang.String PROXY_USER_PASSWORD
See Also:
Constant Field Values

PROXY_DISTINGUISHED_NAME

static final java.lang.String PROXY_DISTINGUISHED_NAME
See Also:
Constant Field Values

PROXY_CERTIFICATE

static final java.lang.String PROXY_CERTIFICATE
See Also:
Constant Field Values

PROXY_ROLES

static final java.lang.String PROXY_ROLES
See Also:
Constant Field Values

END_TO_END_ACTION_INDEX

static final int END_TO_END_ACTION_INDEX
See Also:
Constant Field Values

END_TO_END_CLIENTID_INDEX

static final int END_TO_END_CLIENTID_INDEX
See Also:
Constant Field Values

END_TO_END_ECID_INDEX

static final int END_TO_END_ECID_INDEX
See Also:
Constant Field Values

END_TO_END_MODULE_INDEX

static final int END_TO_END_MODULE_INDEX
See Also:
Constant Field Values

END_TO_END_STATE_INDEX_MAX

static final int END_TO_END_STATE_INDEX_MAX
See Also:
Constant Field Values

CACHE_SIZE_NOT_SET

static final int CACHE_SIZE_NOT_SET
See Also:
Constant Field Values

NTF_TIMEOUT

static final java.lang.String NTF_TIMEOUT
See Also:
Constant Field Values

NTF_QOS_PURGE_ON_NTFN

static final java.lang.String NTF_QOS_PURGE_ON_NTFN
See Also:
Constant Field Values

NTF_QOS_RELIABLE

static final java.lang.String NTF_QOS_RELIABLE
See Also:
Constant Field Values

NTF_AQ_PAYLOAD

static final java.lang.String NTF_AQ_PAYLOAD
See Also:
Constant Field Values

NTF_LOCAL_TCP_PORT

static final java.lang.String NTF_LOCAL_TCP_PORT
See Also:
Constant Field Values

NTF_DEFAULT_TCP_PORT

static final int NTF_DEFAULT_TCP_PORT
See Also:
Constant Field Values

NTF_LOCAL_HOST

static final java.lang.String NTF_LOCAL_HOST
See Also:
Constant Field Values

NTF_GROUPING_CLASS

static final java.lang.String NTF_GROUPING_CLASS
See Also:
Constant Field Values

NTF_GROUPING_CLASS_NONE

static final java.lang.String NTF_GROUPING_CLASS_NONE
See Also:
Constant Field Values

NTF_GROUPING_CLASS_TIME

static final java.lang.String NTF_GROUPING_CLASS_TIME
See Also:
Constant Field Values

NTF_GROUPING_VALUE

static final java.lang.String NTF_GROUPING_VALUE
See Also:
Constant Field Values

NTF_GROUPING_TYPE

static final java.lang.String NTF_GROUPING_TYPE
See Also:
Constant Field Values

NTF_GROUPING_TYPE_SUMMARY

static final java.lang.String NTF_GROUPING_TYPE_SUMMARY
See Also:
Constant Field Values

NTF_GROUPING_TYPE_LAST

static final java.lang.String NTF_GROUPING_TYPE_LAST
See Also:
Constant Field Values

NTF_GROUPING_START_TIME

static final java.lang.String NTF_GROUPING_START_TIME
See Also:
Constant Field Values

NTF_GROUPING_REPEAT_TIME

static final java.lang.String NTF_GROUPING_REPEAT_TIME
See Also:
Constant Field Values

NTF_GROUPING_REPEAT_FOREVER

static final java.lang.String NTF_GROUPING_REPEAT_FOREVER
See Also:
Constant Field Values

DCN_NOTIFY_ROWIDS

static final java.lang.String DCN_NOTIFY_ROWIDS
See Also:
Constant Field Values

DCN_IGNORE_INSERTOP

static final java.lang.String DCN_IGNORE_INSERTOP
See Also:
Constant Field Values

DCN_IGNORE_UPDATEOP

static final java.lang.String DCN_IGNORE_UPDATEOP
See Also:
Constant Field Values

DCN_IGNORE_DELETEOP

static final java.lang.String DCN_IGNORE_DELETEOP
See Also:
Constant Field Values

DCN_NOTIFY_CHANGELAG

static final java.lang.String DCN_NOTIFY_CHANGELAG
See Also:
Constant Field Values

DCN_QUERY_CHANGE_NOTIFICATION

static final java.lang.String DCN_QUERY_CHANGE_NOTIFICATION
See Also:
Constant Field Values

DCN_BEST_EFFORT

static final java.lang.String DCN_BEST_EFFORT
See Also:
Constant Field Values

Method Detail

commit

void commit(java.util.EnumSet<OracleConnection.CommitOption> options)
            throws java.sql.SQLException
Commits the transaction with the given options.
Parameters:
flags - commit options
Throws:
java.sql.SQLException

archive

void archive(int mode,
             int aseq,
             java.lang.String acstext)
             throws java.sql.SQLException
Deprecated. This method will be removed in a future version.
Not implemented.
Throws:
java.sql.SQLException

openProxySession

void openProxySession(int type,
                      java.util.Properties prop)
                      throws java.sql.SQLException
Opens a new proxy session with the username provided in the prop argument and switches to this new session.

This feature is supported for both thin and oci driver.

Three proxy types are supported :
Roles can also be provided in the property argument. The key is OracleConnection.PROXY_ROLES. The value is a String[] which contains the roles.
Parameters:
type - has to be either OracleConnection.PROXYTYPE_USER_NAME or OracleConnection.PROXYTYPE_DISTINGUISHED_NAME or OracleConnection.PROXYTYPE_CERTIFICATE
prop - keys/values
Throws:
java.sql.SQLException

getAutoClose

boolean getAutoClose()
                     throws java.sql.SQLException
The driver is always in auto-close mode.
Returns:
should always return true
Throws:
java.sql.SQLException - should never been raised
See Also:
setAutoClose

getDefaultExecuteBatch

int getDefaultExecuteBatch()
Retrieves the overall connection batch value of this connection.

The batch value from the connection is used for all prepared statements associated with this connection. A different batch value can also be defined for individual prepared statements. This can be done by using OraclePreparedStatement.setExecuteBatch, which will override the default value provided from the connection. Therefore, the batch value returned by this getDefaultExecuteBatch entrypoint is valid for prepared statements for which you have not defined a different batch value.

The following code retrieves the default batch value of the connection conn.
Integer batch_val = ((OracleConnection)conn).getDefaultExecuteBatch();

Returns:
the batch value
See Also:
OraclePreparedStatement.setExecuteBatch, setDefaultExecuteBatch

getDefaultRowPrefetch

int getDefaultRowPrefetch()
Retrieves the value of row prefetch for all statements associated with this connection and created after this value was set.

The row-prefetching feature associates an integer row-prefetch setting with a given statement object. JDBC fetches that number of rows at a time from the database during the query. That is, JDBC will fetch N rows that match the query criteria and bring them all back to the client at once, where N is the prefetch setting. Then, once your next calls have run through those N rows, JDBC will go back to fetch the next N rows that match the criteria.

You can set the number of rows to prefetch for a particular Oracle statement (any type of statement). You can also reset the default number of rows that will be prefetched for all statements in your connection with the setDefaultRowPrefetch method. Therefore, the row prefetch value returned by this getDefaultRowPrefetch entrypoint is valid for statements for which you have not defined a different row prefetch value.

The default number of rows to prefetch to the client is 10.

Example where conn is your connection object:
//Get the default row-prefetch setting for this connection
int defRowPref = ((OracleConnection)conn).getDefaultRowPrefetch();

Returns:
the row prefetch value
See Also:
OracleStatement.setRowPrefetch, setDefaultRowPrefetch

getDescriptor

java.lang.Object getDescriptor(java.lang.String sql_name)
Gets a Descriptor object corresponding to a sql type.
Parameters:
sql_name - the sql type
Returns:
the Descriptor Object that matches the sql type
See Also:
putDescriptor, oracle.sql.TypeDescriptor

getEndToEndMetrics

java.lang.String[] getEndToEndMetrics()
                                      throws java.sql.SQLException
Gets the values of the end-to-end metrics, if any. Does not include the sequence number. If DMS is in use and metrics have been set via DMS, this method will return the metrics set via DMS, not those set via setEndToEndMetrics. The DMS metric override the metrics set by setEndToEndMetrics.
Returns:
the metric values as an array of Strings
Throws:
java.sql.SQLException - if an error occurs
See Also:
setEndToEndMetrics

getEndToEndECIDSequenceNumber

short getEndToEndECIDSequenceNumber()
                                    throws java.sql.SQLException
Gets the current end to end tracing context id sequence number. This could be any of the following values: the value passed in the most recent call to setEndToEndMetrics the value returned by the database after the most recent statement execution the value incremented by JDBC diagnostic messages the value JDBC retrieved from DMS (only in a DMS environment)
Returns:
the current ECID sequence number
Throws:
java.sql.SQLException - if an error occurs

getIncludeSynonyms

boolean getIncludeSynonyms()
Checks whether or not synonyms information is included in DatabaseMetaData.getColumns. By default and for performance reasons it won't but you can change this with the setIncludeSynonyms method.
Returns:
true if DatabaseMetaData.getColumns will report information if a table synonym is passed in, and false otherwise
See Also:
setIncludeSynonyms

getRestrictGetTables

boolean getRestrictGetTables()
Gets the restriction status of the returned data in DatabaseMetaData.getTables.

The default behavior is to return information about all synonyms, including those which do not point to accessible tables or views. But you can change this with the setRestrictGetTables method.

Returns:
true if the information returned by DatabaseMetaData.getTables is restricted, and false otherwise
See Also:
setRestrictGetTables

getJavaObject

java.lang.Object getJavaObject(java.lang.String sql_name)
                               throws java.sql.SQLException
Deprecated. 
Throws:
java.sql.SQLException

getRemarksReporting

boolean getRemarksReporting()
Checks whether or not a call of getTables or getColumns of the DatabaseMetaData interface will report the REMARKS column.

By default and for performance reasons it won't (it will return null) but you can change this with the setRemarksReporting method.

Returns:
true if the DatabaseMetaData calls getTables and getColumns will report the REMARKS column and false otherwise
See Also:
setRemarksReporting

getSQLType

java.lang.String getSQLType(java.lang.Object obj)
                            throws java.sql.SQLException
Deprecated. 
Throws:
java.sql.SQLException

getStmtCacheSize

int getStmtCacheSize()
Deprecated. Use getStatementCacheSize() instead.

getStructAttrCsId

short getStructAttrCsId()
                        throws java.sql.SQLException
Obtain the Oracle identifier of the character set used in STRUCT attributes. Note that the network transport layer always send structure attributes in the database character set.
Returns:
the Oracle identifier of the character set.
Throws:
java.sql.SQLException - if Conversion is null
See Also:
oracle.sql.CharacterSet for the set of constants defined for the identifiers."

getUserName

java.lang.String getUserName()
                             throws java.sql.SQLException
Gets the user name of the current connection.

Example where conn is your connection object:
String UserName = ((OracleConnection)conn).getUserName();

Returns:
the user name
Throws:
java.sql.SQLException - if the logical connection is closed

getCurrentSchema

java.lang.String getCurrentSchema()
                                  throws java.sql.SQLException
Obtains the current schema of the current connection.
Returns:
current_schema value
Throws:
java.sql.SQLException - If there was an error while fetching the results

getUsingXAFlag

boolean getUsingXAFlag()
Deprecated. 
Gets the value of the UsingXA flag which the driver sets to true when using XA to manage distributed transactions. If you are not using distributed transactions with the XA library, the value of the UsingXA flag will be false.
Returns:
true when using XA to manage distributed transactions and false otherwise.
See Also:
setUsingXAFlag

getXAErrorFlag

boolean getXAErrorFlag()
Deprecated. 
Gets the value of the XAError flag which is used with distributed transactions.

When using distributed transactions with an XA library, you can ask the driver to raise exception when doing anything that might require a transaction. To do so, set the value of the XAError flag to true with the method setXAErrorFlag.

The default value is false.

Returns:
false is the normal JDBC usage. true means that the driver will raise an exception when doing anything that might require a transaction.
See Also:
setXAErrorFlag

pingDatabase

int pingDatabase()
                 throws java.sql.SQLException
Ping Database server to see if both database and the connection are actively up.
Returns:
DATABASE_OK if the database server is up, and DATABASE_CLOSED if any error occurs.
Throws:
java.sql.SQLException

pingDatabase

int pingDatabase(int timeOut)
                 throws java.sql.SQLException
Deprecated. 
ping Database
Parameters:
timeOut -
Returns:
Throws:
java.sql.SQLException

putDescriptor

void putDescriptor(java.lang.String sql_name,
                   java.lang.Object desc)
                   throws java.sql.SQLException
Store the Object Descriptor for later usage.
Parameters:
sql_name - the sql type
desc - the Object Descriptor associated
Throws:
java.sql.SQLException - if sql_name or desc is null
See Also:
getDescriptor, oracle.sql.TypeDescriptor

registerSQLType

void registerSQLType(java.lang.String sql_name,
                     java.lang.Class java_class)
                     throws java.sql.SQLException
Deprecated. 
Throws:
java.sql.SQLException

registerSQLType

void registerSQLType(java.lang.String sql_name,
                     java.lang.String java_class_name)
                     throws java.sql.SQLException
Deprecated. 
Throws:
java.sql.SQLException

setAutoClose

void setAutoClose(boolean autoClose)
                  throws java.sql.SQLException
set auto-close mode. Only true is accepted.
Parameters:
autoClose - the boolean value
Throws:
java.sql.SQLException - when the argument autoClose is false
See Also:
getAutoClose

setDefaultExecuteBatch

void setDefaultExecuteBatch(int batch)
                            throws java.sql.SQLException
Sets a default batch value for the Oracle update batching model (the default value is 1).

You can reduce the number of round trips to the database, thereby improving application performance, by grouping multiple UPDATE, DELETE, or INSERT statements into a single "batch" and having the whole batch sent to the database and processed in one trip. To do this, you can either use the Oracle update batching model or the batch updates of the Sun Microsystems JDBC 2.0 specification. The standard model is a manual, explicit model (there is no batch value) whereas the Oracle model is an implicit model.

Note: It is important to be aware that you cannot mix theses models. In any single application, you can use the syntax of one model or the other, but not both. The Oracle JDBC driver will throw exceptions when you mix these syntaxes.

The Oracle update batching feature associates a batch value (limit) with each prepared statement object (this way the driver knows in advance how many operations will be batched). With Oracle update batching, instead of the JDBC driver executing a prepared statement each time its executeUpdate method is called, the driver adds the statement to a batch of accumulated execution requests. The driver will pass all the operations to the database for execution once the batch value is reached. For example, if the batch value is 10, then each batch of 10 operations will be sent to the database and processed in one trip.

The following code sets the default batch value to 20 for all prepared statement objects associated with the conn connection object:

((OracleConnection)conn).setDefaultExecuteBatch(20);

Even though this sets the default batch value for all the prepared statements of the connection, you can override it by calling setDefaultBatch on individual Oracle prepared statements. The connection batch value will apply to statement objects created after this batch value was set.

Note that instead of calling setDefaultExecuteBatch, you can set the defaultBatchValue Java property if you use a Java Properties object in establishing the connection.

Types of Statements Supported. As implemented by Oracle, update batching is intended for use with prepared statements, when you are repeating the same statement with different bind variables. Be aware of the following:

Oracle Update Batching Characteristics and Limitations

Parameters:
batch - your default batch value (default is 1)
Throws:
java.sql.SQLException - if the argument batch is <=0
See Also:
OraclePreparedStatement.setExecuteBatch, getDefaultExecuteBatch

setDefaultRowPrefetch

void setDefaultRowPrefetch(int value)
                           throws java.sql.SQLException
Sets the value of row prefetch for all statements associated with this connection and created after this value was set.

The row-prefetching feature associates an integer row-prefetch setting with a given statement object. JDBC fetches that number of rows at a time from the database during the query. That is, JDBC will fetch N rows that match the query criteria and bring them all back to the client at once, where N is the prefetch setting. Then, once your next calls have run through those N rows, JDBC will go back to fetch the next N rows that match the criteria.

You can set the number of rows to prefetch for a particular Oracle statement (any type of statement) but this method allows you to reset the default number of rows that will be prefetched for all statements in your connection. The default number of rows to prefetch to the client is 10.

Use the setDefaultRowPrefetch method to set the default number of rows to prefetch, passing in an integer that specifies the desired default. If you want to check the current setting of the default, then use the getDefaultRowPrefetch method. This method returns an integer.

Example where conn is your connection object:
//Set the default row-prefetch setting for this connection to 7
((OracleConnection)conn).setDefaultRowPrefetch(7);

Note 1 : A statement object receives the default row-prefetch setting from the associated connection at the time the statement object is created. Subsequent changes to the connection's default row-prefetch setting have no effect on the statement's row-prefetch setting.

Note 2 : If a column of a result set is of datatype LONG or LONG RAW (that is, the streaming types), JDBC changes the statement's row-prefetch setting to 1, even if you never actually read a value of either of those types.

Note 3 : Do not mix the JDBC 2.0 fetch size API and the Oracle row-prefetching API in your application. You can use one or the other but not both.

Parameters:
value - the number of rows to prefetch
Throws:
java.sql.SQLException - if the argument value is <=0
See Also:
OracleStatement.setRowPrefetch, getDefaultRowPrefetch

setEndToEndMetrics

void setEndToEndMetrics(java.lang.String[] metrics,
                        short sequenceNumber)
                        throws java.sql.SQLException
Sets the values of the end-to-end tracing metrics. The indices for the array are the END_TO_END_XXX_INDEX values defined in this class. The values set by this method are overridden by any values set via DMS if DMS is in use.
Parameters:
metrics - String[] containing the metric values.
sequenceNumber - the sequence number for the context id
Throws:
java.sql.SQLException - if an error occurs
See Also:
getEndToEndMetrics

setIncludeSynonyms

void setIncludeSynonyms(boolean synonyms)
Turns on or off retrieval of synonym information in DatabaseMetaData. getColumns.

Similar to setRemarksReporting, getColumns performs extremely slow if information about synonyms has to be included, because it neccessitates an outer join so, by default, the JDBC driver will not report information about synonyms.

You can get synonym information by passing true to this method, and turn it off by passing false. You can also control this behavior by passing a property named "includeSynonyms" as "true" to DriverManager.getConnection.

Parameters:
synonyms - true if you want to retrieve synonym information in DatabaseMetaData.getColumns and false otherwise.
See Also:
getIncludeSynonyms

setRemarksReporting

void setRemarksReporting(boolean reportRemarks)
Turns on or off the reporting of the REMARKS columns by the getTables and getColumns calls of the DatabaseMetaData interface.

The DatabaseMetaData calls getTables and getColumns are extremely slow if the REMARKS column has to be reported as this necessitates an expensive outer join so by default the JDBC driver does not report the REMARKS columns.

You can turn the reporting of REMARKS on by passing a true argument to this method. You turn it back off by passing a false argument.

Example where conn is your connection object:
((OracleConnection)conn).setRemarksReporting(true);

You can also control the reporting of REMARKS by passing a property named remarksReporting as true to the DriverManager.getConnection call.

Parameters:
reportRemarks - true if you want to turn on the reporting of the REMARKS columns and false otherwise.
See Also:
getRemarksReporting

setRestrictGetTables

void setRestrictGetTables(boolean restrict)
Turns on or off the restriction of the returned data in DatabaseMetaData.getTables.

DatabaseMetaData.getTables will return information about all accessible tables, views, and synonyms. There are two issues relating to synonyms which can affect the quality of the returned data:

  1. Public synonyms can exist for tables to which you don't have access. Although the synonym itself is viewable, the underlying table is not.
  2. Synonyms can exist for non-table objects, such as procedures, sequences, Java classes, etc.
As a result of the above issues, getTables can return rows containing objects that are not describable with getColumns, either because they are not accessible (issue 1) or because they are not tables or views (issue 2).

To remedy this, you can restrict the results of getTables to only those tables and views to which you have access. This is done by either passing true to this method, or by passing the restrictGetTables property as true to the DriverManager.getConnection call. The default behavior is to return information about all synonyms, including those which do not point to accessible tables or views.

Note that getTables can return more than one row for the same object, one for the object itself, and additional rows for any synonyms defined for that object. This is the case regardless of the setting for restrictGetTables.

The following code turns on the restriction:
((OracleConnection)conn).setRestrictGetTables(true);

Parameters:
restrict - true to turn on the restriction and false otherwise.
See Also:
getRestrictGetTables

setStmtCacheSize

void setStmtCacheSize(int size)
                      throws java.sql.SQLException
Deprecated. Use setStatementCacheSize() instead.
Throws:
java.sql.SQLException

setStmtCacheSize

void setStmtCacheSize(int size,
                      boolean clearMetaData)
                      throws java.sql.SQLException
Deprecated. Use setStatementCacheSize() instead.
Throws:
java.sql.SQLException

setStatementCacheSize

void setStatementCacheSize(int size)
                           throws java.sql.SQLException
setStatementCacheSize Specifies the size of the size of the application cache (which will be used by both implicit and explicit caching).
Parameters:
size - Requested size of the cache. If the existing cache size is less than size, statements will be purged to reduce the size.
Throws:
java.sql.SQLException - if size < 0, or if called on a logical connection.

getStatementCacheSize

int getStatementCacheSize()
                          throws java.sql.SQLException
getStatementCacheSize Returns the current size of the application cache. This is valid on both physical and logical connections. If the statement cache has not been initialized with setStatementCacheSize(), then CACHE_SIZE_NOT_SET is returned.
Returns:
the cache size
Throws:
java.sql.SQLException

setImplicitCachingEnabled

void setImplicitCachingEnabled(boolean cache)
                               throws java.sql.SQLException
setImplicitCachingEnabled Enables or disables the implicit cache. Note that this is independent of the cache size, set with setStatmentCacheSize().
Parameters:
cache - If true, then implicit caching will be enabled. If false, then any existing statements will be purged and the implicit cache will be disabled.
Throws:
java.sql.SQLException - if called on a logical connection.

getImplicitCachingEnabled

boolean getImplicitCachingEnabled()
                                  throws java.sql.SQLException
getImplicitCachingEnabled Returns true if the implicit cache is currently enabled, false otherwise. This method is valid on both logical and physical connections.
Returns:
Throws:
java.sql.SQLException

setExplicitCachingEnabled

void setExplicitCachingEnabled(boolean cache)
                               throws java.sql.SQLException
setExplicitCachingEnabled Enables or disables the explicit cache. Note that this is independent of the cache size, set with setStatmentCacheSize().
Parameters:
cache - If true, then explicit caching will be enabled. If false, then any existing statements will be purged and the explicit cache will be disabled.
Throws:
java.sql.SQLException - if called on a logical connection.

getExplicitCachingEnabled

boolean getExplicitCachingEnabled()
                                  throws java.sql.SQLException
getExplicitCachingEnabled Returns true if the explicit cache is currently enabled, false otherwise. This method is valid on both logical and physical connections.
Returns:
Throws:
java.sql.SQLException

purgeImplicitCache

void purgeImplicitCache()
                        throws java.sql.SQLException
purgeImplicitCache Removes all existing statements from the implicit cache, after which it will be empty. This method does not affect the size of the application cache, nor the enabled/disabled status.
Throws:
java.sql.SQLException

purgeExplicitCache

void purgeExplicitCache()
                        throws java.sql.SQLException
purgeExplicitCache Removes all existing statements from the explicit cache, after which it will be empty. This method does not affect the size of the application cache, nor the enabled/disabled status.
Throws:
java.sql.SQLException

getStatementWithKey

java.sql.PreparedStatement getStatementWithKey(java.lang.String key)
                                               throws java.sql.SQLException
getStatementWithKey Searches the explicit cache for a match on key. If found, the statement is returned, with the paramater and define metadata identical to the last usage. If no match is found, or if explicit caching is not enabled, then null is returned (as opposed to throwing an exception).
Parameters:
key - Specified key to search for
Returns:
Throws:
java.sql.SQLException

getCallWithKey

java.sql.CallableStatement getCallWithKey(java.lang.String key)
                                          throws java.sql.SQLException
getCallWithKey Searches the explicit cache for a match on key. If found, the statement is returned, with the paramater and define metadata identical to the last usage. If no match is found, or if explicit caching is not enabled, then null is returned (as opposed to throwing an exception).
Parameters:
key - Specified key to search for
Returns:
Throws:
java.sql.SQLException

setUsingXAFlag

void setUsingXAFlag(boolean value)
Deprecated. 
When using distributed transactions with XA, you can set the value of the UsingXA flag.

XA is a general standard (not specific to Java) for distributed transactions. You should use this method only when using XA.

By default, when using distributed transactions with XA, the driver will set the UsingXA flag to true and exceptions will be raised when you want to do anything with your logical connection that might require a transaction. Otherwise the flag UsingXA is always false.

If you are actually using distributed transactions with XA and you dislike the default behavior, you can set the flag back to false.

Parameters:
value - the value of the UsingXA flag
See Also:
getUsingXAFlag

setXAErrorFlag

void setXAErrorFlag(boolean value)
Deprecated. 
Sets the value of the XAError flag which is used with distributed transactions. When coexisting with an XA library, you can set the XAError flag to true and the driver will then raise an exception when doing anything that might require a transaction.
Parameters:
value - the value of the XAError flag
See Also:
getXAErrorFlag

shutdown

void shutdown(OracleConnection.DatabaseShutdownMode mode)
              throws java.sql.SQLException
Shuts the database server down. This method requires to be connected as either SYSOPER or SYSDBA.
Parameters:
mode - can be either
  • OracleConnection.DatabaseShutdownMode.CONNECT
  • OracleConnection.DatabaseShutdownMode.TRANSACTIONAL
  • OracleConnection.DatabaseShutdownMode.TRANSACTIONAL_LOCAL
  • OracleConnection.DatabaseShutdownMode.IMMEDIATE
  • OracleConnection.DatabaseShutdownMode.ABORT
  • OracleConnection.DatabaseShutdownMode.FINAL
Throws:
java.sql.SQLException

startup

void startup(java.lang.String startup_str,
             int mode)
             throws java.sql.SQLException
Deprecated. This method will be removed in a future version.
Not implemented
Throws:
java.sql.SQLException

startup

void startup(OracleConnection.DatabaseStartupMode mode)
             throws java.sql.SQLException
Starts the database server up. This method requires to be connected as either SYSOPER or SYSDBA in the PRELIM_AUTH mode which is the only mode permietted when the database is down (see the connection property CONNECTION_PROPERTY_PRELIM_AUTH).
Parameters:
mode - can be either
  • OracleConnection.DatabaseStartupMode.NO_RESTRICTION
  • OracleConnection.DatabaseStartupMode.FORCE
  • OracleConnection.DatabaseStartupMode.RESTRICT
Throws:
java.sql.SQLException

prepareStatementWithKey

java.sql.PreparedStatement prepareStatementWithKey(java.lang.String key)
                                                   throws java.sql.SQLException
Deprecated. 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.
Parameters:
key - the key with which it was closed
Returns:
a OraclePreparedStatement object
Throws:
java.sql.SQLException - if a database access error occurs

prepareCallWithKey

java.sql.CallableStatement prepareCallWithKey(java.lang.String key)
                                              throws java.sql.SQLException
Deprecated. 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.
Parameters:
key - the key with which it was closed
Returns:
a oracle.jdbc.driver.CallableStatement object
Throws:
java.sql.SQLException - if a database access error occurs

setCreateStatementAsRefCursor

void setCreateStatementAsRefCursor(boolean value)
When this is set to true, any new statements created from this connection will be created as a REF CURSOR. Only resultsets obtained from statements that are created as REF CURSORS can be returned from a Java Stored Procedure. This feature is supported by the server-side internal driver only, and is no-op in all other JDBC drivers.

Default value is false.

To use the setCreateStatementAsRefCursor entrypoint you have to cast the Connection object to the type oracle.jdbc.OracleConnection.

Parameters:
value - true if new statements should be created as REF CURSORS, false otherwise
See Also:
getCreateStatementAsRefCursor

getCreateStatementAsRefCursor

boolean getCreateStatementAsRefCursor()
Retrieves the current setting of the createStatementAsRefCursor flag which you can set with the setCreateStatementAsRefCursor method.

To use the getCreateStatementAsRefCursor entrypoint you have to cast the Connection object to the type oracle.jdbc.OracleConnection.

Returns:
the current setting of the createStatementAsRefCursor flag
See Also:
setCreateStatementAsRefCursor

setSessionTimeZone

void setSessionTimeZone(java.lang.String regionName)
                        throws java.sql.SQLException
Set the session time zone.

This method is used to set the session time zone. This method must be invoked before accessing any TIMESTAMP WITH LOCAL TIME ZONE data. Upon invocation of this method, the Jdbc driver sets the session timezone of the connection and saves the session timezone so that any TSLTZ data accessed via Jdbc are adjusted using the session timezone.

Parameters:
regionName - Oracle session time zone region name.
Throws:
java.sql.SQLException - if an error occurred.
Since:
9i

getSessionTimeZone

java.lang.String getSessionTimeZone()
Obtain Oracle session time zone region name.
Returns:
Oracle session time zone region name.
Since:
9i

getSessionTimeZoneOffset

java.lang.String getSessionTimeZoneOffset()
                                          throws java.sql.SQLException
Obtain the time zone offset in hours of the current database session. The result will always be accurate. In other words, you can execute "ALTER SESSION SET TIME_ZONE ..." and then call this method, it will return the new value.

The value returned by this method is that same as the result of "SELECT SESSIONTIMEZONE FROM DUAL;". The drivers may use some performance optimization to not use a roundtrip to the server so it is always preferrable to use this method.

Returns:
Oracle session time zone in hours. For example "-7:00" or "0:00"
Throws:
java.sql.SQLException
Since:
11.1

getProperties

java.util.Properties getProperties()
Determines the connection properties.
Returns:

_getPC

java.sql.Connection _getPC()
Return the underlying physical connection if this is a logical connection. Returns null otherwise.
Returns:
Connection object if its a logical handle otherwise returns null

isLogicalConnection

boolean isLogicalConnection()
Method that returns a boolean indicating whether its a logical connection or not.
Returns:
boolean true if this is a logical connection

registerTAFCallback

void registerTAFCallback(OracleOCIFailover cbk,
                         java.lang.Object obj)
                         throws java.sql.SQLException
Register an application TAF Callback instance that will be called when an application failover occurs. The TAF feature is only available in the Jdbc OCI driver.
Parameters:
cbk - Callback instance.
obj - Context object in which any client's state can be stored and provided when the callback method is invoked.
Throws:
java.sql.SQLException - if this method is invoked in drivers other than the Jdbc OCI driver.
Since:
9i

unwrap

OracleConnection unwrap()
Return the wrapped object if any else null. This method should not delegate to the wrapped object. Instead it should return the wrapped object.
Returns:
wrapped object which implements oracle.jdbc.OracleConnection if any else return null
Since:
9iRw

setWrapper

void setWrapper(OracleConnection wrapper)
Set the wrapping object. The argument is an object that wraps this object. Calling wrapper.unwrap() should return this.
Parameters:
wrapper - An object which implements oracle.jdbc.OracleConnection and which is a wrapper for this object # @since 9iR2

oracleSetSavepoint

OracleSavepoint oracleSetSavepoint()
                                   throws java.sql.SQLException
Creates an unnamed savepoint in the current transaction and returns the new OracleSavepoint object that represents it.
Returns:
the new OracleSavepoint object
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode
Since:
9.0.2
See Also:
OracleSavepoint

oracleSetSavepoint

OracleSavepoint oracleSetSavepoint(java.lang.String name)
                                   throws java.sql.SQLException
Creates a savepoint with the given name in the current transaction and returns the new OracleSavepoint object that represents it.
Parameters:
name - a String containing the name of the savepoint
Returns:
the new OracleSavepoint object
Throws:
java.sql.SQLException - if a database access error occurs or this Connection object is currently in auto-commit mode
Since:
9.0.2
See Also:
OracleSavepoint

oracleRollback

void oracleRollback(OracleSavepoint savepoint)
                    throws java.sql.SQLException
Undoes all changes made after the given OracleSavepoint object was set.

This method should be used only when auto-commit has been disabled.

Parameters:
savepoint - the OracleSavepoint object to roll back to
Throws:
java.sql.SQLException - if a database access error occurs, the OracleSavepoint object is no longer valid, or this Connection object is currently in auto-commit mode
Since:
9.0.2
See Also:
OracleSavepoint

oracleReleaseSavepoint

void oracleReleaseSavepoint(OracleSavepoint savepoint)
                            throws java.sql.SQLException
Removes the given OracleSavepoint object from the current transaction. Any reference to the savepoint after it have been removed will cause an SQLException to be thrown.
Parameters:
savepoint - the OracleSavepoint object to be removed
Throws:
java.sql.SQLException - if a database access error occurs or the given OracleSavepoint object is not a valid savepoint in the current transaction
Since:
9.0.2
See Also:
OracleSavepoint

close

void close(java.util.Properties connAttr)
           throws java.sql.SQLException
Closes the given Logical connection, and returns the underlying PooledConnection to the implicit connection cache. The connection Attributes is set on the PooledConnection. If the connection Attributes passed is null, then a null value is set on the PooledConnection as well. When called on a physical connection, the connection Attributes passed in has no effect.
Parameters:
connAttr - the connection Attributes to be applied
Throws:
java.sql.SQLException - if a database access error occurs

close

void close(int opt)
           throws java.sql.SQLException
If opt is OracleConnection.INVALID_CONNECTION : Closes the given Logical connection, as well the underlying PooledConnection without returning the connection to the cache when called with the parameter INVALID_CONNECTION. If this API is called on a physical connection, the supplied parameter has no effect.

If opt is OracleConnection.PROXY_SESSION : Closes the proxy session (opened with openProxySession()).
Parameters:
opt - set to INVALID_CONNECTION to close the PooledConnection
Throws:
java.sql.SQLException - if a database access error occurs

isProxySession

boolean isProxySession()
Returns true if the current session associated with this connection is a proxy session.
Returns:

applyConnectionAttributes

void applyConnectionAttributes(java.util.Properties connAttr)
                               throws java.sql.SQLException
Applies the connection Attributes provided on the underlying PooledConnection. The connection Attributes set via the close API overrides the value set by this API.
Parameters:
connAttr - the connection Attributes to be applied
Throws:
java.sql.SQLException - if a database access error occurs

getConnectionAttributes

java.util.Properties getConnectionAttributes()
                                             throws java.sql.SQLException
Returns the connection Attributes set on the underlying PooledConnection. This API returns null when called on a physical connection.
Returns:
Throws:
java.sql.SQLException - if a database access error occurs

getUnMatchedConnectionAttributes

java.util.Properties getUnMatchedConnectionAttributes()
                                                      throws java.sql.SQLException
Returns the unmatched connection Attributes from the underlying PooledConnection. These are essentially the PooledConnection Attributes that did not match the ones from the connection request. This API returns null when called on a physical connection.
Throws:
java.sql.SQLException - if a database access error occurs

registerConnectionCacheCallback

void registerConnectionCacheCallback(OracleConnectionCacheCallback occc,
                                     java.lang.Object userObj,
                                     int cbkFlag)
                                     throws java.sql.SQLException
Registers the connection cache callback on the logical connection This is used in conjunction with the Implicit Connection Cache Properties.
Parameters:
occc - Implementation of the OracleConnectionCacheCallback Interface
userObj - User private object to be passed when invoking callbacks
cbkFlag - Indicates which callback method to invoke. Supported values are: ABANDONED_CONNECTION_CALLBACK RELEASE_CONNECTION_CALLBACK ALL_CONNECTION_CALLBACKS
Throws:
java.sql.SQLException - if a database access error occurs

setConnectionReleasePriority

void setConnectionReleasePriority(int priority)
                                  throws java.sql.SQLException
Sets connection release priority. Works in conjunction with the Connection Cache Callback method RELEASE_CONNECTION_CALLBACK Suported release priorities are: CONNECTION_RELEASE_LOCKED CONNECTION_RELEASE_LOW CONNECTION_RELEASE_HIGH
Parameters:
priority - one of the above release priority
Throws:
java.sql.SQLException - if a database access error occurs

getConnectionReleasePriority

int getConnectionReleasePriority()
                                 throws java.sql.SQLException
Returns the release priority set on the connection
Throws:
java.sql.SQLException - if a database access error occurs

setPlsqlWarnings

void setPlsqlWarnings(java.lang.String setting)
                      throws java.sql.SQLException
Enable/Disable PLSQL Compiler Warnings
Parameters:
setting - Setting specified for ALTER SESSION SET PLSQL_WARNINGS. Sample values are: "'ENABLE:ALL'", "'DISABLE:ALL'", "'ENALBLE:INFORMATIONAL'", etc. Please refer to the SQL reference of ALTER SESSION SET PLSQL_WARNINGS for more information. If the setting is "'DISABLE:ALL'", jdbc drivers turn off PLSQL Compiler Warnings. Note: the quotes(') in the setting String are necessary.
Throws:
java.sql.SQLException - if a database access error occurs

registerAQNotification

AQNotificationRegistration[] registerAQNotification(java.lang.String[] name,
                                                    java.util.Properties[] options,
                                                    java.util.Properties globaloptions)
                                                    throws java.sql.SQLException
Registers your interest into being notified when a message is enqueued in a particular queue (or array of queues).

This method creates an array of new AQ registrations in the database server with the given options. It also opens a listening socket which will be used by the database to send notifications. Note that mutiple registrations can share the same listening socket.

Each registration will continue to live after this connection is closed. You need to explicitly unregister it to destroy it in the server and release the resources in the driver.

This method uses one roundtrip.

Parameters:
name - contains an array of queue names ("SCOTT.MY_QUEUE") for single consumer queues or queue names with the consumer name ("SCOTT.MY_QUEUE:RECEIVER") for multiple consumer queues.
options - Possible options are ([] means default):
  • OracleConnection.NTF_QOS_RELIABLE: "true"/["false"]. Set this option to "true" to make the notifications persistent which comes at a performance cost.
  • OracleConnection.NTF_QOS_PURGE_ON_NTFN: "true"/["false"]. Set this option to "true" and the registration will be expunged on the first notification event.
  • OracleConnection.NTF_TIMEOUT: value in seconds "60"/["0"]. Specifies the time in seconds after which the registration is automatically expunged by the database. The default is "0": the registration lives until explicitly deregistered.
  • OracleConnection.NTF_AQ_PAYLOAD: "true"/["false"]. Sets this to "true" to make the server send the payload within the notification. Note that this feature works only with "RAW" payloads.
  • OracleConnection.NTF_GROUPING_CLASS: OracleConnection.NTF_GROUPING_CLASS_TIME/[OracleConnection.NTF_GROUPING_CLASS_NONE]. Notification Grouping Class, the criterion or dimension for grouping. As of 11.2 the only supported class is OracleConnection.NTF_GROUPING_CLASS_TIME meaning grouping by time, that is, the user specifies a time value and a single notification gets published at the end of that time. To use grouping at least this option must be specified to a value other than the default OracleConnection.NTF_GROUPING_CLASS_NONE, which is no grouping.
  • OracleConnection.NTF_GROUPING_VALUE: "1200/["600"]. Notification Grouping Value, the value of the grouping class. The value must be an integer number. For the TIME grouping class, this value represents a number of seconds, meaning the time after which grouped notifications are sent. If not specified, it defaults to 600 sec.
  • OracleConnection.NTF_GROUPING_TYPE: OracleConnection.NTF_GROUPING_TYPE_LAST/[OracleConnection.NTF_GROUPING_TYPE_SUMMARY]. Notification Grouping Type, the format of grouping notification. It can either contain the summary of all events (default) or the last event in the group.
  • OracleConnection.NTF_GROUPING_START_TIME: When to start grouping? Notification grouping can start from a user-specified time that should a valid timestamp with time zone, that is an instance of oracle.sql.TIMESTAMPTZ. If this option is not specified when using grouping, it defaults to current system time. For example if prop was the option properties, and conn the connection object, you would call: prop.put(OracleConnection.NTF_GROUPING_START_TIME,new TIMESTAMPTZ(conn,"2007-06-21 10:10:00.0"));.
  • OracleConnection.NTF_GROUPING_REPEAT_TIME: "100/[NTF_GROUPING_REPEAT_FOREVER]". How many times do grouping? Grouping notifications will be sent as many times as specified by the notification grouping repeat count and after that revert to regular notifications. If not specified, it will default to: NTF_GROUPING_REPEAT_FOREVER - keep sending grouping notifications forever.
globaloptions - Possible options are ([] means default):
  • OracleConnection.NTF_LOCAL_TCP_PORT: "1234"/[NTF_DEFAULT_TCP_PORT]. This option lets you specify what TCP port the driver should use for the listening socket. If you don't specify a port, the driver will use NTF_DEFAULT_TCP_PORT and if it's already used, it will increment it by one until it finds one that is available.
  • OracleConnection.NTF_LOCAL_HOST: example "212.121.134.12". Use this option to manually specify the IP address of the machine that will receive the notifications from the server. Use this option with caution: only specify the IP address of the local machine when the driver is unable to find it out on its own (it uses InetAddress.getLocalHost() ). For example if the machine on which runs the JDBC driver is a VPN client, you may have to specify the IP address of the VPN client which the driver cannot find out on its own. This option should not be used to attempt to have a different remote host receive the notifications from the server.
Returns:
AQNotificationRegistration[]
Throws:
java.sql.SQLException
Since:
11.1

unregisterAQNotification

void unregisterAQNotification(AQNotificationRegistration registration)
                              throws java.sql.SQLException
Deletes a given AQ registration. The registration will be destroyed in the server and in the driver (the network listener will be closed if it's not used anymore).
Parameters:
registration -
Throws:
java.sql.SQLException
Since:
11.1

dequeue

AQMessage dequeue(java.lang.String queueName,
                  AQDequeueOptions opt,
                  byte[] tdo)
                  throws java.sql.SQLException
Dequeues an AQ message from the queue specified by its name.
Parameters:
queueName - name of the queue from which to dequeue.
opt - dequeue options
tdo - the Type Descriptor Object OID of the type of the queue.
Returns:
the AQMessage dequeued.
Throws:
java.sql.SQLException
Since:
11.1

dequeue

AQMessage dequeue(java.lang.String queueName,
                  AQDequeueOptions opt,
                  java.lang.String typeName)
                  throws java.sql.SQLException
Dequeues an AQ message from the queue specified by its name.
Parameters:
queueName - name of the queue from which to dequeue.
opt - dequeue options.
typeName - the name of the type of the queue. For example, it can be "RAW", "SYS.ANYDATA" or "SCOTT.MY_OBJECT_TYPE".
Returns:
the AQMessage dequeued.
Throws:
java.sql.SQLException
Since:
11.1

enqueue

void enqueue(java.lang.String queueName,
             AQEnqueueOptions opt,
             AQMessage mesg)
             throws java.sql.SQLException
Enqueues the given AQ message to the queue specified by its name.
Parameters:
queueName - name of the queue where to enqueue.
opt - enqueue options.
mesg - the AQ message to enqueue.
Throws:
java.sql.SQLException
Since:
11.1

registerDatabaseChangeNotification

DatabaseChangeRegistration registerDatabaseChangeNotification(java.util.Properties options)
                                                              throws java.sql.SQLException
Creates a new database change registration.

This method creates a new database change registration in the database server with the given options. It also opens a listening socket which will be used by the database to send notifications. Note that if there already is a listening socket (created by a different registration), then it will be used by this registration as well.

This method returns a DatabaseChangeRegistration object that can then be used to associate a statement with this registration.

The registration will continue to live after this connection is closed. You need to explicitly unregister it to destroy it in the server and release the resources in the driver.

This method uses one roundtrip.

Parameters:
options - Possible options are ([] means default):
  • OracleConnection.NTF_QOS_RELIABLE: "true"/["false"]. Set this option to "true" to make the notifications persistent which comes at a performance cost.
  • OracleConnection.NTF_QOS_PURGE_ON_NTFN: "true"/["false"]. Set this option to "true" and the registration will be expunged on the first notification event.
  • OracleConnection.NTF_TIMEOUT: value in seconds "60"/["0"]. Specifies the time in seconds after which the registration is automatically expunged by the database. The default is "0": the registration lives until explicitly deregistered.
  • OracleConnection.NTF_LOCAL_TCP_PORT: "1234"/[NTF_DEFAULT_TCP_PORT]. This option lets you specify what TCP port the driver should use for the listening socket. If you don't specify a port, the driver will use NTF_DEFAULT_TCP_PORT and if it's already used, it will increment it by one until it finds one that is available.
  • OracleConnection.NTF_LOCAL_HOST: example "212.121.134.12". Use this option to manually specify the IP address of the machine that will receive the notifications from the server. Use this option with caution: only specify the IP address of the local machine when the driver is unable to find it out on its own (it uses InetAddress.getLocalHost() ). For example if the machine on which runs the JDBC driver is a VPN client, you may have to specify the IP address of the VPN client which the driver cannot find out on its own. This option should not be used to attempt to have a different remote host receive the notifications from the server.
  • OracleConnection.DCN_NOTIFY_ROWIDS: "true"/["false"]. Use this option to have the server send the ROWIDs of the row that have changed within the notification event. By default this feature is turned off.
  • OracleConnection.DCN_IGNORE_INSERTOP: "true"/["false"]. Use this option to tell the server to ignore INSERT operations.
  • OracleConnection.DCN_IGNORE_UPDATEOP: "true"/["false"]. Use this options to tell the server to ignore UPDATE operations.
  • OracleConnection.DCN_IGNORE_DELETEOP: "true"/["false"]. Use this options to tell the server to ignore DELETE operations.
  • OracleConnection.DCN_NOTIFY_CHANGELAG: "30"/["0"]. This is an int value (specified as a String), that can be used to specify the number of transactions by which the client is willing to lag behind. This option can be used by the client as a throttling mechanism for database change events. When this option is chosen, ROWID level granularity of information will not be available in the events, even if the DCN_NOTIFY_ROWIDS option was set to "true".
  • OracleConnection.DCN_QUERY_CHANGE_NOTIFICATION: "true"/["false"]. Use this option to activate query change notification instead of object change notification. Note that this option is only available in the database server starting in 11.1.
  • OracleConnection.DCN_BEST_EFFORT: "true"/["false"]. If a query has been successfully registered, by default there will be no FALSE positives. If this option is selected during registrations, then registrations on complex queries may still be allowed but notifications may have some FALSE positives, because full pruning may not be performed if determined to be too expensive. In the worst case notifications will be generated in response to any DML/DDL changes to underlying objects. Note that this option is ignored if the DCN_QUERY_CHANGE_NOTIFICATION isn't turned on. As DCN_QUERY_CHANGE_NOTIFICATION, this option is only available in the database server starting in 11.1.
  • OracleConnection.NTF_GROUPING_CLASS: OracleConnection.NTF_GROUPING_CLASS_TIME/[OracleConnection.NTF_GROUPING_CLASS_NONE]. Notification Grouping Class, the criterion or dimension for grouping. The only supported class is OracleConnection.NTF_GROUPING_CLASS_TIME meaning grouping by time, that is, the user specifies a time value and a single notification gets published at the end of that time. To use grouping at least this option must be specified to a value other than the default OracleConnection.NTF_GROUPING_CLASS_NONE, which is no grouping.
  • OracleConnection.NTF_GROUPING_VALUE: "1200/["600"]. Notification Grouping Value, the value of the grouping class. The value must be an integer number. For the TIME grouping class, this value represents a number of seconds, meaning the time after which grouped notifications are sent. If not specified, it defaults to 600 sec.
  • OracleConnection.NTF_GROUPING_TYPE: OracleConnection.NTF_GROUPING_TYPE_LAST/[OracleConnection.NTF_GROUPING_TYPE_SUMMARY]. Notification Grouping Type, the format of grouping notification. It can either contain the summary of all events (default) or the last event in the group.
  • OracleConnection.NTF_GROUPING_START_TIME: When to start grouping? Notification grouping can start from a user-specified time that should a valid timestamp with time zone, that is an instance of oracle.sql.TIMESTAMPTZ. If this option is not specified when using grouping, it defaults to current system time. For example if prop was the option properties, and conn the connection object, you would call: prop.put(OracleConnection.NTF_GROUPING_START_TIME,new TIMESTAMPTZ(conn,"2007-06-21 10:10:00.0"));.
  • OracleConnection.NTF_GROUPING_REPEAT_TIME: "100"/[NTF_GROUPING_REPEAT_FOREVER]. How many times do grouping? Grouping notifications will be sent as many times as specified by the notification grouping repeat count and after that revert to regular notifications. If not specified, it will default to: NTF_GROUPING_REPEAT_FOREVER - keep sending grouping notifications forever.
Returns:
DatabaseChangeRegistration
Throws:
java.sql.SQLException
Since:
11.1

getDatabaseChangeRegistration

DatabaseChangeRegistration getDatabaseChangeRegistration(int regid)
                                                         throws java.sql.SQLException
Maps an existing registration identified by its ID 'regid' with a new DatabaseChangeRegistration object.

This method can be used if you create a registration through PLSQL and you want to associate a JDBC statement with it.

This method doesn't create a new listener on the JDBC driver side and DatabaseChangeEvent won't be created. Thus you won't be allowed to attach any listeners to this registration.

Note that this method doesn't generate any roundtrip to the database.

Parameters:
regid - The id of the registration
Returns:
DatabaseChangeRegistration A new instance that can be used to associate a statement with this registration
Throws:
java.sql.SQLException
Since:
11.1

unregisterDatabaseChangeNotification

void unregisterDatabaseChangeNotification(DatabaseChangeRegistration registration)
                                          throws java.sql.SQLException
Deletes a given database change registration. The registration will be destroyed in the server and in the driver (the network listener will be closed if it's not used anymore).
Parameters:
registration -
Throws:
java.sql.SQLException
Since:
11.1

unregisterDatabaseChangeNotification

void unregisterDatabaseChangeNotification(int registrationId,
                                          java.lang.String host,
                                          int tcpport)
                                          throws java.sql.SQLException
Deletes a given database change registration in the server. This method doesn't free any resources in the drivers.

This method should only be used to close a registration that was created outside of JDBC, for example a registration that was created with PLSQL.

Throws:
java.sql.SQLException
Since:
11.1

unregisterDatabaseChangeNotification

void unregisterDatabaseChangeNotification(int registrationId)
                                          throws java.sql.SQLException
Deletes a given database change registration in the server. This method doesn't free any resources in the drivers.

This method should only be used to close a registration that was created outside of JDBC, for example a registration that was created with PLSQL.

Throws:
java.sql.SQLException
Since:
11.1

createARRAY

ARRAY createARRAY(java.lang.String typeName,
                  java.lang.Object elements)
                  throws java.sql.SQLException
Creates an ARRAY object with the given type name and elements.
Parameters:
typeName - the name of the SQL type of the created object
elements - the elements of the created object
Returns:
an ARRAY
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createBINARY_DOUBLE

BINARY_DOUBLE createBINARY_DOUBLE(double value)
                                  throws java.sql.SQLException
Creates a BINARY_DOUBLE that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new BINARY_DOUBLE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createBINARY_FLOAT

BINARY_FLOAT createBINARY_FLOAT(float value)
                                throws java.sql.SQLException
Creates a BINARY_FLOAT that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new BINARY_FLOAT
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Date value)
                throws java.sql.SQLException
Creates a DATE that has the given value.
Parameters:
value - the value that the new object should repreesnt
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Time value)
                throws java.sql.SQLException
Creates a DATE that has the given value.
Parameters:
value - the value that the new object should repreesnt
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Timestamp value)
                throws java.sql.SQLException
Creates a DATE that has the given value.
Parameters:
value - the value that the new object should repreesnt
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Date value,
                java.util.Calendar cal)
                throws java.sql.SQLException
Creates a DATE that has the given value. The value is interpreted as being in the time zone represented by cal.
Parameters:
value - the value that the new object should repreesnt
cal - the timezone in which the value is interpreted
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Time value,
                java.util.Calendar cal)
                throws java.sql.SQLException
Creates a DATE that has the given value. The value is interpreted as being in the time zone represented by cal.
Parameters:
value - the value that the new object should repreesnt
cal - the timezone in which the value is interpreted
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.sql.Timestamp value,
                java.util.Calendar cal)
                throws java.sql.SQLException
Creates a DATE that has the given value. The value is interpreted as being in the time zone represented by cal.
Parameters:
value - the value that the new object should repreesnt
cal - the timezone in which the value is interpreted
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createDATE

DATE createDATE(java.lang.String value)
                throws java.sql.SQLException
Creates a DATE that has the given value.
Parameters:
value - the value that the new object should repreesnt
Returns:
a new DATE
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createINTERVALDS

INTERVALDS createINTERVALDS(java.lang.String value)
                            throws java.sql.SQLException
Creates an INTERVALDS that has the given value.
Parameters:
value - the value that the new object shoud represent
Returns:
a new INTERVALDS
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createINTERVALYM

INTERVALYM createINTERVALYM(java.lang.String value)
                            throws java.sql.SQLException
Creates an INTERVALYM that has the given value.
Parameters:
value - the value that the new object shoud represent
Returns:
a new INTERVALYM
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(boolean value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(byte value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(short value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(int value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(long value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(float value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(double value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(java.math.BigDecimal value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(java.math.BigInteger value)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createNUMBER

NUMBER createNUMBER(java.lang.String value,
                    int scale)
                    throws java.sql.SQLException
Creates a new NUMBER that has the given value and scale.
Parameters:
value - the value that the new object should represent
scale - the scale of the new object
Returns:
a new NUMBER
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMP

TIMESTAMP createTIMESTAMP(java.sql.Date value)
                          throws java.sql.SQLException
Creates a new TIMESTAMP with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMP
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMP

TIMESTAMP createTIMESTAMP(DATE value)
                          throws java.sql.SQLException
Creates a new TIMESTAMP with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMP
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMP

TIMESTAMP createTIMESTAMP(java.sql.Time value)
                          throws java.sql.SQLException
Creates a new TIMESTAMP with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMP
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMP

TIMESTAMP createTIMESTAMP(java.sql.Timestamp value)
                          throws java.sql.SQLException
Creates a new TIMESTAMP with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMP
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMP

TIMESTAMP createTIMESTAMP(java.lang.String value)
                          throws java.sql.SQLException
Creates a new TIMESTAMP with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMP
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value,
                              java.util.Calendar cal)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value,
                              java.util.Calendar cal)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value,
                              java.util.Calendar cal)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value.
Parameters:
value - the value that the new object should represent
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value,
                              java.util.Calendar cal)
                              throws java.sql.SQLException
Creates a new TIMESTAMPTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPTZ

TIMESTAMPTZ createTIMESTAMPTZ(DATE value)
                              throws java.sql.SQLException
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPLTZ

TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Date value,
                                java.util.Calendar cal)
                                throws java.sql.SQLException
Creates a new TIMESTAMPLTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPLTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPLTZ

TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Time value,
                                java.util.Calendar cal)
                                throws java.sql.SQLException
Creates a new TIMESTAMPLTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPLTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPLTZ

TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Timestamp value,
                                java.util.Calendar cal)
                                throws java.sql.SQLException
Creates a new TIMESTAMPLTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPLTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPLTZ

TIMESTAMPLTZ createTIMESTAMPLTZ(java.lang.String value,
                                java.util.Calendar cal)
                                throws java.sql.SQLException
Creates a new TIMESTAMPLTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPLTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

createTIMESTAMPLTZ

TIMESTAMPLTZ createTIMESTAMPLTZ(DATE value,
                                java.util.Calendar cal)
                                throws java.sql.SQLException
Creates a new TIMESTAMPLTZ with the given value. The value is interpreted in the time zone of the calendar.
Parameters:
value - the value that the new object should represent
cal - the timezone of the value
Returns:
a new TIMESTAMPLTZ
Throws:
java.sql.SQLException - if a database error occurs
Since:
11R1

cancel

void cancel()
            throws java.sql.SQLException
Performs an immediate (asynchronous) termination of any currently executing operation on this connection. It is normally used to stop a long-running JDBC call being processed on the server. It can be called by a user thread in multithreaded applications.

For example, in the context of AQ, it can be used to cancel a 'dequeue' call that is waiting for a new message to be enqueued.

Throws:
java.sql.SQLException - if the cancel operation fails

abort

void abort()
           throws java.sql.SQLException
Calling abort() on an open connection does the following: marks the connection as closed, closes any sockets or other primitive connections to the database, and insures that any thread that is currently accessing the connection will either progress to completion of the JDBC call or throw an exception. Calling abort() on a closed connection does nothing. It is critical to note that abort() does not hang. It does not block because of pending database operations. In particular it is not synchronized. Since typically abort() will be called when it appears that the connection is dead, any attempt to communicate with the database via blocking IO is likely to hang and is not attempted. As such, abort leaves the connection in a unknown state. Although abort marks the connection as closed, it does not release any local resources as it cannot do so safely; it is not synchronized. It is recommended to call Connection.close() after calling abort. Connection.close() will recognize that connection has been aborted and will clean up local resources, even though the connection has already been marked as closed. Since Connection.close is synchronized it may hang briefly while any thread that has a lock on the connection completes and releases the lock. Recall that after calling abort any thread that is using the connection will be able to proceed to completion or will throw an exception. abort is very different from OracleConnection.cancel. cancel gracefully stops the execution of any SQL operation. It is a synchronous operation that communicates with the database. It leaves the connection and the statements in a well-known and usable state. In contrast abort tears down the client side network connection to the database, leaving the server to clean up as best it can whenever it discovers that the connection has been broken. abort does not clean up client side resources and leaves the connection and associated statements in an unknown and unusable state. The only valid thing to do with a connection after calling abort is to call close and then discard the connection object. After calling cancel the app can continue to use the connection and statements. If there is a security manager, its checkPermission method is called with an oracle.jdbc.OracleSQLPermission("callAbort") permission to see if the caller has permission to abort a connection. If the caller does not have permission, a SecurityException is thrown. See the ojdbc.policy file in the demo directory for help in granting the appropriate permissions when using a SecurityManager with Oracle JDBC. The best use of the abort() call is in the layer that manages connections such as the connection pool. Stale or invalid connections may often appear to hang when an application thread is blocked on a network call. Connection pools may implement a cleaner thread, that simply looks for such stale connections and issues the abort() call. This results in releasing all client handles and resources without expecting an acknowledgement from the database backend. There is no need for user code to call abort when using an Oracle connection pool such as the Implicit Connection Cache or the Universal Connection Pool as these connection pools will call abort when necessary.
Throws:
java.sql.SQLException - -- Io Exception: Socket closed - ORA-17002 TNS:not connected - ORA-12153
java.lang.SecurityException - if the caller does not have the necessary permission
Since:
11.0

getAllTypeDescriptorsInCurrentSchema

TypeDescriptor[] getAllTypeDescriptorsInCurrentSchema()
                                                      throws java.sql.SQLException
Obtain all the type descriptors associated with object types or array in the schema of this connection. Note that synonyms are not suportted. Requires an internal PL/SQL package that is present only in database 11 and above.
Returns:
An array of the appropriate descriptors for Arrays or Structs depending on the type names found.
Throws:
java.sql.SQLException - If an error occurs.
Since:
11.1

getTypeDescriptorsFromListInCurrentSchema

TypeDescriptor[] getTypeDescriptorsFromListInCurrentSchema(java.lang.String[] typeNames)
                                                           throws java.sql.SQLException
Obtain the type descriptors associated with object types or array in a schema from an array of type names. Note that synonyms are not suportted. Requires an internal PL/SQL package that is present only in database 11 and above.
Parameters:
An - array of Strings which are type names. Use upper case unless the type names are mixed case names.
Returns:
An array of the appropriate descriptors for Arrays or Structs depending on the type names found.
Throws:
java.sql.SQLException - if the specified type does not exist, or if an error occurred.
Since:
11.1

getTypeDescriptorsFromList

TypeDescriptor[] getTypeDescriptorsFromList(java.lang.String[][] schemaAndTypeNamePairs)
                                            throws java.sql.SQLException
Obtain the type descriptors associated with object types or arrays from an array of scheama and type names. Note that synonyms are not suportted. Requires an internal PL/SQL package that is present only in database 11 and above.
Parameters:
An - array of arrays of Strings which are pairs of schema and type names.
Returns:
An array of the appropriate descriptors for Arrays or Structs depending on the type names found.
Throws:
java.sql.SQLException - if any of the specified types does not exist, or if an error occurs.
Since:
11.1

getDataIntegrityAlgorithmName

java.lang.String getDataIntegrityAlgorithmName()
                                               throws java.sql.SQLException
Returns the name of the algorithm that is used for data integrity checking by the thin driver on the network. Returns "" when there is no data integrity checking.
Throws:
java.sql.SQLException

getEncryptionAlgorithmName

java.lang.String getEncryptionAlgorithmName()
                                            throws java.sql.SQLException
Returns the name of the algorithm that is used for data encryption by the thin driver on the network. Returns "" when the data isn't encrypted on the network.
Throws:
java.sql.SQLException

getAuthenticationAdaptorName

java.lang.String getAuthenticationAdaptorName()
                                              throws java.sql.SQLException
Returns the name of the adaptor that is used for authentication by the thin driver. Returns "" for basic user/password authenticatin.
Throws:
java.sql.SQLException

isUsable

boolean isUsable()
Identifies whether this connection is still usable for JDBC operations.
Returns:
true if this connection is usable; false otherwise.

setDefaultTimeZone

void setDefaultTimeZone(java.util.TimeZone tz)
                        throws java.sql.SQLException
The TimeZone to be used while creating java.sql.Date, java.sql.Time & java.sql.Timestamp.
Parameters:
Default - TimeZone to be used for all Date, Time and Timestamp conversions.
Throws:
java.sql.SQLException - if there is an issue while setting the TimeZone

getDefaultTimeZone

java.util.TimeZone getDefaultTimeZone()
                                      throws java.sql.SQLException
Returns the TimeZone set through setDefaultTimeZone.
Returns:
TimeZone set through setDefaultTimeZone. Returns null if TimeZone if setDefaultTimeZone in not invoked with proper values.
Throws:
java.sql.SQLException - If there is any issue while retrieving the TimeZone

Skip navigation links

Oracle® Database JDBC Java API Reference
11g Release 2

E13995-02


Copyright © 2009, Oracle and/or its affiliates. All rights reserved.