public class OracleConnectionWrapper extends java.lang.Object implements OracleConnection
Modifier and Type | Class and Description |
---|---|
protected class |
OracleConnectionWrapper.CloseInvocationHandler |
OracleConnection.CommitOption, OracleConnection.ConnectionValidation, OracleConnection.DatabaseShutdownMode, OracleConnection.DatabaseStartupMode, OracleConnection.DRCPState
Modifier and Type | Field and Description |
---|---|
protected OracleConnection |
connection
The connection that this wrapper wraps
|
ABANDONED_CONNECTION_CALLBACK, ACCESSMODE_BOTH, ACCESSMODE_FILEPROP, ACCESSMODE_JAVAPROP, ACCESSMODE_PROVIDER, ACCESSMODE_SYSTEMPROP, ALL_CONNECTION_CALLBACKS, AQ_USE_HOST_CONNECTION_ADDR_INFO, CACHE_SIZE_NOT_SET, CLIENT_INFO_KEY_SEPARATOR, CONNECTION_PROPERTY_ACCESS_TOKEN, CONNECTION_PROPERTY_ACCESS_TOKEN_ACCESSMODE, CONNECTION_PROPERTY_ACCESS_TOKEN_DEFAULT, CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT, CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_ACCESSMODE, CONNECTION_PROPERTY_ACCUMULATE_BATCH_RESULT_DEFAULT, CONNECTION_PROPERTY_ALLOW_MIXING_JDBC_AND_NAMED_BINDS, CONNECTION_PROPERTY_ALLOW_MIXING_JDBC_AND_NAMED_BINDS_ACCESSMODE, CONNECTION_PROPERTY_ALLOW_MIXING_JDBC_AND_NAMED_BINDS_DEFAULT, CONNECTION_PROPERTY_ALLOW_SINGLE_SHARD_TRANSACTION_SUPPORT, CONNECTION_PROPERTY_ALLOW_SINGLE_SHARD_TRANSACTION_SUPPORT_ACCESSMODE, CONNECTION_PROPERTY_ALLOW_SINGLE_SHARD_TRANSACTION_SUPPORT_DEFAULT, CONNECTION_PROPERTY_ALLOWED_LOGON_VERSION, CONNECTION_PROPERTY_ALLOWED_LOGON_VERSION_ACCESSMODE, CONNECTION_PROPERTY_ALLOWED_LOGON_VERSION_DEFAULT, CONNECTION_PROPERTY_AUTO_COMMIT_SPEC_COMPLIANT, CONNECTION_PROPERTY_AUTO_COMMIT_SPEC_COMPLIANT_ACCESSMODE, CONNECTION_PROPERTY_AUTO_COMMIT_SPEC_COMPLIANT_DEFAULT, CONNECTION_PROPERTY_AUTOCOMMIT, CONNECTION_PROPERTY_AUTOCOMMIT_ACCESSMODE, CONNECTION_PROPERTY_AUTOCOMMIT_DEFAULT, CONNECTION_PROPERTY_AZURE_DB_APP_ID_URI, CONNECTION_PROPERTY_AZURE_DB_APP_ID_URI_ACCESSMODE, CONNECTION_PROPERTY_AZURE_DB_APP_ID_URI_DEFAULT, CONNECTION_PROPERTY_BACKWARD_COMPATIBLE_UPDATEABLE_RESULTSET, CONNECTION_PROPERTY_BACKWARD_COMPATIBLE_UPDATEABLE_RESULTSET_ACCESSMODE, CONNECTION_PROPERTY_BACKWARD_COMPATIBLE_UPDATEABLE_RESULTSET_DEFAULT, CONNECTION_PROPERTY_CLIENT_CERTIFICATE, CONNECTION_PROPERTY_CLIENT_CERTIFICATE_ACCESSMODE, CONNECTION_PROPERTY_CLIENT_CERTIFICATE_DEFAULT, CONNECTION_PROPERTY_CLIENT_CERTIFICATE_PASSWORD, CONNECTION_PROPERTY_CLIENT_CERTIFICATE_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_CLIENT_CERTIFICATE_PASSWORD_DEFAULT, CONNECTION_PROPERTY_CLIENT_ID, CONNECTION_PROPERTY_CLIENT_ID_ACCESSMODE, CONNECTION_PROPERTY_CLIENT_ID_DEFAULT, CONNECTION_PROPERTY_CLIENT_SECRET, CONNECTION_PROPERTY_CLIENT_SECRET_ACCESSMODE, CONNECTION_PROPERTY_CLIENT_SECRET_DEFAULT, CONNECTION_PROPERTY_COMMIT_OPTION, CONNECTION_PROPERTY_COMMIT_OPTION_ACCESSMODE, CONNECTION_PROPERTY_COMMIT_OPTION_DEFAULT, CONNECTION_PROPERTY_COMMIT_SELECT_ON_AUTOCOMMIT, CONNECTION_PROPERTY_COMMIT_SELECT_ON_AUTOCOMMIT_ACCESSMODE, CONNECTION_PROPERTY_COMMIT_SELECT_ON_AUTOCOMMIT_DEFAULT, CONNECTION_PROPERTY_CONFIG_FILE, CONNECTION_PROPERTY_CONFIG_FILE_ACCESSMODE, CONNECTION_PROPERTY_CONFIG_FILE_DEFAULT, CONNECTION_PROPERTY_CONFIGURATION_PROVIDERS, CONNECTION_PROPERTY_CONFIGURATION_PROVIDERS_ACCESSMODE, CONNECTION_PROPERTY_CONFIGURATION_PROVIDERS_DEFAULT, CONNECTION_PROPERTY_CONNECTION_CLASS, CONNECTION_PROPERTY_CONNECTION_CLASS_ACCESSMODE, CONNECTION_PROPERTY_CONNECTION_CLASS_DEFAULT, CONNECTION_PROPERTY_CONNECTION_PURITY, CONNECTION_PROPERTY_CONNECTION_PURITY_ACCESSMODE, CONNECTION_PROPERTY_CONNECTION_PURITY_DEFAULT, CONNECTION_PROPERTY_CONTINUE_BATCH_ON_ERROR, CONNECTION_PROPERTY_CONTINUE_BATCH_ON_ERROR_ACCESSMODE, CONNECTION_PROPERTY_CONTINUE_BATCH_ON_ERROR_DEFAULT, CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS, CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_ACCESSMODE, CONNECTION_PROPERTY_CONVERT_NCHAR_LITERALS_DEFAULT, CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME, CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_ACCESSMODE, CONNECTION_PROPERTY_CREATE_DESCRIPTOR_USE_CURRENT_SCHEMA_FOR_SCHEMA_NAME_DEFAULT, CONNECTION_PROPERTY_DATABASE, CONNECTION_PROPERTY_DATABASE_ACCESSMODE, CONNECTION_PROPERTY_DATABASE_DEFAULT, CONNECTION_PROPERTY_DATABASE_STATE_REQUIREMENT, CONNECTION_PROPERTY_DATABASE_STATE_REQUIREMENT_ACCESSMODE, CONNECTION_PROPERTY_DATABASE_STATE_REQUIREMENT_DEFAULT, CONNECTION_PROPERTY_DEBUG_SQL, CONNECTION_PROPERTY_DEBUG_SQL_ACCESSMODE, CONNECTION_PROPERTY_DEBUG_SQL_DEFAULT, CONNECTION_PROPERTY_DEBUG_TENANT, CONNECTION_PROPERTY_DEBUG_TENANT_ACCESSMODE, CONNECTION_PROPERTY_DEBUG_TENANT_DEFAULT, CONNECTION_PROPERTY_DEFAULT_CONNECTION_VALIDATION, CONNECTION_PROPERTY_DEFAULT_CONNECTION_VALIDATION_ACCESSMODE, CONNECTION_PROPERTY_DEFAULT_CONNECTION_VALIDATION_DEFAULT, CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH, CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_ACCESSMODE, CONNECTION_PROPERTY_DEFAULT_EXECUTE_BATCH_DEFAULT, CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE, CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_ACCESSMODE, CONNECTION_PROPERTY_DEFAULT_LOB_PREFETCH_SIZE_DEFAULT, CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH, CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_ACCESSMODE, CONNECTION_PROPERTY_DEFAULT_ROW_PREFETCH_DEFAULT, CONNECTION_PROPERTY_DEFAULT_USE_NIO, CONNECTION_PROPERTY_DEFAULT_USE_NIO_ACCESSMODE, CONNECTION_PROPERTY_DEFAULT_USE_NIO_DEFAULT, CONNECTION_PROPERTY_DEFAULTNCHAR, CONNECTION_PROPERTY_DEFAULTNCHAR_ACCESSMODE, CONNECTION_PROPERTY_DEFAULTNCHAR_DEFAULT, CONNECTION_PROPERTY_DIAGNOSTIC_BUFFER_SIZE, CONNECTION_PROPERTY_DIAGNOSTIC_BUFFER_SIZE_ACCESSMODE, CONNECTION_PROPERTY_DIAGNOSTIC_BUFFER_SIZE_DEFAULT, CONNECTION_PROPERTY_DIAGNOSTIC_LOGGER_NAME, CONNECTION_PROPERTY_DIAGNOSTIC_LOGGER_NAME_ACCESSMODE, CONNECTION_PROPERTY_DIAGNOSTIC_LOGGER_NAME_DEFAULT, CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE, CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_ACCESSMODE, CONNECTION_PROPERTY_DISABLE_DEFINECOLUMNTYPE_DEFAULT, CONNECTION_PROPERTY_DISABLED_BUG_FIXES, CONNECTION_PROPERTY_DISABLED_BUG_FIXES_ACCESSMODE, CONNECTION_PROPERTY_DISABLED_BUG_FIXES_DEFAULT, CONNECTION_PROPERTY_DMS_PARENT_NAME, CONNECTION_PROPERTY_DMS_PARENT_NAME_ACCESSMODE, CONNECTION_PROPERTY_DMS_PARENT_NAME_DEFAULT, CONNECTION_PROPERTY_DMS_PARENT_TYPE, CONNECTION_PROPERTY_DMS_PARENT_TYPE_ACCESSMODE, CONNECTION_PROPERTY_DMS_PARENT_TYPE_DEFAULT, CONNECTION_PROPERTY_DMS_STMT_CACHING_METRICS, CONNECTION_PROPERTY_DMS_STMT_CACHING_METRICS_ACCESSMODE, CONNECTION_PROPERTY_DMS_STMT_CACHING_METRICS_DEFAULT, CONNECTION_PROPERTY_DMS_STMT_METRICS, CONNECTION_PROPERTY_DMS_STMT_METRICS_ACCESSMODE, CONNECTION_PROPERTY_DMS_STMT_METRICS_DEFAULT, CONNECTION_PROPERTY_DOWN_HOSTS_TIMEOUT, CONNECTION_PROPERTY_DOWN_HOSTS_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_DOWN_HOSTS_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_DRCP_MULTIPLEXING_IN_REQUEST_APIS, CONNECTION_PROPERTY_DRCP_MULTIPLEXING_IN_REQUEST_APIS_ACCESSMODE, CONNECTION_PROPERTY_DRCP_MULTIPLEXING_IN_REQUEST_APIS_DEFAULT, CONNECTION_PROPERTY_DRCP_PLSQL_CALLBACK, CONNECTION_PROPERTY_DRCP_PLSQL_CALLBACK_ACCESSMODE, CONNECTION_PROPERTY_DRCP_PLSQL_CALLBACK_DEFAULT, CONNECTION_PROPERTY_DRCP_TAG_NAME, CONNECTION_PROPERTY_DRCP_TAG_NAME_ACCESSMODE, CONNECTION_PROPERTY_DRCP_TAG_NAME_DEFAULT, CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE, CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_ACCESSMODE, CONNECTION_PROPERTY_DRIVER_NAME_ATTRIBUTE_DEFAULT, CONNECTION_PROPERTY_EDITION_NAME, CONNECTION_PROPERTY_EDITION_NAME_ACCESSMODE, CONNECTION_PROPERTY_EDITION_NAME_DEFAULT, CONNECTION_PROPERTY_ENABLE_AC_SUPPORT, CONNECTION_PROPERTY_ENABLE_AC_SUPPORT_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_AC_SUPPORT_DEFAULT, CONNECTION_PROPERTY_ENABLE_DATA_IN_LOCATOR, CONNECTION_PROPERTY_ENABLE_DATA_IN_LOCATOR_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_DATA_IN_LOCATOR_DEFAULT, CONNECTION_PROPERTY_ENABLE_DIAGNOSE_FIRST_FAILURE, CONNECTION_PROPERTY_ENABLE_DIAGNOSE_FIRST_FAILURE_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_DIAGNOSE_FIRST_FAILURE_DEFAULT, CONNECTION_PROPERTY_ENABLE_ERROR_URL, CONNECTION_PROPERTY_ENABLE_ERROR_URL_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_ERROR_URL_DEFAULT, CONNECTION_PROPERTY_ENABLE_IMPLICIT_REQUESTS, CONNECTION_PROPERTY_ENABLE_IMPLICIT_REQUESTS_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_IMPLICIT_REQUESTS_DEFAULT, CONNECTION_PROPERTY_ENABLE_LOGGING, CONNECTION_PROPERTY_ENABLE_LOGGING_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_LOGGING_DEFAULT, CONNECTION_PROPERTY_ENABLE_OBSERVABILITY, CONNECTION_PROPERTY_ENABLE_OBSERVABILITY_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_OBSERVABILITY_DEFAULT, CONNECTION_PROPERTY_ENABLE_QUERY_RESULT_CACHE, CONNECTION_PROPERTY_ENABLE_QUERY_RESULT_CACHE_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_QUERY_RESULT_CACHE_DEFAULT, CONNECTION_PROPERTY_ENABLE_READ_DATA_IN_LOCATOR, CONNECTION_PROPERTY_ENABLE_READ_DATA_IN_LOCATOR_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_READ_DATA_IN_LOCATOR_DEFAULT, CONNECTION_PROPERTY_ENABLE_RESULTSET_CACHE, CONNECTION_PROPERTY_ENABLE_RESULTSET_CACHE_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_RESULTSET_CACHE_DEFAULT, CONNECTION_PROPERTY_ENABLE_SENSITIVE_DIAGNOSTICS, CONNECTION_PROPERTY_ENABLE_SENSITIVE_DIAGNOSTICS_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_SENSITIVE_DIAGNOSTICS_DEFAULT, CONNECTION_PROPERTY_ENABLE_SSS_CURSOR, CONNECTION_PROPERTY_ENABLE_SSS_CURSOR_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_SSS_CURSOR_DEFAULT, CONNECTION_PROPERTY_ENABLE_TEMP_LOB_REF_COUNT, CONNECTION_PROPERTY_ENABLE_TEMP_LOB_REF_COUNT_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_TEMP_LOB_REF_COUNT_DEFAULT, CONNECTION_PROPERTY_ENABLE_TG_SUPPORT, CONNECTION_PROPERTY_ENABLE_TG_SUPPORT_ACCESSMODE, CONNECTION_PROPERTY_ENABLE_TG_SUPPORT_DEFAULT, CONNECTION_PROPERTY_FAN_ENABLED, CONNECTION_PROPERTY_FAN_ENABLED_ACCESSMODE, CONNECTION_PROPERTY_FAN_ENABLED_DEFAULT, CONNECTION_PROPERTY_FETCH_SIZE_TUNING, CONNECTION_PROPERTY_FETCH_SIZE_TUNING_ACCESSMODE, CONNECTION_PROPERTY_FETCH_SIZE_TUNING_DEFAULT, CONNECTION_PROPERTY_FIXED_STRING, CONNECTION_PROPERTY_FIXED_STRING_ACCESSMODE, CONNECTION_PROPERTY_FIXED_STRING_DEFAULT, CONNECTION_PROPERTY_IMPLICIT_STATEMENT_CACHE_SIZE, CONNECTION_PROPERTY_IMPLICIT_STATEMENT_CACHE_SIZE_ACCESSMODE, CONNECTION_PROPERTY_IMPLICIT_STATEMENT_CACHE_SIZE_DEFAULT, CONNECTION_PROPERTY_IN_BAND_NOTIFICATION, CONNECTION_PROPERTY_IN_BAND_NOTIFICATION_ACCESSMODE, CONNECTION_PROPERTY_IN_BAND_NOTIFICATION_DEFAULT, CONNECTION_PROPERTY_INCLUDE_SYNONYMS, CONNECTION_PROPERTY_INCLUDE_SYNONYMS_ACCESSMODE, CONNECTION_PROPERTY_INCLUDE_SYNONYMS_DEFAULT, CONNECTION_PROPERTY_INTERNAL_LOGON, CONNECTION_PROPERTY_INTERNAL_LOGON_ACCESSMODE, CONNECTION_PROPERTY_INTERNAL_LOGON_DEFAULT, CONNECTION_PROPERTY_J2EE13_COMPLIANT, CONNECTION_PROPERTY_J2EE13_COMPLIANT_ACCESSMODE, CONNECTION_PROPERTY_J2EE13_COMPLIANT_DEFAULT, CONNECTION_PROPERTY_JDBC_STANDARD_BEHAVIOR, CONNECTION_PROPERTY_JDBC_STANDARD_BEHAVIOR_ACCESSMODE, CONNECTION_PROPERTY_JDBC_STANDARD_BEHAVIOR_DEFAULT, CONNECTION_PROPERTY_JSON_DEFAULT_GET_OBJECT_TYPE, CONNECTION_PROPERTY_JSON_DEFAULT_GET_OBJECT_TYPE_ACCESSMODE, CONNECTION_PROPERTY_JSON_DEFAULT_GET_OBJECT_TYPE_DEFAULT, CONNECTION_PROPERTY_LOB_STREAM_POS_STANDARD_COMPLIANT, CONNECTION_PROPERTY_LOB_STREAM_POS_STANDARD_COMPLIANT_ACCESSMODE, CONNECTION_PROPERTY_LOB_STREAM_POS_STANDARD_COMPLIANT_DEFAULT, CONNECTION_PROPERTY_LOCAL_HOST_NAME, CONNECTION_PROPERTY_LOCAL_HOST_NAME_ACCESSMODE, CONNECTION_PROPERTY_LOCAL_HOST_NAME_DEFAULT, CONNECTION_PROPERTY_LOGIN_TIMEOUT, CONNECTION_PROPERTY_LOGIN_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_LOGIN_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP, CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_ACCESSMODE, CONNECTION_PROPERTY_MAP_DATE_TO_TIMESTAMP_DEFAULT, CONNECTION_PROPERTY_MAX_BATCH_MEMORY, CONNECTION_PROPERTY_MAX_BATCH_MEMORY_ACCESSMODE, CONNECTION_PROPERTY_MAX_BATCH_MEMORY_DEFAULT, CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE, CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_ACCESSMODE, CONNECTION_PROPERTY_MAX_CACHED_BUFFER_SIZE_DEFAULT, CONNECTION_PROPERTY_NET_KEEPALIVE, CONNECTION_PROPERTY_NET_KEEPALIVE_ACCESSMODE, CONNECTION_PROPERTY_NET_KEEPALIVE_DEFAULT, CONNECTION_PROPERTY_NET_USE_TCP_FAST_OPEN, CONNECTION_PROPERTY_NET_USE_TCP_FAST_OPEN_ACCESSMODE, CONNECTION_PROPERTY_NET_USE_TCP_FAST_OPEN_DEFAULT, CONNECTION_PROPERTY_NETWORK_COMPRESSION, CONNECTION_PROPERTY_NETWORK_COMPRESSION_ACCESSMODE, CONNECTION_PROPERTY_NETWORK_COMPRESSION_DEFAULT, CONNECTION_PROPERTY_NETWORK_COMPRESSION_LEVELS, CONNECTION_PROPERTY_NETWORK_COMPRESSION_LEVELS_ACCESSMODE, CONNECTION_PROPERTY_NETWORK_COMPRESSION_LEVELS_DEFAULT, CONNECTION_PROPERTY_NETWORK_COMPRESSION_THRESHOLD, CONNECTION_PROPERTY_NETWORK_COMPRESSION_THRESHOLD_ACCESSMODE, CONNECTION_PROPERTY_NETWORK_COMPRESSION_THRESHOLD_DEFAULT, CONNECTION_PROPERTY_NEW_PASSWORD, CONNECTION_PROPERTY_NEW_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_NEW_PASSWORD_DEFAULT, CONNECTION_PROPERTY_OCI_COMPARTMENT, CONNECTION_PROPERTY_OCI_COMPARTMENT_ACCESSMODE, CONNECTION_PROPERTY_OCI_COMPARTMENT_DEFAULT, CONNECTION_PROPERTY_OCI_CONFIG_FILE, CONNECTION_PROPERTY_OCI_CONFIG_FILE_ACCESSMODE, CONNECTION_PROPERTY_OCI_CONFIG_FILE_DEFAULT, CONNECTION_PROPERTY_OCI_DATABASE, CONNECTION_PROPERTY_OCI_DATABASE_ACCESSMODE, CONNECTION_PROPERTY_OCI_DATABASE_DEFAULT, CONNECTION_PROPERTY_OCI_DRIVER_CHARSET, CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_ACCESSMODE, CONNECTION_PROPERTY_OCI_DRIVER_CHARSET_DEFAULT, CONNECTION_PROPERTY_OCI_ENV_HANDLE, CONNECTION_PROPERTY_OCI_ENV_HANDLE_ACCESSMODE, CONNECTION_PROPERTY_OCI_ENV_HANDLE_DEFAULT, CONNECTION_PROPERTY_OCI_ERR_HANDLE, CONNECTION_PROPERTY_OCI_ERR_HANDLE_ACCESSMODE, CONNECTION_PROPERTY_OCI_ERR_HANDLE_DEFAULT, CONNECTION_PROPERTY_OCI_EXTERNAL_AUTHENTICATION, CONNECTION_PROPERTY_OCI_EXTERNAL_AUTHENTICATION_ACCESSMODE, CONNECTION_PROPERTY_OCI_EXTERNAL_AUTHENTICATION_DEFAULT, CONNECTION_PROPERTY_OCI_IAM_URL, CONNECTION_PROPERTY_OCI_IAM_URL_ACCESSMODE, CONNECTION_PROPERTY_OCI_IAM_URL_DEFAULT, CONNECTION_PROPERTY_OCI_PROFILE, CONNECTION_PROPERTY_OCI_PROFILE_ACCESSMODE, CONNECTION_PROPERTY_OCI_PROFILE_DEFAULT, CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE, CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_ACCESSMODE, CONNECTION_PROPERTY_OCI_SVC_CTX_HANDLE_DEFAULT, CONNECTION_PROPERTY_OCI_TENANCY, CONNECTION_PROPERTY_OCI_TENANCY_ACCESSMODE, CONNECTION_PROPERTY_OCI_TENANCY_DEFAULT, CONNECTION_PROPERTY_ONS_PROTOCOL, CONNECTION_PROPERTY_ONS_PROTOCOL_ACCESSMODE, CONNECTION_PROPERTY_ONS_PROTOCOL_DEFAULT, CONNECTION_PROPERTY_ONS_WALLET_FILE, CONNECTION_PROPERTY_ONS_WALLET_FILE_ACCESSMODE, CONNECTION_PROPERTY_ONS_WALLET_FILE_DEFAULT, CONNECTION_PROPERTY_ONS_WALLET_PASSWORD, CONNECTION_PROPERTY_ONS_WALLET_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_ONS_WALLET_PASSWORD_DEFAULT, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_INCLUDE_PARSING, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_INCLUDE_PARSING_ACCESSMODE, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_INCLUDE_PARSING_DEFAULT, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_SIZE, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_SIZE_ACCESSMODE, CONNECTION_PROPERTY_PARAMETER_METADATA_CACHE_SIZE_DEFAULT, CONNECTION_PROPERTY_PARAMETER_METADATA_PREPROCESS, CONNECTION_PROPERTY_PARAMETER_METADATA_PREPROCESS_ACCESSMODE, CONNECTION_PROPERTY_PARAMETER_METADATA_PREPROCESS_DEFAULT, CONNECTION_PROPERTY_PASSWORD, CONNECTION_PROPERTY_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_PASSWORD_AUTHENTICATION, CONNECTION_PROPERTY_PASSWORD_AUTHENTICATION_ACCESSMODE, CONNECTION_PROPERTY_PASSWORD_AUTHENTICATION_DEFAULT, CONNECTION_PROPERTY_PASSWORD_DEFAULT, CONNECTION_PROPERTY_PERMIT_SENSITIVE_DIAGNOSTICS, CONNECTION_PROPERTY_PERMIT_SENSITIVE_DIAGNOSTICS_ACCESSMODE, CONNECTION_PROPERTY_PERMIT_SENSITIVE_DIAGNOSTICS_DEFAULT, CONNECTION_PROPERTY_PRELIM_AUTH, CONNECTION_PROPERTY_PRELIM_AUTH_ACCESSMODE, CONNECTION_PROPERTY_PRELIM_AUTH_DEFAULT, CONNECTION_PROPERTY_PROCESS_ESCAPES, CONNECTION_PROPERTY_PROCESS_ESCAPES_ACCESSMODE, CONNECTION_PROPERTY_PROCESS_ESCAPES_DEFAULT, CONNECTION_PROPERTY_PROTOCOL, CONNECTION_PROPERTY_PROTOCOL_ACCESSMODE, CONNECTION_PROPERTY_PROTOCOL_DEFAULT, CONNECTION_PROPERTY_PROVIDER_ACCESS_TOKEN, CONNECTION_PROPERTY_PROVIDER_ACCESS_TOKEN_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_ACCESS_TOKEN_DEFAULT, CONNECTION_PROPERTY_PROVIDER_CONNECTION_STRING, CONNECTION_PROPERTY_PROVIDER_CONNECTION_STRING_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_CONNECTION_STRING_DEFAULT, CONNECTION_PROPERTY_PROVIDER_OSON, CONNECTION_PROPERTY_PROVIDER_OSON_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_OSON_DEFAULT, CONNECTION_PROPERTY_PROVIDER_PASSWORD, CONNECTION_PROPERTY_PROVIDER_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_PASSWORD_DEFAULT, CONNECTION_PROPERTY_PROVIDER_TLS_CONFIGURATION, CONNECTION_PROPERTY_PROVIDER_TLS_CONFIGURATION_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_TLS_CONFIGURATION_DEFAULT, CONNECTION_PROPERTY_PROVIDER_TRACE_EVENT_LISTENER, CONNECTION_PROPERTY_PROVIDER_TRACE_EVENT_LISTENER_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_TRACE_EVENT_LISTENER_DEFAULT, CONNECTION_PROPERTY_PROVIDER_USERNAME, CONNECTION_PROPERTY_PROVIDER_USERNAME_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_USERNAME_DEFAULT, CONNECTION_PROPERTY_PROXY_CLIENT_NAME, CONNECTION_PROPERTY_PROXY_CLIENT_NAME_ACCESSMODE, CONNECTION_PROPERTY_PROXY_CLIENT_NAME_DEFAULT, CONNECTION_PROPERTY_PROXY_REMOTE_DNS, CONNECTION_PROPERTY_PROXY_REMOTE_DNS_ACCESSMODE, CONNECTION_PROPERTY_PROXY_REMOTE_DNS_DEFAULT, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_LAG, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_LAG_ACCESSMODE, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_LAG_DEFAULT, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_SIZE, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_SIZE_ACCESSMODE, CONNECTION_PROPERTY_QUERY_RESULT_CACHE_MAX_SIZE_DEFAULT, CONNECTION_PROPERTY_READONLY_INSTANCE_ALLOWED, CONNECTION_PROPERTY_READONLY_INSTANCE_ALLOWED_ACCESSMODE, CONNECTION_PROPERTY_READONLY_INSTANCE_ALLOWED_DEFAULT, CONNECTION_PROPERTY_REDIRECT_URI, CONNECTION_PROPERTY_REDIRECT_URI_ACCESSMODE, CONNECTION_PROPERTY_REDIRECT_URI_DEFAULT, CONNECTION_PROPERTY_REMOTE_CONFIGURATION_FILTERING, CONNECTION_PROPERTY_REMOTE_CONFIGURATION_FILTERING_ACCESSMODE, CONNECTION_PROPERTY_REMOTE_CONFIGURATION_FILTERING_DEFAULT, CONNECTION_PROPERTY_REPORT_REMARKS, CONNECTION_PROPERTY_REPORT_REMARKS_ACCESSMODE, CONNECTION_PROPERTY_REPORT_REMARKS_DEFAULT, CONNECTION_PROPERTY_REQUEST_SIZE_LIMIT, CONNECTION_PROPERTY_REQUEST_SIZE_LIMIT_ACCESSMODE, CONNECTION_PROPERTY_REQUEST_SIZE_LIMIT_DEFAULT, CONNECTION_PROPERTY_RESOURCE_MANAGER_ID, CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_ACCESSMODE, CONNECTION_PROPERTY_RESOURCE_MANAGER_ID_DEFAULT, CONNECTION_PROPERTY_RESTRICT_GETTABLES, CONNECTION_PROPERTY_RESTRICT_GETTABLES_ACCESSMODE, CONNECTION_PROPERTY_RESTRICT_GETTABLES_DEFAULT, CONNECTION_PROPERTY_RETAIN_LOB_PREFETCH_DATA, CONNECTION_PROPERTY_RETAIN_LOB_PREFETCH_DATA_ACCESSMODE, CONNECTION_PROPERTY_RETAIN_LOB_PREFETCH_DATA_DEFAULT, CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR, CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_ACCESSMODE, CONNECTION_PROPERTY_RETAIN_V9_BIND_BEHAVIOR_DEFAULT, CONNECTION_PROPERTY_SEND_ALL_DATA_FOR_VALUE_LOBS, CONNECTION_PROPERTY_SEND_ALL_DATA_FOR_VALUE_LOBS_ACCESSMODE, CONNECTION_PROPERTY_SEND_ALL_DATA_FOR_VALUE_LOBS_DEFAULT, CONNECTION_PROPERTY_SEND_BOOLEAN_AS_NATIVE_BOOLEAN, CONNECTION_PROPERTY_SEND_BOOLEAN_AS_NATIVE_BOOLEAN_ACCESSMODE, CONNECTION_PROPERTY_SEND_BOOLEAN_AS_NATIVE_BOOLEAN_DEFAULT, CONNECTION_PROPERTY_SEND_BOOLEAN_IN_PLSQL, CONNECTION_PROPERTY_SEND_BOOLEAN_IN_PLSQL_ACCESSMODE, CONNECTION_PROPERTY_SEND_BOOLEAN_IN_PLSQL_DEFAULT, CONNECTION_PROPERTY_SERVER, CONNECTION_PROPERTY_SERVER_ACCESSMODE, CONNECTION_PROPERTY_SERVER_DEFAULT, CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY, CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_ACCESSMODE, CONNECTION_PROPERTY_SET_FLOAT_AND_DOUBLE_USE_BINARY_DEFAULT, CONNECTION_PROPERTY_SOCKS_PROXY_HOST, CONNECTION_PROPERTY_SOCKS_PROXY_HOST_ACCESSMODE, CONNECTION_PROPERTY_SOCKS_PROXY_HOST_DEFAULT, CONNECTION_PROPERTY_SOCKS_PROXY_PORT, CONNECTION_PROPERTY_SOCKS_PROXY_PORT_ACCESSMODE, CONNECTION_PROPERTY_SOCKS_PROXY_PORT_DEFAULT, CONNECTION_PROPERTY_SOCKS_REMOTE_DNS, CONNECTION_PROPERTY_SOCKS_REMOTE_DNS_ACCESSMODE, CONNECTION_PROPERTY_SOCKS_REMOTE_DNS_DEFAULT, CONNECTION_PROPERTY_SQL_ERROR_TRANSLATION_FILE, CONNECTION_PROPERTY_SQL_ERROR_TRANSLATION_FILE_ACCESSMODE, CONNECTION_PROPERTY_SQL_ERROR_TRANSLATION_FILE_DEFAULT, CONNECTION_PROPERTY_SQL_TRANSLATION_PROFILE, CONNECTION_PROPERTY_SQL_TRANSLATION_PROFILE_ACCESSMODE, CONNECTION_PROPERTY_SQL_TRANSLATION_PROFILE_DEFAULT, CONNECTION_PROPERTY_SSL_CONTEXT_PROTOCOL, CONNECTION_PROPERTY_SSL_CONTEXT_PROTOCOL_ACCESSMODE, CONNECTION_PROPERTY_SSL_CONTEXT_PROTOCOL_DEFAULT, CONNECTION_PROPERTY_STREAM_CHUNK_SIZE, CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_ACCESSMODE, CONNECTION_PROPERTY_STREAM_CHUNK_SIZE_DEFAULT, CONNECTION_PROPERTY_STRICT_ASCII_CONVERSION, CONNECTION_PROPERTY_STRICT_ASCII_CONVERSION_ACCESSMODE, CONNECTION_PROPERTY_STRICT_ASCII_CONVERSION_DEFAULT, CONNECTION_PROPERTY_TCP_KEEPCOUNT, CONNECTION_PROPERTY_TCP_KEEPCOUNT_ACCESSMODE, CONNECTION_PROPERTY_TCP_KEEPCOUNT_DEFAULT, CONNECTION_PROPERTY_TCP_KEEPIDLE, CONNECTION_PROPERTY_TCP_KEEPIDLE_ACCESSMODE, CONNECTION_PROPERTY_TCP_KEEPIDLE_DEFAULT, CONNECTION_PROPERTY_TCP_KEEPINTERVAL, CONNECTION_PROPERTY_TCP_KEEPINTERVAL_ACCESSMODE, CONNECTION_PROPERTY_TCP_KEEPINTERVAL_DEFAULT, CONNECTION_PROPERTY_TENANT_ID, CONNECTION_PROPERTY_TENANT_ID_ACCESSMODE, CONNECTION_PROPERTY_TENANT_ID_DEFAULT, CONNECTION_PROPERTY_THIN_DEBUG_JDWP, CONNECTION_PROPERTY_THIN_DEBUG_JDWP_ACCESSMODE, CONNECTION_PROPERTY_THIN_DEBUG_JDWP_DEFAULT, CONNECTION_PROPERTY_THIN_FORCE_DNS_LOAD_BALANCING, CONNECTION_PROPERTY_THIN_FORCE_DNS_LOAD_BALANCING_ACCESSMODE, CONNECTION_PROPERTY_THIN_FORCE_DNS_LOAD_BALANCING_DEFAULT, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_HOST, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_HOST_ACCESSMODE, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_HOST_DEFAULT, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_PORT, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_PORT_ACCESSMODE, CONNECTION_PROPERTY_THIN_HTTPS_PROXY_PORT_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORE_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTOREPASSWORD_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_KEYSTORETYPE_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORE_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTOREPASSWORD_DEFAULT, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_ACCESSMODE, CONNECTION_PROPERTY_THIN_JAVAX_NET_SSL_TRUSTSTORETYPE_DEFAULT, CONNECTION_PROPERTY_THIN_JNDI_LDAP_CONNECT_TIMEOUT, CONNECTION_PROPERTY_THIN_JNDI_LDAP_CONNECT_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_THIN_JNDI_LDAP_CONNECT_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_THIN_JNDI_LDAP_READ_TIMEOUT, CONNECTION_PROPERTY_THIN_JNDI_LDAP_READ_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_THIN_JNDI_LDAP_READ_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_AUTHENTICATION, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_AUTHENTICATION_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_AUTHENTICATION_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_CREDENTIALS, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_CREDENTIALS_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_CREDENTIALS_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_PRINCIPAL, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_PRINCIPAL_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SECURITY_PRINCIPAL_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_CIPHER_SUITES, CONNECTION_PROPERTY_THIN_LDAP_SSL_CIPHER_SUITES_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_CIPHER_SUITES_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_CONTEXT_PROTOCOL, CONNECTION_PROPERTY_THIN_LDAP_SSL_CONTEXT_PROTOCOL_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_CONTEXT_PROTOCOL_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYMANAGER_FACTORY_ALGORITHM, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYMANAGER_FACTORY_ALGORITHM_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYMANAGER_FACTORY_ALGORITHM_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_PASSWORD, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_PASSWORD_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_TYPE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_TYPE_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_KEYSTORE_TYPE_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTMANAGER_FACTORY_ALGORITHM, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTMANAGER_FACTORY_ALGORITHM_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTMANAGER_FACTORY_ALGORITHM_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_PASSWORD, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_PASSWORD_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_TYPE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_TYPE_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_TRUSTSTORE_TYPE_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_VERSIONS, CONNECTION_PROPERTY_THIN_LDAP_SSL_VERSIONS_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_VERSIONS_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_LOCATION, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_LOCATION_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_LOCATION_DEFAULT, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_PASSWORD, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_THIN_LDAP_SSL_WALLET_PASSWORD_DEFAULT, CONNECTION_PROPERTY_THIN_NET_ALLOW_WEAK_CRYPTO, CONNECTION_PROPERTY_THIN_NET_ALLOW_WEAK_CRYPTO_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_ALLOW_WEAK_CRYPTO_DEFAULT, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_JAAS_LOGIN_MODULE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_JAAS_LOGIN_MODULE_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_JAAS_LOGIN_MODULE_DEFAULT, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_REALM, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_REALM_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB_REALM_DEFAULT, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_CC_NAME_DEFAULT, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_KRB5_MUTUAL_DEFAULT, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_AUTHENTICATION_SERVICES_DEFAULT, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL_DEFAULT, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_CHECKSUM_TYPES_DEFAULT, CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT, CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_CONNECT_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_THIN_NET_CONNECTIONID_PREFIX, CONNECTION_PROPERTY_THIN_NET_CONNECTIONID_PREFIX_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_CONNECTIONID_PREFIX_DEFAULT, CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED, CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_CRYPTO_SEED_DEFAULT, CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK, CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_DISABLE_OUT_OF_BAND_BREAK_DEFAULT, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL_DEFAULT, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES_DEFAULT, CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX, CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_OLDSYNTAX_DEFAULT, CONNECTION_PROPERTY_THIN_NET_PROFILE, CONNECTION_PROPERTY_THIN_NET_PROFILE_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_PROFILE_DEFAULT, CONNECTION_PROPERTY_THIN_NET_RADIUS_CHALLENGE_RESPONSE_HANDLER, CONNECTION_PROPERTY_THIN_NET_RADIUS_CHALLENGE_RESPONSE_HANDLER_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_RADIUS_CHALLENGE_RESPONSE_HANDLER_DEFAULT, CONNECTION_PROPERTY_THIN_NET_SET_FIPS_MODE, CONNECTION_PROPERTY_THIN_NET_SET_FIPS_MODE_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_SET_FIPS_MODE_DEFAULT, CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO, CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_ACCESSMODE, CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO_DEFAULT, CONNECTION_PROPERTY_THIN_OUTBOUND_CONNECT_TIMEOUT, CONNECTION_PROPERTY_THIN_OUTBOUND_CONNECT_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_THIN_OUTBOUND_CONNECT_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_THIN_READ_TIMEOUT, CONNECTION_PROPERTY_THIN_READ_TIMEOUT_ACCESSMODE, CONNECTION_PROPERTY_THIN_READ_TIMEOUT_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_ALLOW_WEAK_DN_MATCH, CONNECTION_PROPERTY_THIN_SSL_ALLOW_WEAK_DN_MATCH_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_ALLOW_WEAK_DN_MATCH_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_ALIAS, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_ALIAS_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_ALIAS_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_THUMBPRINT, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_THUMBPRINT_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_CERTIFICATE_THUMBPRINT_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES, CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_CIPHER_SUITES_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM, CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_KEYMANAGERFACTORY_ALGORITHM_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_SERVER_CERT_DN, CONNECTION_PROPERTY_THIN_SSL_SERVER_CERT_DN_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_SERVER_CERT_DN_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH, CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_SERVER_DN_MATCH_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM, CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_TRUSTMANAGERFACTORY_ALGORITHM_DEFAULT, CONNECTION_PROPERTY_THIN_SSL_VERSION, CONNECTION_PROPERTY_THIN_SSL_VERSION_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_VERSION_DEFAULT, CONNECTION_PROPERTY_THIN_TCP_NO_DELAY, CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_ACCESSMODE, CONNECTION_PROPERTY_THIN_TCP_NO_DELAY_DEFAULT, CONNECTION_PROPERTY_THIN_USE_JCE_API, CONNECTION_PROPERTY_THIN_USE_JCE_API_ACCESSMODE, CONNECTION_PROPERTY_THIN_USE_JCE_API_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_ENAME, CONNECTION_PROPERTY_THIN_VSESSION_ENAME_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_ENAME_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_INAME, CONNECTION_PROPERTY_THIN_VSESSION_INAME_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_INAME_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_MACHINE, CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_MACHINE_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_OSUSER, CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_OSUSER_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_PROCESS, CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_PROCESS_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM, CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_PROGRAM_DEFAULT, CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL, CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_ACCESSMODE, CONNECTION_PROPERTY_THIN_VSESSION_TERMINAL_DEFAULT, CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT, CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_ACCESSMODE, CONNECTION_PROPERTY_TIMESTAMPTZ_IN_GMT_DEFAULT, CONNECTION_PROPERTY_TIMEZONE_AS_REGION, CONNECTION_PROPERTY_TIMEZONE_AS_REGION_ACCESSMODE, CONNECTION_PROPERTY_TIMEZONE_AS_REGION_DEFAULT, CONNECTION_PROPERTY_TNS_ADMIN, CONNECTION_PROPERTY_TNS_ADMIN_ACCESSMODE, CONNECTION_PROPERTY_TNS_ADMIN_DEFAULT, CONNECTION_PROPERTY_TOKEN_AUTHENTICATION, CONNECTION_PROPERTY_TOKEN_AUTHENTICATION_ACCESSMODE, CONNECTION_PROPERTY_TOKEN_AUTHENTICATION_DEFAULT, CONNECTION_PROPERTY_TOKEN_LOCATION, CONNECTION_PROPERTY_TOKEN_LOCATION_ACCESSMODE, CONNECTION_PROPERTY_TOKEN_LOCATION_DEFAULT, CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME, CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_ACCESSMODE, CONNECTION_PROPERTY_USE_1900_AS_YEAR_FOR_TIME_DEFAULT, CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG, CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG_ACCESSMODE, CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG_DEFAULT, CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN, CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_ACCESSMODE, CONNECTION_PROPERTY_USE_FETCH_SIZE_WITH_LONG_COLUMN_DEFAULT, CONNECTION_PROPERTY_USE_SHARDING_DRIVER_CONNECTION, CONNECTION_PROPERTY_USE_SHARDING_DRIVER_CONNECTION_ACCESSMODE, CONNECTION_PROPERTY_USE_SHARDING_DRIVER_CONNECTION_DEFAULT, CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE, CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_ACCESSMODE, CONNECTION_PROPERTY_USE_THREADLOCAL_BUFFER_CACHE_DEFAULT, CONNECTION_PROPERTY_USE_TRUECACHE_DRIVER_CONNECTION, CONNECTION_PROPERTY_USE_TRUECACHE_DRIVER_CONNECTION_ACCESSMODE, CONNECTION_PROPERTY_USE_TRUECACHE_DRIVER_CONNECTION_DEFAULT, CONNECTION_PROPERTY_USER_NAME, CONNECTION_PROPERTY_USER_NAME_ACCESSMODE, CONNECTION_PROPERTY_USER_NAME_DEFAULT, CONNECTION_PROPERTY_VECTOR_DEFAULT_GET_OBJECT_TYPE, CONNECTION_PROPERTY_VECTOR_DEFAULT_GET_OBJECT_TYPE_ACCESSMODE, CONNECTION_PROPERTY_VECTOR_DEFAULT_GET_OBJECT_TYPE_DEFAULT, CONNECTION_PROPERTY_WALLET_LOCATION, CONNECTION_PROPERTY_WALLET_LOCATION_ACCESSMODE, CONNECTION_PROPERTY_WALLET_LOCATION_DEFAULT, CONNECTION_PROPERTY_WALLET_PASSWORD, CONNECTION_PROPERTY_WALLET_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_WALLET_PASSWORD_DEFAULT, CONNECTION_PROPERTY_WEBSOCKET_PASSWORD, CONNECTION_PROPERTY_WEBSOCKET_PASSWORD_ACCESSMODE, CONNECTION_PROPERTY_WEBSOCKET_PASSWORD_DEFAULT, CONNECTION_PROPERTY_WEBSOCKET_USER, CONNECTION_PROPERTY_WEBSOCKET_USER_ACCESSMODE, CONNECTION_PROPERTY_WEBSOCKET_USER_DEFAULT, CONNECTION_PROPERTY_WRITE_LOGS_TO_DIAGNOSE_FIRST_FAILURE, CONNECTION_PROPERTY_WRITE_LOGS_TO_DIAGNOSE_FIRST_FAILURE_ACCESSMODE, CONNECTION_PROPERTY_WRITE_LOGS_TO_DIAGNOSE_FIRST_FAILURE_DEFAULT, CONNECTION_RELEASE_HIGH, CONNECTION_RELEASE_LOCKED, CONNECTION_RELEASE_LOW, DATABASE_CLOSED, DATABASE_NOTOK, DATABASE_OK, DATABASE_TIMEOUT, DCN_BEST_EFFORT, DCN_CLIENT_INIT_CONNECTION, DCN_IGNORE_DELETEOP, DCN_IGNORE_INSERTOP, DCN_IGNORE_UPDATEOP, DCN_NOTIFY_CHANGELAG, DCN_NOTIFY_ROWIDS, DCN_QUERY_CHANGE_NOTIFICATION, DCN_USE_HOST_CONNECTION_ADDR_INFO, END_TO_END_ACTION_INDEX, END_TO_END_CLIENTID_INDEX, END_TO_END_ECID_INDEX, END_TO_END_MODULE_INDEX, END_TO_END_STATE_INDEX_MAX, INVALID_CONNECTION, NETWORK_COMPRESSION_AUTO, NETWORK_COMPRESSION_LEVEL_HIGH, NETWORK_COMPRESSION_LEVEL_HIGH_VALUE, NETWORK_COMPRESSION_LEVEL_LOW, NETWORK_COMPRESSION_LEVEL_LOW_VALUE, NETWORK_COMPRESSION_OFF, NETWORK_COMPRESSION_ON, NETWORK_COMPRESSION_THRESHOLD_MIN, NTF_AQ_PAYLOAD, NTF_ASYNC_DEQ, NTF_DEFAULT_TCP_PORT, NTF_GROUPING_CLASS, NTF_GROUPING_CLASS_NONE, NTF_GROUPING_CLASS_TIME, NTF_GROUPING_REPEAT_FOREVER, NTF_GROUPING_REPEAT_TIME, NTF_GROUPING_START_TIME, NTF_GROUPING_TYPE, NTF_GROUPING_TYPE_LAST, NTF_GROUPING_TYPE_SUMMARY, NTF_GROUPING_VALUE, NTF_LOCAL_HOST, NTF_LOCAL_TCP_PORT, NTF_QOS_AUTO_ACK, NTF_QOS_PURGE_ON_NTFN, NTF_QOS_RELIABLE, NTF_QOS_SECURE, NTF_QOS_TX_ACK, NTF_TIMEOUT, NTF_USE_SSL, OCSID_ACTION_KEY, OCSID_CLIENT_INFO_KEY, OCSID_CLIENTID_KEY, OCSID_DBOP_KEY, OCSID_ECID_KEY, OCSID_MODULE_KEY, OCSID_NAMESPACE, OCSID_SEQUENCE_NUMBER_KEY, PROXY_CERTIFICATE, PROXY_DISTINGUISHED_NAME, PROXY_ROLES, PROXY_SESSION, PROXY_TYPE, PROXY_USER_NAME, PROXY_USER_PASSWORD, PROXYTYPE_CERTIFICATE, PROXYTYPE_DISTINGUISHED_NAME, PROXYTYPE_USER_NAME, RELEASE_CONNECTION_CALLBACK
Constructor and Description |
---|
OracleConnectionWrapper() |
OracleConnectionWrapper(OracleConnection toBeWrapped)
Construct an instance which wraps the argument
|
Modifier and Type | Method and Description |
---|---|
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 |
abort(java.util.concurrent.Executor executor) |
void |
addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener)
Registers a listener to Logical Transaction Id events.
|
void |
addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener,
java.util.concurrent.Executor executor)
This flavor of
addLogicalTransactionIdEventListener can be used to register
a listener with an executor. |
void |
archive(int mode,
int aseq,
java.lang.String acstext)
Not implemented.
|
boolean |
attachServerConnection()
Notifies the server that the DRCP enabled connection will be in use so
that the server can associate a server process to the connection.
|
void |
beginRequest()
Declares that a request to the server is starting on this
connection.
|
void |
cancel()
Performs an immediate (asynchronous) termination of any currently
executing operation on this connection.
|
void |
clearAllApplicationContext(java.lang.String nameSpace)
Clear all the attribute/value information in a namespace.
|
void |
clearWarnings() |
void |
close() |
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 |
commit() |
void |
commit(java.util.EnumSet<OracleConnection.CommitOption> flags)
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.
|
java.sql.Array |
createArrayOf(java.lang.String typeName,
java.lang.Object[] 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.
|
java.sql.Blob |
createBlob() |
java.sql.Clob |
createClob() |
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.
|
java.sql.NClob |
createNClob() |
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.
|
java.sql.Array |
createOracleArray(java.lang.String arrayTypeName,
java.lang.Object elements)
Creates an Array object with the given type name and elements.
|
java.sql.SQLXML |
createSQLXML() |
java.sql.Statement |
createStatement() |
java.sql.Statement |
createStatement(int resultSetType,
int resultSetConcurrency) |
java.sql.Statement |
createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
java.sql.Struct |
createStruct(java.lang.String typeName,
java.lang.Object[] attributes) |
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.
|
TIMESTAMP |
createTIMESTAMP(java.sql.Timestamp value,
java.util.Calendar cal)
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.
|
TIMESTAMPTZ |
createTIMESTAMPTZ(java.sql.Timestamp value,
java.time.ZoneId tzid)
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,
byte[] tdo,
int version)
Dequeues an AQ message from the queue specified by its name.
|
AQMessage[] |
dequeue(java.lang.String queueName,
AQDequeueOptions opt,
byte[] tdo,
int version,
int deqsize)
Dequeues an array of AQ messages 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.
|
AQMessage[] |
dequeue(java.lang.String queueName,
AQDequeueOptions opt,
java.lang.String typeName,
int deqsize)
Dequeues an array of AQ messages from the queue specified by its name.
|
void |
detachServerConnection(java.lang.String tag)
Notify the server that this connection will not be used.
|
void |
disableLogging()
Disables the logging for the connection.
|
java.lang.Object |
doGetDescriptor(java.lang.String sql_name) |
void |
dumpLog()
Dumps the trace data for the connection to the configured handler.
|
void |
enableLogging()
Enables logging for the connection.
|
void |
endRequest()
Declares that the request that was in progress on this connection
has completed.
|
void |
enqueue(java.lang.String queueName,
AQEnqueueOptions opt,
AQMessage mesg)
Enqueues the given AQ message to the queue specified by its name.
|
int |
enqueue(java.lang.String queueName,
AQEnqueueOptions opt,
AQMessage[] mesgs)
Enqueues the given array of AQ messages 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.
|
boolean |
getAutoCommit() |
java.sql.CallableStatement |
getCallWithKey(java.lang.String key)
getCallWithKey
Searches the explicit cache for a match on key.
|
java.lang.String |
getCatalog() |
java.lang.String |
getChecksumProviderName()
If network integrity service is enabled, returns the name of
the checksum provider, otherwise returns
null . |
java.util.Properties |
getClientInfo() |
java.lang.String |
getClientInfo(java.lang.String name) |
protected oracle.jdbc.internal.OracleConnection |
getConnectionDuringExceptionHandling() |
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 |
getDatabaseTimeZone()
Returns the database timezone.
|
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()
Executions are not batched but sent immediately.
|
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 |
getDRCPPLSQLCallbackName()
Returns the PL/SQL Fix-up callback name if configured,
otherwise returns
Null |
java.lang.String |
getDRCPReturnTag()
Returns the tag associated with this DRCP pooled server.
|
OracleConnection.DRCPState |
getDRCPState()
Returns an enum indicating if the connection is attached
to a DRCP server process.
|
java.lang.String |
getEncryptionAlgorithmName()
Returns the name of the algorithm that is used for data
encryption by the thin driver on the network.
|
java.lang.String |
getEncryptionProviderName()
If network encryption service is enabled, returns the name of
the encryption provider, otherwise returns
null . |
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.
|
int |
getHoldability() |
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) |
LogicalTransactionId |
getLogicalTransactionId()
Gets the current Logical Transaction Id which are sent by the server in
a piggy back message and hence this method call doesn't make a roundtrip.
|
java.sql.DatabaseMetaData |
getMetaData() |
java.lang.String |
getNetConnectionId()
Returns the Net Connection ID associated with this connection.
|
int |
getNetworkTimeout() |
java.util.Properties |
getProperties()
Returns connection properties
that are currently in effect for this connection.
|
java.util.Set<java.lang.String> |
getProviderAllowedProperties()
getProviderAllowedProperties
Get the list of properties that are whitelisted
for a remote provider.
|
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 |
getSchema() |
SecurityInformation |
getSecurityInformation()
Returns an instance of SecurityInformation which has details about the security of the
underlying network connection.
|
java.util.Properties |
getServerSessionInfo()
Exposes some of the key/value pairs that the server returns
at connection time.
|
java.lang.String |
getServerSessionInfo(java.lang.String key)
Returns the value associated to a
key that the server returns
at connection time. |
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) |
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() |
short |
getStructAttrCsId()
Obtain the Oracle identifier of the character set used in STRUCT
attributes.
|
int |
getTransactionIsolation() |
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.Map<java.lang.String,java.lang.Class<?>> |
getTypeMap() |
java.lang.String |
getUserName()
Gets the user name of the current connection.
|
boolean |
getUsingXAFlag()
Gets the value of the
UsingXA flag which the driver sets to
true when using XA to manage distributed transactions. |
java.sql.SQLWarning |
getWarnings() |
boolean |
getXAErrorFlag()
Gets the value of the
XAError flag which is used with
distributed transactions. |
boolean |
isClosed() |
boolean |
isDRCPEnabled()
Returns if the connection is participating in DRCP.
|
boolean |
isDRCPMultitagEnabled()
Returns true if multiple tags are allowed with DRCP Connection.
|
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 dual proxy session i.e when application
explicitly calls openProxySession() on an existing connection.
|
boolean |
isReadOnly() |
boolean |
isUsable()
Identifies whether this connection is still usable for JDBC operations.
|
boolean |
isValid(int timeout) |
boolean |
isValid(OracleConnection.ConnectionValidation effort,
int timeout)
Returns true if this connection was working properly to the extent
specified by
effort at the instant during this call it was checked. |
boolean |
isWrapperFor(java.lang.Class<?> iface)
Return true if this object implements the argument or if the wrapped
connection implements the argument.
|
java.lang.String |
nativeSQL(java.lang.String sql) |
boolean |
needToPurgeStatementCache()
Connection Pool manager will invoke this method to check if the
server session is the same as the old one and if the Statement cache
should be purged.
|
void |
openProxySession(int mode,
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)
ping Database
|
java.sql.CallableStatement |
prepareCall(java.lang.String sql) |
java.sql.CallableStatement |
prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency) |
java.sql.CallableStatement |
prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
java.sql.CallableStatement |
prepareCallWithKey(java.lang.String key) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int autoGeneratedKeys) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int[] columnIndexes) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability) |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
java.lang.String[] columnNames) |
java.sql.PreparedStatement |
prepareStatementWithKey(java.lang.String key) |
protected <T> T |
proxyFor(java.lang.Object obj,
java.lang.Class<T> iface) |
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).
|
DatabaseChangeRegistration |
registerDatabaseChangeNotification(java.util.Properties options)
/
Creates a new database change registration.
|
void |
registerSQLType(java.lang.String sql_name,
java.lang.Class<?> java_class) |
void |
registerSQLType(java.lang.String sql_name,
java.lang.String java_class_name) |
void |
registerTAFCallback(OracleOCIFailover cbk,
java.lang.Object obj)
Register an application TAF Callback instance that will be called
when an application failover occurs.
|
void |
releaseSavepoint(java.sql.Savepoint savepoint) |
void |
removeAllDescriptor()
When STRUCT objects type is created/used/dropped/created/used/dropped
(same name but different attributes) with the same Connection,
then to avoid this Exception: ORA-21700: object does not exist or is marked for delete.
|
void |
removeDescriptor(byte[] toid)
Removes the Descriptor object corresponding to a byte[] toid from the cache.
|
void |
removeDescriptor(java.lang.String sql_name)
Removes the Descriptor object corresponding to a sql type from the cache.
|
void |
removeLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener)
Deregisters the Logical Transaction Id event listener.
|
void |
rollback() |
void |
rollback(java.sql.Savepoint savepoint) |
void |
setApplicationContext(java.lang.String nameSpace,
java.lang.String attribute,
java.lang.String value)
Sets a attribute/value pair in a particular namespace in the
application context on the server.
|
void |
setAutoClose(boolean autoClose)
set auto-close mode.
|
void |
setAutoCommit(boolean autoCommit) |
void |
setCatalog(java.lang.String catalog) |
void |
setClientInfo(java.util.Properties properties) |
void |
setClientInfo(java.lang.String name,
java.lang.String value) |
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)
Executions are not batched but sent immediately.
|
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 |
setHoldability(int holdability) |
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 |
setNetworkTimeout(java.util.concurrent.Executor executor,
int milliseconds) |
void |
setPlsqlWarnings(java.lang.String setting)
Enable/Disable PLSQL Compiler Warnings
|
void |
setReadOnly(boolean readOnly) |
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. |
java.sql.Savepoint |
setSavepoint() |
java.sql.Savepoint |
setSavepoint(java.lang.String name) |
void |
setSchema(java.lang.String schema) |
void |
setSessionTimeZone(java.lang.String regionName)
Set the session time zone.
|
void |
setShardingKey(OracleShardingKey shardingKey)
Sets the sharding key on this connection.
|
void |
setShardingKey(OracleShardingKey key,
OracleShardingKey superKey)
Sets the sharding key and the super sharding key on this connection.
|
boolean |
setShardingKeyIfValid(OracleShardingKey shardingKey,
int timeout)
Checks the validity of the connection and also checks if the sharding key
passed to this method is valid for the connection.
|
boolean |
setShardingKeyIfValid(OracleShardingKey key,
OracleShardingKey superKey,
int timeout)
Checks the validity of the connection and also checks if the sharding keys
passed to this method are valid for the connection.
|
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) |
void |
setStmtCacheSize(int size,
boolean clearMetaData) |
void |
setTransactionIsolation(int level) |
void |
setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map) |
void |
setUsingXAFlag(boolean value)
When using distributed transactions with XA, you can set the value of the
UsingXA flag. |
void |
setWrapper(OracleConnection wrapper)
Set a connection wrapper as the wrapper of this connection.
|
void |
setXAErrorFlag(boolean value)
Sets the value of the
XAError flag which is used with
distributed transactions. |
void |
shutdown(OracleConnection.DatabaseShutdownMode mode)
Shuts the database server down.
|
void |
startup(OracleConnection.DatabaseStartupMode mode)
Starts the database server up.
|
void |
startup(OracleConnection.DatabaseStartupMode mode,
java.lang.String pfileName)
Starts the database server up.
|
void |
startup(java.lang.String startup_str,
int mode)
Not implemented
|
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.
|
void |
unregisterDatabaseChangeNotification(long registrationId,
java.lang.String callback)
Deletes a given database change registration in the server.
|
OracleConnection |
unwrap()
Unwrap one level.
|
<T> T |
unwrap(java.lang.Class<T> iface)
Return an object that implements the requested interface.
|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
applyConnectionAttributes, close, getConnectionAttributes, getConnectionReleasePriority, getUnMatchedConnectionAttributes, registerConnectionCacheCallback, setConnectionReleasePriority
protected OracleConnection connection
public OracleConnectionWrapper()
public OracleConnectionWrapper(OracleConnection toBeWrapped)
toBeWrapped
- Connection to wrappublic OracleConnection unwrap()
unwrap
in interface OracleConnection
public java.lang.String getDatabaseTimeZone() throws java.sql.SQLException
java.sql.SQLException
public void setWrapper(OracleConnection wrapper)
setWrapper
in interface OracleConnection
wrapper
- public java.sql.Statement createStatement() throws java.sql.SQLException
createStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.CallableStatement prepareCall(java.lang.String sql) throws java.sql.SQLException
prepareCall
in interface java.sql.Connection
java.sql.SQLException
public java.lang.String nativeSQL(java.lang.String sql) throws java.sql.SQLException
nativeSQL
in interface java.sql.Connection
java.sql.SQLException
public void setAutoCommit(boolean autoCommit) throws java.sql.SQLException
setAutoCommit
in interface java.sql.Connection
java.sql.SQLException
public boolean getAutoCommit() throws java.sql.SQLException
getAutoCommit
in interface java.sql.Connection
java.sql.SQLException
public void commit() throws java.sql.SQLException
commit
in interface java.sql.Connection
java.sql.SQLException
public void rollback() throws java.sql.SQLException
rollback
in interface java.sql.Connection
java.sql.SQLException
public void close() throws java.sql.SQLException
close
in interface java.lang.AutoCloseable
close
in interface java.sql.Connection
java.sql.SQLException
public boolean isClosed() throws java.sql.SQLException
isClosed
in interface java.sql.Connection
java.sql.SQLException
public java.sql.DatabaseMetaData getMetaData() throws java.sql.SQLException
getMetaData
in interface java.sql.Connection
java.sql.SQLException
public void setReadOnly(boolean readOnly) throws java.sql.SQLException
setReadOnly
in interface java.sql.Connection
java.sql.SQLException
public boolean isReadOnly() throws java.sql.SQLException
isReadOnly
in interface java.sql.Connection
java.sql.SQLException
public void setCatalog(java.lang.String catalog) throws java.sql.SQLException
setCatalog
in interface java.sql.Connection
java.sql.SQLException
public java.lang.String getCatalog() throws java.sql.SQLException
getCatalog
in interface java.sql.Connection
java.sql.SQLException
public void setTransactionIsolation(int level) throws java.sql.SQLException
setTransactionIsolation
in interface java.sql.Connection
java.sql.SQLException
public int getTransactionIsolation() throws java.sql.SQLException
getTransactionIsolation
in interface java.sql.Connection
java.sql.SQLException
public java.sql.SQLWarning getWarnings() throws java.sql.SQLException
getWarnings
in interface java.sql.Connection
java.sql.SQLException
public void clearWarnings() throws java.sql.SQLException
clearWarnings
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Statement createStatement(int resultSetType, int resultSetConcurrency) throws java.sql.SQLException
createStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.CallableStatement prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency) throws java.sql.SQLException
prepareCall
in interface java.sql.Connection
java.sql.SQLException
public java.util.Map<java.lang.String,java.lang.Class<?>> getTypeMap() throws java.sql.SQLException
getTypeMap
in interface java.sql.Connection
java.sql.SQLException
public void setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map) throws java.sql.SQLException
setTypeMap
in interface java.sql.Connection
java.sql.SQLException
public boolean isProxySession()
OracleConnection
isProxySession
in interface OracleConnection
OracleConnection.openProxySession(int, java.util.Properties)
public void openProxySession(int mode, java.util.Properties prop) throws java.sql.SQLException
OracleConnection
openProxySession
in interface OracleConnection
mode
- has to be either OracleConnection.PROXYTYPE_USER_NAME
or OracleConnection.PROXYTYPE_DISTINGUISHED_NAME or
OracleConnection.PROXYTYPE_CERTIFICATEprop
- keys/valuesjava.sql.SQLException
public void archive(int mode, int aseq, java.lang.String acstext) throws java.sql.SQLException
OracleConnection
archive
in interface OracleConnection
java.sql.SQLException
public boolean getAutoClose() throws java.sql.SQLException
OracleConnection
getAutoClose
in interface OracleConnection
java.sql.SQLException
- should never been raisedsetAutoClose
public java.sql.CallableStatement getCallWithKey(java.lang.String key) throws java.sql.SQLException
OracleConnection
getCallWithKey
in interface OracleConnection
key
- Specified key to search forjava.sql.SQLException
public int getDefaultExecuteBatch()
OracleConnection
getDefaultExecuteBatch
in interface OracleConnection
OraclePreparedStatement.setExecuteBatch
,
setDefaultExecuteBatch
public int getDefaultRowPrefetch()
OracleConnection
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();
getDefaultRowPrefetch
in interface OracleConnection
OracleStatement.setRowPrefetch
,
setDefaultRowPrefetch
public java.lang.Object getDescriptor(java.lang.String sql_name)
OracleConnection
getDescriptor
in interface OracleConnection
sql_name
- the sql typeputDescriptor
,
oracle.sql.TypeDescriptor
public java.lang.Object doGetDescriptor(java.lang.String sql_name)
public java.lang.String[] getEndToEndMetrics() throws java.sql.SQLException
OracleConnection
getEndToEndMetrics
in interface OracleConnection
java.sql.SQLException
- if an error occurssetEndToEndMetrics
,
Connection.getClientInfo(java.lang.String)
,
Connection.getClientInfo()
public short getEndToEndECIDSequenceNumber() throws java.sql.SQLException
OracleConnection
getEndToEndECIDSequenceNumber
in interface OracleConnection
java.sql.SQLException
- if an error occursConnection.getClientInfo(java.lang.String)
,
Connection.getClientInfo()
public boolean getIncludeSynonyms()
OracleConnection
DatabaseMetaData.getColumns
.
By default and for performance reasons it won't but you can change this with the
setIncludeSynonyms
method.getIncludeSynonyms
in interface OracleConnection
DatabaseMetaData.getColumns
will report
information if a table synonym is passed in, and false otherwisesetIncludeSynonyms
public boolean getRestrictGetTables()
OracleConnection
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.
getRestrictGetTables
in interface OracleConnection
DatabaseMetaData.getTables
is restricted, and false otherwisesetRestrictGetTables
public boolean getImplicitCachingEnabled() throws java.sql.SQLException
OracleConnection
getImplicitCachingEnabled
in interface OracleConnection
java.sql.SQLException
public boolean getExplicitCachingEnabled() throws java.sql.SQLException
OracleConnection
getExplicitCachingEnabled
in interface OracleConnection
java.sql.SQLException
public java.lang.Object getJavaObject(java.lang.String sql_name) throws java.sql.SQLException
getJavaObject
in interface OracleConnection
java.sql.SQLException
public boolean getRemarksReporting()
OracleConnection
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.
getRemarksReporting
in interface OracleConnection
DatabaseMetaData
calls getTables
and getColumns
will report the REMARKS column and false otherwisesetRemarksReporting
public java.lang.String getSQLType(java.lang.Object obj) throws java.sql.SQLException
getSQLType
in interface OracleConnection
java.sql.SQLException
public int getStmtCacheSize()
getStmtCacheSize
in interface OracleConnection
public int getStatementCacheSize() throws java.sql.SQLException
OracleConnection
getStatementCacheSize
in interface OracleConnection
java.sql.SQLException
public java.sql.PreparedStatement getStatementWithKey(java.lang.String key) throws java.sql.SQLException
OracleConnection
getStatementWithKey
in interface OracleConnection
key
- Specified key to search forjava.sql.SQLException
public short getStructAttrCsId() throws java.sql.SQLException
OracleConnection
getStructAttrCsId
in interface OracleConnection
java.sql.SQLException
- if Conversion is nullpublic java.lang.String getUserName() throws java.sql.SQLException
OracleConnection
Example where conn
is your connection object:
String UserName = ((OracleConnection)conn).getUserName();
getUserName
in interface OracleConnection
java.sql.SQLException
- if the logical connection is closedpublic java.lang.String getCurrentSchema() throws java.sql.SQLException
OracleConnection
getCurrentSchema
in interface OracleConnection
java.sql.SQLException
- If there was an error while fetching the resultspublic boolean getUsingXAFlag()
OracleConnection
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
.getUsingXAFlag
in interface OracleConnection
true
when using XA to manage distributed transactions
and false
otherwise.setUsingXAFlag
public boolean getXAErrorFlag()
OracleConnection
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
.
getXAErrorFlag
in interface OracleConnection
setXAErrorFlag
public OracleSavepoint oracleSetSavepoint() throws java.sql.SQLException
OracleConnection
OracleSavepoint
object that
represents it.oracleSetSavepoint
in interface OracleConnection
OracleSavepoint
objectjava.sql.SQLException
- if a database access error occurs
or this Connection
object is currently in
auto-commit modeOracleSavepoint
public OracleSavepoint oracleSetSavepoint(java.lang.String name) throws java.sql.SQLException
OracleConnection
OracleSavepoint
object that
represents it.oracleSetSavepoint
in interface OracleConnection
name
- a String
containing the name of the savepointOracleSavepoint
objectjava.sql.SQLException
- if a database access error occurs
or this Connection
object is currently in
auto-commit modeOracleSavepoint
public void oracleRollback(OracleSavepoint savepoint) throws java.sql.SQLException
OracleConnection
OracleSavepoint
object was set.
This method should be used only when auto-commit has been disabled.
oracleRollback
in interface OracleConnection
savepoint
- the OracleSavepoint
object to roll back tojava.sql.SQLException
- if a database access error occurs,
the OracleSavepoint
object is no longer valid,
or this Connection
object is currently in
auto-commit modeOracleSavepoint
public void oracleReleaseSavepoint(OracleSavepoint savepoint) throws java.sql.SQLException
OracleConnection
OracleSavepoint
object from the current
transaction. Any reference to the savepoint after it have been removed
will cause an SQLException
to be thrown.oracleReleaseSavepoint
in interface OracleConnection
savepoint
- the OracleSavepoint
object to be removedjava.sql.SQLException
- if a database access error occurs or
the given OracleSavepoint
object is not a valid
savepoint in the current transactionOracleSavepoint
public int pingDatabase() throws java.sql.SQLException
OracleConnection
pingDatabase
in interface OracleConnection
java.sql.SQLException
public int pingDatabase(int timeOut) throws java.sql.SQLException
OracleConnection
pingDatabase
in interface OracleConnection
java.sql.SQLException
public void purgeExplicitCache() throws java.sql.SQLException
OracleConnection
purgeExplicitCache
in interface OracleConnection
java.sql.SQLException
public void purgeImplicitCache() throws java.sql.SQLException
OracleConnection
purgeImplicitCache
in interface OracleConnection
java.sql.SQLException
public void putDescriptor(java.lang.String sql_name, java.lang.Object desc) throws java.sql.SQLException
OracleConnection
putDescriptor
in interface OracleConnection
sql_name
- the sql typedesc
- the Object Descriptor associatedjava.sql.SQLException
- if sql_name or desc is nullgetDescriptor
,
oracle.sql.TypeDescriptor
public void removeDescriptor(java.lang.String sql_name)
OracleConnection
removeDescriptor
in interface OracleConnection
public void removeDescriptor(byte[] toid)
OracleConnection
removeDescriptor
in interface OracleConnection
public void removeAllDescriptor()
OracleConnection
removeAllDescriptor
in interface OracleConnection
public void registerSQLType(java.lang.String sql_name, java.lang.Class<?> java_class) throws java.sql.SQLException
registerSQLType
in interface OracleConnection
java.sql.SQLException
public void registerSQLType(java.lang.String sql_name, java.lang.String java_class_name) throws java.sql.SQLException
registerSQLType
in interface OracleConnection
java.sql.SQLException
public void setAutoClose(boolean autoClose) throws java.sql.SQLException
OracleConnection
setAutoClose
in interface OracleConnection
autoClose
- the boolean valuejava.sql.SQLException
- when the argument autoClose is falsegetAutoClose
public void setDefaultExecuteBatch(int batch) throws java.sql.SQLException
OracleConnection
setDefaultExecuteBatch
in interface OracleConnection
batch
- value is discarded.java.sql.SQLException
- never thrown.OraclePreparedStatement.setExecuteBatch
,
getDefaultExecuteBatch
public void setDefaultRowPrefetch(int value) throws java.sql.SQLException
OracleConnection
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.
setDefaultRowPrefetch
in interface OracleConnection
value
- the number of rows to prefetchjava.sql.SQLException
- if the argument value is <=0OracleStatement.setRowPrefetch
,
getDefaultRowPrefetch
public void setEndToEndMetrics(java.lang.String[] metrics, short sequenceNumber) throws java.sql.SQLException
OracleConnection
setEndToEndMetrics
in interface OracleConnection
metrics
- String[] containing the metric values.sequenceNumber
- the sequence number for the context idjava.sql.SQLException
- if an error occursgetEndToEndMetrics
,
Connection.setClientInfo(java.util.Properties)
,
Connection.setClientInfo(java.lang.String, java.lang.String)
public void setExplicitCachingEnabled(boolean cache) throws java.sql.SQLException
OracleConnection
setExplicitCachingEnabled
in interface OracleConnection
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.java.sql.SQLException
- if called on a logical connection.public void setImplicitCachingEnabled(boolean cache) throws java.sql.SQLException
OracleConnection
setImplicitCachingEnabled
in interface OracleConnection
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.java.sql.SQLException
- if called on a logical connection.public void setIncludeSynonyms(boolean synonyms)
OracleConnection
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.
setIncludeSynonyms
in interface OracleConnection
synonyms
- true if you want to retrieve synonym information
in DatabaseMetaData.getColumns and false otherwise.getIncludeSynonyms
public void setRemarksReporting(boolean reportRemarks)
OracleConnection
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.
setRemarksReporting
in interface OracleConnection
reportRemarks
- true if you want to turn on the reporting of
the REMARKS columns and false otherwise.getRemarksReporting
public void setRestrictGetTables(boolean restrict)
OracleConnection
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:
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);
setRestrictGetTables
in interface OracleConnection
restrict
- true to turn on the restriction and false
otherwise.getRestrictGetTables
public void setStmtCacheSize(int size) throws java.sql.SQLException
setStmtCacheSize
in interface OracleConnection
java.sql.SQLException
public void setStatementCacheSize(int size) throws java.sql.SQLException
OracleConnection
setStatementCacheSize
in interface OracleConnection
size
- Requested size of the cache. If the existing cache size
is less than size, statements will be purged to reduce the
size.java.sql.SQLException
- if size < 0, or if called on a logical connection.public void setStmtCacheSize(int size, boolean clearMetaData) throws java.sql.SQLException
setStmtCacheSize
in interface OracleConnection
java.sql.SQLException
public void setUsingXAFlag(boolean value)
OracleConnection
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
.
setUsingXAFlag
in interface OracleConnection
value
- the value of the UsingXA
flaggetUsingXAFlag
public void setXAErrorFlag(boolean value)
OracleConnection
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.setXAErrorFlag
in interface OracleConnection
value
- the value of the XAError
flaggetXAErrorFlag
public void shutdown(OracleConnection.DatabaseShutdownMode mode) throws java.sql.SQLException
OracleConnection
shutdown
in interface OracleConnection
mode
- can be either OracleConnection.DatabaseShutdownMode.CONNECT
OracleConnection.DatabaseShutdownMode.TRANSACTIONAL
OracleConnection.DatabaseShutdownMode.TRANSACTIONAL_LOCAL
OracleConnection.DatabaseShutdownMode.IMMEDIATE
OracleConnection.DatabaseShutdownMode.ABORT
OracleConnection.DatabaseShutdownMode.FINAL
java.sql.SQLException
public void startup(java.lang.String startup_str, int mode) throws java.sql.SQLException
OracleConnection
startup
in interface OracleConnection
java.sql.SQLException
public void startup(OracleConnection.DatabaseStartupMode mode) throws java.sql.SQLException
OracleConnection
startup
in interface OracleConnection
mode
- can be either OracleConnection.DatabaseStartupMode.NO_RESTRICTION
OracleConnection.DatabaseStartupMode.FORCE
OracleConnection.DatabaseStartupMode.RESTRICT
java.sql.SQLException
public void startup(OracleConnection.DatabaseStartupMode mode, java.lang.String pfileName) throws java.sql.SQLException
OracleConnection
startup
in interface OracleConnection
mode
- can be either OracleConnection.DatabaseStartupMode.NO_RESTRICTION
OracleConnection.DatabaseStartupMode.FORCE
OracleConnection.DatabaseStartupMode.RESTRICT
java.sql.SQLException
public java.sql.PreparedStatement prepareStatementWithKey(java.lang.String key) throws java.sql.SQLException
prepareStatementWithKey
in interface OracleConnection
key
- the key with which it was closedjava.sql.SQLException
- if a database access error occurspublic java.sql.CallableStatement prepareCallWithKey(java.lang.String key) throws java.sql.SQLException
prepareCallWithKey
in interface OracleConnection
key
- the key with which it was closedjava.sql.SQLException
- if a database access error occurspublic void setCreateStatementAsRefCursor(boolean value)
OracleConnection
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
.
setCreateStatementAsRefCursor
in interface OracleConnection
value
- true
if new statements should be created as
REF CURSORS
, false
otherwisegetCreateStatementAsRefCursor
public boolean getCreateStatementAsRefCursor()
OracleConnection
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
.
getCreateStatementAsRefCursor
in interface OracleConnection
setCreateStatementAsRefCursor
public void setSessionTimeZone(java.lang.String regionName) throws java.sql.SQLException
OracleConnection
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.
setSessionTimeZone
in interface OracleConnection
regionName
- Oracle session time zone region name.java.sql.SQLException
- if an error occurred.public java.lang.String getSessionTimeZone()
OracleConnection
getSessionTimeZone
in interface OracleConnection
public java.lang.String getSessionTimeZoneOffset() throws java.sql.SQLException
OracleConnection
"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.
getSessionTimeZoneOffset
in interface OracleConnection
java.sql.SQLException
public java.sql.Connection _getPC()
OracleConnection
_getPC
in interface OracleConnection
public boolean isLogicalConnection()
OracleConnection
isLogicalConnection
in interface OracleConnection
public void registerTAFCallback(OracleOCIFailover cbk, java.lang.Object obj) throws java.sql.SQLException
OracleConnection
registerTAFCallback
in interface OracleConnection
cbk
- Callback instance.obj
- Context object in which any client's state can be
stored and provided when the callback method is
invoked.java.sql.SQLException
- if this method is invoked in drivers other than
the Jdbc OCI driver.public java.util.Properties getProperties()
OracleConnection
Returns connection properties that are currently in effect for this connection.
The keys of the returned Properties
object are a subset of the
String
constants declared by this class with names that begin with
CONNECTION_PROPERTY_
. The values of the returned Properties
object reflect the current state of this connection, and may
be different from the values specified when this connection was created. For
instance, if this connection is connected to a database that has disabled
result caching, then the value of OracleConnection.CONNECTION_PROPERTY_ENABLE_QUERY_RESULT_CACHE
will be "false"
,
regardless of any value that may have been specified for that property
when this when this connection was created.
The returned Propeties
object does not contain the values of
sensitive properties, such as passwords.
getProperties
in interface OracleConnection
public void close(int opt) throws java.sql.SQLException
OracleConnection
close
in interface OracleConnection
opt
- set to INVALID_CONNECTION to close the PooledConnectionjava.sql.SQLException
- if a database access error occurspublic void setPlsqlWarnings(java.lang.String setting) throws java.sql.SQLException
OracleConnection
setPlsqlWarnings
in interface OracleConnection
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.java.sql.SQLException
- if a database access error occurspublic void setHoldability(int holdability) throws java.sql.SQLException
setHoldability
in interface java.sql.Connection
java.sql.SQLException
public int getHoldability() throws java.sql.SQLException
getHoldability
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
createStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.CallableStatement prepareCall(java.lang.String sql, int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws java.sql.SQLException
prepareCall
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Savepoint setSavepoint() throws java.sql.SQLException
setSavepoint
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Savepoint setSavepoint(java.lang.String name) throws java.sql.SQLException
setSavepoint
in interface java.sql.Connection
java.sql.SQLException
public void rollback(java.sql.Savepoint savepoint) throws java.sql.SQLException
rollback
in interface java.sql.Connection
java.sql.SQLException
public void releaseSavepoint(java.sql.Savepoint savepoint) throws java.sql.SQLException
releaseSavepoint
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql, int autoGeneratedKeys) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql, int[] columnIndexes) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql, java.lang.String[] columnNames) throws java.sql.SQLException
prepareStatement
in interface java.sql.Connection
java.sql.SQLException
public ARRAY createARRAY(java.lang.String typeName, java.lang.Object elements) throws java.sql.SQLException
createARRAY
in interface OracleConnection
typeName
- the name of the SQL type of the created objectelements
- the elements of the created objectjava.sql.SQLException
- if a database error occurspublic java.sql.Array createOracleArray(java.lang.String arrayTypeName, java.lang.Object elements) throws java.sql.SQLException
createOracleArray
in interface OracleConnection
arrayTypeName
- the name of the SQL type of the created objectelements
- the elements of the created objectjava.sql.SQLException
- if a database error occurspublic BINARY_DOUBLE createBINARY_DOUBLE(double value) throws java.sql.SQLException
createBINARY_DOUBLE
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic BINARY_FLOAT createBINARY_FLOAT(float value) throws java.sql.SQLException
createBINARY_FLOAT
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Date value) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Time value) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Timestamp value) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Date value, java.util.Calendar cal) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone in which the value is interpretedjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Time value, java.util.Calendar cal) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone in which the value is interpretedjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.sql.Timestamp value, java.util.Calendar cal) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone in which the value is interpretedjava.sql.SQLException
- if a database error occurspublic DATE createDATE(java.lang.String value) throws java.sql.SQLException
createDATE
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic INTERVALDS createINTERVALDS(java.lang.String value) throws java.sql.SQLException
createINTERVALDS
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic INTERVALYM createINTERVALYM(java.lang.String value) throws java.sql.SQLException
createINTERVALYM
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(boolean value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(byte value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(short value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(int value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(long value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(float value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(double value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(java.math.BigDecimal value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(java.math.BigInteger value) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic NUMBER createNUMBER(java.lang.String value, int scale) throws java.sql.SQLException
createNUMBER
in interface OracleConnection
value
- the value that the new object should representscale
- the scale of the new objectjava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(java.sql.Date value) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(DATE value) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(java.sql.Time value) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(java.sql.Timestamp value) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(java.sql.Timestamp value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMP createTIMESTAMP(java.lang.String value) throws java.sql.SQLException
createTIMESTAMP
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Date value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Time value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.sql.Timestamp value, java.time.ZoneId tzid) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representtzid
- the ZoneId of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representjava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(java.lang.String value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPTZ createTIMESTAMPTZ(DATE value) throws java.sql.SQLException
createTIMESTAMPTZ
in interface OracleConnection
java.sql.SQLException
- if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Date value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Time value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Timestamp value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(java.lang.String value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(DATE value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ
in interface OracleConnection
value
- the value that the new object should representcal
- the timezone of the valuejava.sql.SQLException
- if a database error occurspublic java.sql.Array createArrayOf(java.lang.String typeName, java.lang.Object[] elements) throws java.sql.SQLException
createArrayOf
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Blob createBlob() throws java.sql.SQLException
createBlob
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Clob createClob() throws java.sql.SQLException
createClob
in interface java.sql.Connection
java.sql.SQLException
public java.sql.NClob createNClob() throws java.sql.SQLException
createNClob
in interface java.sql.Connection
java.sql.SQLException
public java.sql.SQLXML createSQLXML() throws java.sql.SQLException
createSQLXML
in interface java.sql.Connection
java.sql.SQLException
public java.sql.Struct createStruct(java.lang.String typeName, java.lang.Object[] attributes) throws java.sql.SQLException
createStruct
in interface java.sql.Connection
java.sql.SQLException
public boolean isValid(int timeout) throws java.sql.SQLException
isValid
in interface java.sql.Connection
java.sql.SQLException
public void setClientInfo(java.lang.String name, java.lang.String value) throws java.sql.SQLClientInfoException
setClientInfo
in interface java.sql.Connection
java.sql.SQLClientInfoException
public void setClientInfo(java.util.Properties properties) throws java.sql.SQLClientInfoException
setClientInfo
in interface java.sql.Connection
java.sql.SQLClientInfoException
public java.lang.String getClientInfo(java.lang.String name) throws java.sql.SQLException
getClientInfo
in interface java.sql.Connection
java.sql.SQLException
public java.util.Properties getClientInfo() throws java.sql.SQLException
getClientInfo
in interface java.sql.Connection
java.sql.SQLException
public boolean isWrapperFor(java.lang.Class<?> iface) throws java.sql.SQLException
isWrapperFor
in interface java.sql.Wrapper
iface
- requested interfacejava.sql.SQLException
- if the argument is not an interfaceprotected <T> T proxyFor(java.lang.Object obj, java.lang.Class<T> iface) throws java.sql.SQLException
java.sql.SQLException
public <T> T unwrap(java.lang.Class<T> iface) throws java.sql.SQLException
unwrap
in interface java.sql.Wrapper
iface
- requested interfacejava.sql.SQLException
- if this does not implement the arg or
the arg is not an interfacepublic void abort(java.util.concurrent.Executor executor) throws java.sql.SQLException
abort
in interface java.sql.Connection
java.sql.SQLException
public int getNetworkTimeout() throws java.sql.SQLException
getNetworkTimeout
in interface java.sql.Connection
java.sql.SQLException
public java.lang.String getSchema() throws java.sql.SQLException
getSchema
in interface java.sql.Connection
java.sql.SQLException
public void setNetworkTimeout(java.util.concurrent.Executor executor, int milliseconds) throws java.sql.SQLException
setNetworkTimeout
in interface java.sql.Connection
java.sql.SQLException
public void setSchema(java.lang.String schema) throws java.sql.SQLException
setSchema
in interface java.sql.Connection
java.sql.SQLException
public DatabaseChangeRegistration registerDatabaseChangeNotification(java.util.Properties options) throws java.sql.SQLException
OracleConnection
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.
It is recommended to use OracleConnection.DCN_CLIENT_INIT_CONNECTION
option when
connecting to an Oracle Database running in the cloud to prevent connection
failures when it's the server that initiates the connection to the client.
Please note that grouping of notifications are not supported with
OracleConnection.DCN_CLIENT_INIT_CONNECTION
.
registerDatabaseChangeNotification
in interface OracleConnection
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.OracleConnection.DCN_CLIENT_INIT_CONNECTION
: "true"/["false"].
This can be configured to initiate a connection from the client instead of
opening a listener socket for receiving the database change notifications.
Set the value to 'true' for using the Client initiated DCN connection.
By default the value is 'false' and opens a listening socket for receiving
notifications from the server.OracleConnection.DCN_USE_HOST_CONNECTION_ADDR_INFO
: ["true"]/"false".
Set the value to 'false' to use the address info returned by the server
for establishing the client initiated DCN Connection. Default value is 'true'
and the database hostname and port information present in this database connection's
connection string is used for establishing the client initiated DCN connection.java.sql.SQLException
public DatabaseChangeRegistration getDatabaseChangeRegistration(int regid) throws java.sql.SQLException
OracleConnection
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.
getDatabaseChangeRegistration
in interface OracleConnection
regid
- The id of the registrationjava.sql.SQLException
public void unregisterDatabaseChangeNotification(DatabaseChangeRegistration registration) throws java.sql.SQLException
OracleConnection
This method interrupts the notification thread and removes all listeners attached to this registration before closing it.
unregisterDatabaseChangeNotification
in interface OracleConnection
java.sql.SQLException
OracleConnection.unregisterDatabaseChangeNotification(long,String)
public void unregisterDatabaseChangeNotification(int registrationId, java.lang.String host, int tcpport) throws java.sql.SQLException
OracleConnection
This method will throw an "ORA-24950: unregister failed, registration not found" if you don't provide the correct TCP port which can be extracted from the "callback" value in the "USER_CHANGE_NOTIFICATION_REGS" table.
unregisterDatabaseChangeNotification
in interface OracleConnection
java.sql.SQLException
OracleConnection.unregisterDatabaseChangeNotification(long,String)
public void unregisterDatabaseChangeNotification(int registrationId) throws java.sql.SQLException
OracleConnection
unregisterDatabaseChangeNotification
in interface OracleConnection
java.sql.SQLException
OracleConnection.unregisterDatabaseChangeNotification(long, String)
public void unregisterDatabaseChangeNotification(long registrationId, java.lang.String callback) throws java.sql.SQLException
OracleConnection
This flavor of unregisterDatabaseChangeNotification
can be used to
process the result of the following query:
select regid,callback from USER_CHANGE_NOTIFICATION_REGS;
.
For example to remove all registrations from the database you would execute the following code:
Statement stmt= conn.createStatement(); ResultSet rs = stmt.executeQuery("select regid,callback from USER_CHANGE_NOTIFICATION_REGS"); while(rs.next()) { long regid = rs.getLong(1); String callback = rs.getString(2); ((OracleConnection)conn).unregisterDatabaseChangeNotification(regid,callback); } rs.close(); stmt.close();
unregisterDatabaseChangeNotification
in interface OracleConnection
java.sql.SQLException
OracleConnection.unregisterDatabaseChangeNotification(oracle.jdbc.dcn.DatabaseChangeRegistration)
public AQNotificationRegistration[] registerAQNotification(java.lang.String[] name, java.util.Properties[] options, java.util.Properties globaloptions) throws java.sql.SQLException
OracleConnection
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.
registerAQNotification
in interface OracleConnection
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.
java.sql.SQLException
public void unregisterAQNotification(AQNotificationRegistration registration) throws java.sql.SQLException
OracleConnection
unregisterAQNotification
in interface OracleConnection
java.sql.SQLException
public AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo) throws java.sql.SQLException
OracleConnection
dequeue
in interface OracleConnection
queueName
- name of the queue from which to dequeue.opt
- dequeue optionstdo
- the Type Descriptor Object OID of the type of the queue.java.sql.SQLException
public AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo, int version) throws java.sql.SQLException
OracleConnection
dequeue
in interface OracleConnection
queueName
- name of the queue from which to dequeue.opt
- dequeue optionstdo
- the Type Descriptor Object OID of the type of the queue.version
- the version of the type Descriptorjava.sql.SQLException
public AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, java.lang.String typeName) throws java.sql.SQLException
OracleConnection
dequeue
in interface OracleConnection
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".java.sql.SQLException
public AQMessage[] dequeue(java.lang.String queueName, AQDequeueOptions opt, java.lang.String typeName, int deqsize) throws java.sql.SQLException
OracleConnection
dequeue
in interface OracleConnection
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".deqsize
- dequeue number of messagesjava.sql.SQLException
public AQMessage[] dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo, int version, int deqsize) throws java.sql.SQLException
OracleConnection
dequeue
in interface OracleConnection
queueName
- name of the queue from which to dequeue.opt
- dequeue optionstdo
- the Type Descriptor Object OID of the type of the queue.version
- the version of the type Descriptordeqsize
- dequeue number of messagesjava.sql.SQLException
public void enqueue(java.lang.String queueName, AQEnqueueOptions opt, AQMessage mesg) throws java.sql.SQLException
OracleConnection
enqueue
in interface OracleConnection
queueName
- name of the queue where to enqueue.opt
- enqueue options.mesg
- the AQ message to enqueue.java.sql.SQLException
public int enqueue(java.lang.String queueName, AQEnqueueOptions opt, AQMessage[] mesgs) throws java.sql.SQLException
OracleConnection
enqueue
in interface OracleConnection
queueName
- name of the queue where to enqueue.opt
- enqueue options.mesgs
- the array of AQ messages to enqueue.java.sql.SQLException
public void commit(java.util.EnumSet<OracleConnection.CommitOption> flags) throws java.sql.SQLException
OracleConnection
commit
in interface OracleConnection
flags
- commit optionsjava.sql.SQLException
public void cancel() throws java.sql.SQLException
OracleConnection
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.
cancel
in interface OracleConnection
java.sql.SQLException
- if the cancel operation failspublic void abort() throws java.sql.SQLException
OracleConnection
abort
in interface OracleConnection
java.sql.SQLException
- -- Io Exception: Socket closed - ORA-17002
TNS:not connected - ORA-12153public TypeDescriptor[] getAllTypeDescriptorsInCurrentSchema() throws java.sql.SQLException
OracleConnection
getAllTypeDescriptorsInCurrentSchema
in interface OracleConnection
java.sql.SQLException
- If an error occurs.public TypeDescriptor[] getTypeDescriptorsFromListInCurrentSchema(java.lang.String[] typeNames) throws java.sql.SQLException
OracleConnection
getTypeDescriptorsFromListInCurrentSchema
in interface OracleConnection
typeNames
- An array of Strings which are type names. Use upper case
unless the type names are mixed case names.java.sql.SQLException
- if the specified type does not exist, or if an error
occurred.public TypeDescriptor[] getTypeDescriptorsFromList(java.lang.String[][] schemaAndTypeNamePairs) throws java.sql.SQLException
OracleConnection
getTypeDescriptorsFromList
in interface OracleConnection
schemaAndTypeNamePairs
- An array of arrays of Strings which are pairs of schema
and type names.java.sql.SQLException
- if any of the specified types does not exist, or if an error
occurs.public java.lang.String getDataIntegrityAlgorithmName() throws java.sql.SQLException
OracleConnection
getDataIntegrityAlgorithmName
in interface OracleConnection
java.sql.SQLException
public java.lang.String getEncryptionAlgorithmName() throws java.sql.SQLException
OracleConnection
getEncryptionAlgorithmName
in interface OracleConnection
java.sql.SQLException
public SecurityInformation getSecurityInformation() throws java.sql.SQLException
OracleConnection
Thin driver
.
Throws UnsupportedOperationException
if this feature is not supported by
the underlying driver implementation.getSecurityInformation
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_WALLET_LOCATION
,
OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL
,
OracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL
public java.lang.String getAuthenticationAdaptorName() throws java.sql.SQLException
OracleConnection
getAuthenticationAdaptorName
in interface OracleConnection
java.sql.SQLException
public boolean isUsable()
OracleConnection
isUsable
in interface OracleConnection
protected oracle.jdbc.internal.OracleConnection getConnectionDuringExceptionHandling()
public void setDefaultTimeZone(java.util.TimeZone tz) throws java.sql.SQLException
setDefaultTimeZone
in interface OracleConnection
tz
- Default TimeZone to be used for all Date, Time and Timestamp
conversions.java.sql.SQLException
- if there is an issue while setting the TimeZonepublic java.util.TimeZone getDefaultTimeZone() throws java.sql.SQLException
getDefaultTimeZone
in interface OracleConnection
java.sql.SQLException
- If there is any issue while retrieving the TimeZonepublic void setApplicationContext(java.lang.String nameSpace, java.lang.String attribute, java.lang.String value) throws java.sql.SQLException
OracleConnection
setApplicationContext
in interface OracleConnection
nameSpace
- The namespace where this attribute/value pairs
will be stored. The only supported namespace is CLIENTCONTEXT.
The value cannot be null nor empty.attribute
- The attribute whose value needs to be set. If
the value is null then a NullPointerException is thrown. If the
value is an empty string (""), then the namespace will be cleared
and the value is ignored.value
- The value of the attribute. If the value is null then
a NullPointerException is thrown. If the
value is an empty string (""), then the attribute will be cleared.java.sql.SQLException
- If an error occursOracleConnection.clearAllApplicationContext(java.lang.String)
,
Connection.setClientInfo(java.lang.String, java.lang.String)
,
Connection.setClientInfo(java.util.Properties)
public void clearAllApplicationContext(java.lang.String nameSpace) throws java.sql.SQLException
OracleConnection
clearAllApplicationContext
in interface OracleConnection
nameSpace
- The namespace which will be clearedjava.sql.SQLException
OracleConnection.setApplicationContext(java.lang.String, java.lang.String, java.lang.String)
,
Connection.setClientInfo(java.util.Properties)
public void addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener) throws java.sql.SQLException
OracleConnection
LogicalTransactionIdEventListener
interface. A listener instance must then be registered using this method.addLogicalTransactionIdEventListener
in interface OracleConnection
java.sql.SQLException
public void addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener, java.util.concurrent.Executor executor) throws java.sql.SQLException
OracleConnection
addLogicalTransactionIdEventListener
can be used to register
a listener with an executor. When a Logical Transaction Id event is triggered the driver
will use this executor to call the listener's onLogicalTransactionIdEvent
method. Typically you would call this method if you want onLogicalTransactionIdEvent
to be executed in a separate thread.addLogicalTransactionIdEventListener
in interface OracleConnection
java.sql.SQLException
public void removeLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener) throws java.sql.SQLException
OracleConnection
removeLogicalTransactionIdEventListener
in interface OracleConnection
java.sql.SQLException
public LogicalTransactionId getLogicalTransactionId() throws java.sql.SQLException
OracleConnection
getLogicalTransactionId
in interface OracleConnection
java.sql.SQLException
public java.util.Set<java.lang.String> getProviderAllowedProperties()
OracleConnection
getProviderAllowedProperties
in interface OracleConnection
public boolean needToPurgeStatementCache() throws java.sql.SQLException
needToPurgeStatementCache
in interface OracleConnection
java.sql.SQLException
OracleConnection.isDRCPEnabled()
,
OracleConnection.attachServerConnection()
,
OracleConnection.detachServerConnection(java.lang.String)
public boolean attachServerConnection() throws java.sql.SQLException
needToPurgeStatementCache()
returns true if the
underlying session has changed and if the local statement cache should
be purged.
attachServerConnection
in interface OracleConnection
java.sql.SQLException
- If there is an exception while obtaining server processisDRCPEnabled()
,
detachServerConnection(java.lang.String)
,
needToPurgeStatementCache()
public void detachServerConnection(java.lang.String tag) throws java.sql.SQLException
attachServerConnection()
on this connection the server will
attempt to pair this connection with the server process of the same tag.detachServerConnection
in interface OracleConnection
tag
- A string value that the connection will be associated in the
server. null is a valid argument when no tagging
required.java.sql.SQLException
- If there was an exception while releasingisDRCPEnabled()
,
attachServerConnection()
,
needToPurgeStatementCache()
public boolean isDRCPEnabled() throws java.sql.SQLException
isDRCPEnabled
in interface OracleConnection
java.sql.SQLException
- if there is an error while processing the requestattachServerConnection()
,
detachServerConnection(java.lang.String)
,
needToPurgeStatementCache()
public boolean isDRCPMultitagEnabled() throws java.sql.SQLException
isDRCPMultitagEnabled
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG
public java.lang.String getDRCPReturnTag() throws java.sql.SQLException
getDRCPReturnTag
in interface OracleConnection
java.sql.SQLException
detachServerConnection(java.lang.String)
,
OracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG
public java.lang.String getDRCPPLSQLCallbackName() throws java.sql.SQLException
Null
getDRCPPLSQLCallbackName
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_DRCP_PLSQL_CALLBACK
,
OracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAG
public void beginRequest() throws java.sql.SQLException
OracleConnection
beginRequest
in interface OracleConnection
java.sql.SQLException
- When called with an open transaction
on this connection.public void endRequest() throws java.sql.SQLException
OracleConnection
endRequest
in interface OracleConnection
java.sql.SQLException
- When called with an open transaction on this
connection.public void setShardingKey(OracleShardingKey key, OracleShardingKey superKey) throws java.sql.SQLException
OracleConnection
setShardingKey
in interface OracleConnection
key
- Sharding key to be set on this connectionsuperKey
- Super Sharding key to be set on this connectionjava.sql.SQLException
- if there is an exception while setting the sharding keys on this
connection.public boolean setShardingKeyIfValid(OracleShardingKey key, OracleShardingKey superKey, int timeout) throws java.sql.SQLException
OracleConnection
setShardingKeyIfValid
in interface OracleConnection
key
- Sharding key to be validated and set against this connection. Not
null.superKey
- Super Sharding key to be validated and set against this connection.
May be null.timeout
- Time in seconds before which the validation process is expected to
be complete, else the validation process is aborted.
The value of the timeout must be set to zero to disable the timeout
during the validation.java.sql.SQLException
- if there is any exception while performing this validation or if
timeout value is less than 0.public boolean setShardingKeyIfValid(OracleShardingKey shardingKey, int timeout) throws java.sql.SQLException
OracleConnection
setShardingKeyIfValid
in interface OracleConnection
shardingKey
- Sharding key to be validated and set against this connection.
Not null.timeout
- Time in seconds before which the validation process is expected to
be complete, else the validation process is aborted.
The value of the timeout must be set to zero to disable the timeout
during the validation.java.sql.SQLException
- if there is any exception while performing this validation or if
timeout value is less than 0.public void setShardingKey(OracleShardingKey shardingKey) throws java.sql.SQLException
OracleConnection
setShardingKey
in interface OracleConnection
shardingKey
- Sharding key to be set on this connectionjava.sql.SQLException
- if there is an exception while setting the sharding keys on this
connection.public OracleConnection.DRCPState getDRCPState() throws java.sql.SQLException
OracleConnection
getDRCPState
in interface OracleConnection
OracleConnection.DRCPState.DETACHED
if the connection is detached. OracleConnection.DRCPState.ATTACHED_IMPLICIT
or OracleConnection.DRCPState.ATTACHED_EXPLICIT
if the connection is attached.java.sql.SQLException
OracleConnection.attachServerConnection()
,
OracleConnection.detachServerConnection(java.lang.String)
,
OracleConnection.isDRCPEnabled()
public java.util.Properties getServerSessionInfo() throws java.sql.SQLException
OracleConnection
oracle.jdbc.driver.T4CTTIoauthenticate
,
many of the values are received from that TTC call.getServerSessionInfo
in interface OracleConnection
Properties
objectjava.sql.SQLException
public java.lang.String getServerSessionInfo(java.lang.String key) throws java.sql.SQLException
OracleConnection
key
that the server returns
at connection time. See oracle.jdbc.driver.T4CTTIoauthenticate
,
many of the values are received from that TTC call.getServerSessionInfo
in interface OracleConnection
key
- Key to look upkey
, or null
if there is
no association.java.sql.SQLException
public boolean isValid(OracleConnection.ConnectionValidation effort, int timeout) throws java.sql.SQLException
OracleConnection
effort
at the instant during this call it was checked.
It does not imply it is still working after the call returns, only it
worked at some point during the call. Returns false if the connection is
not working properly at the instant during the call when it is checked or
if the timeout is exceeded while checking.isValid
in interface OracleConnection
effort
- How much effort to expend checking the connection.
Note : The Bequeath (BEQ) protocol supports only COMPLETE
,
SERVER
and NETWORK
.
Using other values may return incorrect result and should be avoided.
timeout
- The time in seconds to wait for the validation action to complete.
If the timeout expires before the action completes the method
returns false. A value of 0 means no limit.java.sql.SQLException
- if timeout < 0OracleConnection.ConnectionValidation
public java.lang.String getEncryptionProviderName() throws java.sql.SQLException
OracleConnection
null
.getEncryptionProviderName
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL
public java.lang.String getChecksumProviderName() throws java.sql.SQLException
OracleConnection
null
.getChecksumProviderName
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVEL
public java.lang.String getNetConnectionId() throws java.sql.SQLException
OracleConnection
getNetConnectionId
in interface OracleConnection
java.sql.SQLException
OracleConnection.CONNECTION_PROPERTY_THIN_NET_CONNECTIONID_PREFIX
public void disableLogging() throws java.sql.SQLException
OracleConnection
disableLogging
in interface OracleConnection
java.sql.SQLException
- if an error occurs while disabling logging for the
connectionOracleConnection.CONNECTION_PROPERTY_ENABLE_LOGGING
,
OracleConnection.enableLogging()
public void enableLogging() throws java.sql.SQLException
OracleConnection
enableLogging
in interface OracleConnection
java.sql.SQLException
- if an error occurs while enabling logging for the
connectionOracleConnection.CONNECTION_PROPERTY_ENABLE_LOGGING
,
OracleConnection.disableLogging()
public void dumpLog() throws java.sql.SQLException
OracleConnection
dumpLog
in interface OracleConnection
java.sql.SQLException
- if an error occurs while dumping the trace data.