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_APPLICATION_CONTEXT, CONNECTION_PROPERTY_APPLICATION_CONTEXT_ACCESSMODE, CONNECTION_PROPERTY_APPLICATION_CONTEXT_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_CREDENTIALS, CONNECTION_PROPERTY_AZURE_CREDENTIALS_ACCESSMODE, CONNECTION_PROPERTY_AZURE_CREDENTIALS_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_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_MAP_STRING_PARAMETER_TO_CHAR, CONNECTION_PROPERTY_MAP_STRING_PARAMETER_TO_CHAR_ACCESSMODE, CONNECTION_PROPERTY_MAP_STRING_PARAMETER_TO_CHAR_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_PEM_PRIVATE_KEY_INDEX, CONNECTION_PROPERTY_PEM_PRIVATE_KEY_INDEX_ACCESSMODE, CONNECTION_PROPERTY_PEM_PRIVATE_KEY_INDEX_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_JSON, CONNECTION_PROPERTY_PROVIDER_JSON_ACCESSMODE, CONNECTION_PROPERTY_PROVIDER_JSON_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_CONTEXT_CACHE_SIZE, CONNECTION_PROPERTY_THIN_SSL_CONTEXT_CACHE_SIZE_ACCESSMODE, CONNECTION_PROPERTY_THIN_SSL_CONTEXT_CACHE_SIZE_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_PROPERTY_XA_THROUGH_SESSIONLESS_TRANSACTIONS, CONNECTION_PROPERTY_XA_THROUGH_SESSIONLESS_TRANSACTIONS_ACCESSMODE, CONNECTION_PROPERTY_XA_THROUGH_SESSIONLESS_TRANSACTIONS_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.
|
byte[] |
getTransactionId() |
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.
|
boolean |
isXAThroughSessionlessTransactions() |
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 |
resumeTransaction(byte[] GTRID)
Resumes a sessionless transaction.
|
void |
resumeTransaction(byte[] GTRID,
int timeout)
Resumes a sessionless transaction.
|
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.
|
byte[] |
startTransaction()
Starts a sessionless transaction.
|
void |
startTransaction(byte[] GTRID)
Starts a sessionless transaction.
|
void |
startTransaction(byte[] GTRID,
int timeout)
Starts a sessionless transaction.
|
byte[] |
startTransaction(int timeout)
Starts a sessionless transaction.
|
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 |
suspendTransaction()
Suspends current active sessionless transaction.
|
void |
suspendTransactionImmediately()
Suspends current active sessionless transaction.
|
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, waitapplyConnectionAttributes, close, getConnectionAttributes, getConnectionReleasePriority, getUnMatchedConnectionAttributes, registerConnectionCacheCallback, setConnectionReleasePriorityprotected OracleConnection connection
public OracleConnectionWrapper()
public OracleConnectionWrapper(OracleConnection toBeWrapped)
toBeWrapped - Connection to wrappublic OracleConnection unwrap()
unwrap in interface OracleConnectionpublic java.lang.String getDatabaseTimeZone()
throws java.sql.SQLException
java.sql.SQLExceptionpublic void setWrapper(OracleConnection wrapper)
setWrapper in interface OracleConnectionwrapper - public java.sql.Statement createStatement()
throws java.sql.SQLException
createStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.CallableStatement prepareCall(java.lang.String sql)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.lang.String nativeSQL(java.lang.String sql)
throws java.sql.SQLException
nativeSQL in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setAutoCommit(boolean autoCommit)
throws java.sql.SQLException
setAutoCommit in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean getAutoCommit()
throws java.sql.SQLException
getAutoCommit in interface java.sql.Connectionjava.sql.SQLExceptionpublic void commit()
throws java.sql.SQLException
commit in interface java.sql.Connectionjava.sql.SQLExceptionpublic void rollback()
throws java.sql.SQLException
rollback in interface java.sql.Connectionjava.sql.SQLExceptionpublic void close()
throws java.sql.SQLException
close in interface java.lang.AutoCloseableclose in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean isClosed()
throws java.sql.SQLException
isClosed in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.DatabaseMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setReadOnly(boolean readOnly)
throws java.sql.SQLException
setReadOnly in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean isReadOnly()
throws java.sql.SQLException
isReadOnly in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setCatalog(java.lang.String catalog)
throws java.sql.SQLException
setCatalog in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.lang.String getCatalog()
throws java.sql.SQLException
getCatalog in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setTransactionIsolation(int level)
throws java.sql.SQLException
setTransactionIsolation in interface java.sql.Connectionjava.sql.SQLExceptionpublic int getTransactionIsolation()
throws java.sql.SQLException
getTransactionIsolation in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
getWarnings in interface java.sql.Connectionjava.sql.SQLExceptionpublic void clearWarnings()
throws java.sql.SQLException
clearWarnings in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Statement createStatement(int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
createStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.CallableStatement prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.util.Map<java.lang.String,java.lang.Class<?>> getTypeMap()
throws java.sql.SQLException
getTypeMap in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
setTypeMap in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean isProxySession()
OracleConnectionisProxySession in interface OracleConnectionOracleConnection.openProxySession(int, java.util.Properties)public void openProxySession(int mode,
java.util.Properties prop)
throws java.sql.SQLException
OracleConnectionopenProxySession in interface OracleConnectionmode - has to be either OracleConnection.PROXYTYPE_USER_NAME
or OracleConnection.PROXYTYPE_DISTINGUISHED_NAME or
OracleConnection.PROXYTYPE_CERTIFICATEprop - keys/valuesjava.sql.SQLExceptionpublic void archive(int mode,
int aseq,
java.lang.String acstext)
throws java.sql.SQLException
OracleConnectionarchive in interface OracleConnectionjava.sql.SQLExceptionpublic boolean getAutoClose()
throws java.sql.SQLException
OracleConnectiongetAutoClose in interface OracleConnectionjava.sql.SQLException - should never been raisedsetAutoClosepublic java.sql.CallableStatement getCallWithKey(java.lang.String key)
throws java.sql.SQLException
OracleConnectiongetCallWithKey in interface OracleConnectionkey - Specified key to search forjava.sql.SQLExceptionpublic int getDefaultExecuteBatch()
OracleConnectiongetDefaultExecuteBatch in interface OracleConnectionOraclePreparedStatement.setExecuteBatch,
setDefaultExecuteBatchpublic int getDefaultRowPrefetch()
OracleConnectionThe 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 OracleConnectionOracleStatement.setRowPrefetch,
setDefaultRowPrefetchpublic java.lang.Object getDescriptor(java.lang.String sql_name)
OracleConnectiongetDescriptor in interface OracleConnectionsql_name - the sql typeputDescriptor,
oracle.sql.TypeDescriptorpublic java.lang.Object doGetDescriptor(java.lang.String sql_name)
public java.lang.String[] getEndToEndMetrics()
throws java.sql.SQLException
OracleConnectiongetEndToEndMetrics in interface OracleConnectionjava.sql.SQLException - if an error occurssetEndToEndMetrics,
Connection.getClientInfo(java.lang.String),
Connection.getClientInfo()public short getEndToEndECIDSequenceNumber()
throws java.sql.SQLException
OracleConnectiongetEndToEndECIDSequenceNumber in interface OracleConnectionjava.sql.SQLException - if an error occursConnection.getClientInfo(java.lang.String),
Connection.getClientInfo()public boolean getIncludeSynonyms()
OracleConnectionDatabaseMetaData.getColumns.
By default and for performance reasons it won't but you can change this with the
setIncludeSynonyms method.getIncludeSynonyms in interface OracleConnectionDatabaseMetaData.getColumns will report
information if a table synonym is passed in, and false otherwisesetIncludeSynonymspublic boolean getRestrictGetTables()
OracleConnectionDatabaseMetaData.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 OracleConnectionDatabaseMetaData.getTables is restricted, and false otherwisesetRestrictGetTablespublic boolean getImplicitCachingEnabled()
throws java.sql.SQLException
OracleConnectiongetImplicitCachingEnabled in interface OracleConnectionjava.sql.SQLExceptionpublic boolean getExplicitCachingEnabled()
throws java.sql.SQLException
OracleConnectiongetExplicitCachingEnabled in interface OracleConnectionjava.sql.SQLExceptionpublic java.lang.Object getJavaObject(java.lang.String sql_name)
throws java.sql.SQLException
getJavaObject in interface OracleConnectionjava.sql.SQLExceptionpublic boolean getRemarksReporting()
OracleConnectiongetTables 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 OracleConnectionDatabaseMetaData calls getTables
and getColumns will report the REMARKS column and false otherwisesetRemarksReportingpublic java.lang.String getSQLType(java.lang.Object obj)
throws java.sql.SQLException
getSQLType in interface OracleConnectionjava.sql.SQLExceptionpublic int getStmtCacheSize()
getStmtCacheSize in interface OracleConnectionpublic int getStatementCacheSize()
throws java.sql.SQLException
OracleConnectiongetStatementCacheSize in interface OracleConnectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement getStatementWithKey(java.lang.String key)
throws java.sql.SQLException
OracleConnectiongetStatementWithKey in interface OracleConnectionkey - Specified key to search forjava.sql.SQLExceptionpublic short getStructAttrCsId()
throws java.sql.SQLException
OracleConnectiongetStructAttrCsId in interface OracleConnectionjava.sql.SQLException - if Conversion is nullpublic java.lang.String getUserName()
throws java.sql.SQLException
OracleConnectionExample where conn is your connection object:
String UserName = ((OracleConnection)conn).getUserName();
getUserName in interface OracleConnectionjava.sql.SQLException - if the logical connection is closedpublic java.lang.String getCurrentSchema()
throws java.sql.SQLException
OracleConnectiongetCurrentSchema in interface OracleConnectionjava.sql.SQLException - If there was an error while fetching the resultspublic boolean getUsingXAFlag()
OracleConnectionUsingXA 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 OracleConnectiontrue when using XA to manage distributed transactions
and false otherwise.setUsingXAFlagpublic boolean getXAErrorFlag()
OracleConnectionXAError 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 OracleConnectionsetXAErrorFlagpublic OracleSavepoint oracleSetSavepoint() throws java.sql.SQLException
OracleConnectionOracleSavepoint object that
represents it.oracleSetSavepoint in interface OracleConnectionOracleSavepoint objectjava.sql.SQLException - if a database access error occurs
or this Connection object is currently in
auto-commit modeOracleSavepointpublic OracleSavepoint oracleSetSavepoint(java.lang.String name) throws java.sql.SQLException
OracleConnectionOracleSavepoint object that
represents it.oracleSetSavepoint in interface OracleConnectionname - 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 modeOracleSavepointpublic void oracleRollback(OracleSavepoint savepoint) throws java.sql.SQLException
OracleConnectionOracleSavepoint
object was set.
This method should be used only when auto-commit has been disabled.
oracleRollback in interface OracleConnectionsavepoint - 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 modeOracleSavepointpublic void oracleReleaseSavepoint(OracleSavepoint savepoint) throws java.sql.SQLException
OracleConnectionOracleSavepoint 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 OracleConnectionsavepoint - 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 transactionOracleSavepointpublic int pingDatabase()
throws java.sql.SQLException
OracleConnectionpingDatabase in interface OracleConnectionjava.sql.SQLExceptionpublic int pingDatabase(int timeOut)
throws java.sql.SQLException
OracleConnectionpingDatabase in interface OracleConnectionjava.sql.SQLExceptionpublic void purgeExplicitCache()
throws java.sql.SQLException
OracleConnectionpurgeExplicitCache in interface OracleConnectionjava.sql.SQLExceptionpublic void purgeImplicitCache()
throws java.sql.SQLException
OracleConnectionpurgeImplicitCache in interface OracleConnectionjava.sql.SQLExceptionpublic void putDescriptor(java.lang.String sql_name,
java.lang.Object desc)
throws java.sql.SQLException
OracleConnectionputDescriptor in interface OracleConnectionsql_name - the sql typedesc - the Object Descriptor associatedjava.sql.SQLException - if sql_name or desc is nullgetDescriptor,
oracle.sql.TypeDescriptorpublic void removeDescriptor(java.lang.String sql_name)
OracleConnectionremoveDescriptor in interface OracleConnectionpublic void removeDescriptor(byte[] toid)
OracleConnectionremoveDescriptor in interface OracleConnectionpublic void removeAllDescriptor()
OracleConnectionremoveAllDescriptor in interface OracleConnectionpublic void registerSQLType(java.lang.String sql_name,
java.lang.Class<?> java_class)
throws java.sql.SQLException
registerSQLType in interface OracleConnectionjava.sql.SQLExceptionpublic void registerSQLType(java.lang.String sql_name,
java.lang.String java_class_name)
throws java.sql.SQLException
registerSQLType in interface OracleConnectionjava.sql.SQLExceptionpublic void setAutoClose(boolean autoClose)
throws java.sql.SQLException
OracleConnectionsetAutoClose in interface OracleConnectionautoClose - the boolean valuejava.sql.SQLException - when the argument autoClose is falsegetAutoClosepublic void setDefaultExecuteBatch(int batch)
throws java.sql.SQLException
OracleConnectionsetDefaultExecuteBatch in interface OracleConnectionbatch - value is discarded.java.sql.SQLException - never thrown.OraclePreparedStatement.setExecuteBatch,
getDefaultExecuteBatchpublic 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 OracleConnectionvalue - the number of rows to prefetchjava.sql.SQLException - if the argument value is <=0OracleStatement.setRowPrefetch,
getDefaultRowPrefetchpublic void setEndToEndMetrics(java.lang.String[] metrics,
short sequenceNumber)
throws java.sql.SQLException
OracleConnectionsetEndToEndMetrics in interface OracleConnectionmetrics - 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
OracleConnectionsetExplicitCachingEnabled in interface OracleConnectioncache - 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
OracleConnectionsetImplicitCachingEnabled in interface OracleConnectioncache - 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)
OracleConnectionSimilar 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 OracleConnectionsynonyms - true if you want to retrieve synonym information
in DatabaseMetaData.getColumns and false otherwise.getIncludeSynonymspublic void setRemarksReporting(boolean reportRemarks)
OracleConnectiongetTables 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 OracleConnectionreportRemarks - true if you want to turn on the reporting of
the REMARKS columns and false otherwise.getRemarksReportingpublic void setRestrictGetTables(boolean restrict)
OracleConnectionDatabaseMetaData.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 OracleConnectionrestrict - true to turn on the restriction and false
otherwise.getRestrictGetTablespublic void setStmtCacheSize(int size)
throws java.sql.SQLException
setStmtCacheSize in interface OracleConnectionjava.sql.SQLExceptionpublic void setStatementCacheSize(int size)
throws java.sql.SQLException
OracleConnectionsetStatementCacheSize in interface OracleConnectionsize - 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 OracleConnectionjava.sql.SQLExceptionpublic void setUsingXAFlag(boolean value)
OracleConnectionUsingXA 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 OracleConnectionvalue - the value of the UsingXA flaggetUsingXAFlagpublic void setXAErrorFlag(boolean value)
OracleConnectionXAError 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 OracleConnectionvalue - the value of the XAError flaggetXAErrorFlagpublic void shutdown(OracleConnection.DatabaseShutdownMode mode) throws java.sql.SQLException
OracleConnectionshutdown in interface OracleConnectionmode - can be either OracleConnection.DatabaseShutdownMode.CONNECTOracleConnection.DatabaseShutdownMode.TRANSACTIONALOracleConnection.DatabaseShutdownMode.TRANSACTIONAL_LOCALOracleConnection.DatabaseShutdownMode.IMMEDIATEOracleConnection.DatabaseShutdownMode.ABORTOracleConnection.DatabaseShutdownMode.FINALjava.sql.SQLExceptionpublic void startup(java.lang.String startup_str,
int mode)
throws java.sql.SQLException
OracleConnectionstartup in interface OracleConnectionjava.sql.SQLExceptionpublic void startup(OracleConnection.DatabaseStartupMode mode) throws java.sql.SQLException
OracleConnectionstartup in interface OracleConnectionmode - can be either OracleConnection.DatabaseStartupMode.NO_RESTRICTIONOracleConnection.DatabaseStartupMode.FORCEOracleConnection.DatabaseStartupMode.RESTRICTjava.sql.SQLExceptionpublic void startup(OracleConnection.DatabaseStartupMode mode, java.lang.String pfileName) throws java.sql.SQLException
OracleConnectionstartup in interface OracleConnectionmode - can be either OracleConnection.DatabaseStartupMode.NO_RESTRICTIONOracleConnection.DatabaseStartupMode.FORCEOracleConnection.DatabaseStartupMode.RESTRICTjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatementWithKey(java.lang.String key)
throws java.sql.SQLException
prepareStatementWithKey in interface OracleConnectionkey - 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 OracleConnectionkey - the key with which it was closedjava.sql.SQLException - if a database access error occurspublic void setCreateStatementAsRefCursor(boolean value)
OracleConnectiontrue, 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 OracleConnectionvalue - true if new statements should be created as
REF CURSORS, false otherwisegetCreateStatementAsRefCursorpublic boolean getCreateStatementAsRefCursor()
OracleConnectioncreateStatementAsRefCursor 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 OracleConnectionsetCreateStatementAsRefCursorpublic void setSessionTimeZone(java.lang.String regionName)
throws java.sql.SQLException
OracleConnectionThis 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 OracleConnectionregionName - Oracle session time zone region name.java.sql.SQLException - if an error occurred.public java.lang.String getSessionTimeZone()
OracleConnectiongetSessionTimeZone in interface OracleConnectionpublic 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 OracleConnectionjava.sql.SQLExceptionpublic java.sql.Connection _getPC()
OracleConnection_getPC in interface OracleConnectionpublic boolean isLogicalConnection()
OracleConnectionisLogicalConnection in interface OracleConnectionpublic void registerTAFCallback(OracleOCIFailover cbk, java.lang.Object obj) throws java.sql.SQLException
OracleConnectionregisterTAFCallback in interface OracleConnectioncbk - 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()
OracleConnectionReturns 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 OracleConnectionpublic void close(int opt)
throws java.sql.SQLException
OracleConnectionclose in interface OracleConnectionopt - 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
OracleConnectionsetPlsqlWarnings in interface OracleConnectionsetting - 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.Connectionjava.sql.SQLExceptionpublic int getHoldability()
throws java.sql.SQLException
getHoldability in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Statement createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
createStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.CallableStatement prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Savepoint setSavepoint()
throws java.sql.SQLException
setSavepoint in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Savepoint setSavepoint(java.lang.String name)
throws java.sql.SQLException
setSavepoint in interface java.sql.Connectionjava.sql.SQLExceptionpublic void rollback(java.sql.Savepoint savepoint)
throws java.sql.SQLException
rollback in interface java.sql.Connectionjava.sql.SQLExceptionpublic void releaseSavepoint(java.sql.Savepoint savepoint)
throws java.sql.SQLException
releaseSavepoint in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.PreparedStatement prepareStatement(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionjava.sql.SQLExceptionpublic ARRAY createARRAY(java.lang.String typeName, java.lang.Object elements) throws java.sql.SQLException
createARRAY in interface OracleConnectiontypeName - 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 OracleConnectionarrayTypeName - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionjava.sql.SQLException - if a database error occurspublic TIMESTAMPLTZ createTIMESTAMPLTZ(java.sql.Date value, java.util.Calendar cal) throws java.sql.SQLException
createTIMESTAMPLTZ in interface OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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 OracleConnectionvalue - 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.Connectionjava.sql.SQLExceptionpublic java.sql.Blob createBlob()
throws java.sql.SQLException
createBlob in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Clob createClob()
throws java.sql.SQLException
createClob in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.NClob createNClob()
throws java.sql.SQLException
createNClob in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.SQLXML createSQLXML()
throws java.sql.SQLException
createSQLXML in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.sql.Struct createStruct(java.lang.String typeName,
java.lang.Object[] attributes)
throws java.sql.SQLException
createStruct in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean isValid(int timeout)
throws java.sql.SQLException
isValid in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setClientInfo(java.lang.String name,
java.lang.String value)
throws java.sql.SQLClientInfoException
setClientInfo in interface java.sql.Connectionjava.sql.SQLClientInfoExceptionpublic void setClientInfo(java.util.Properties properties)
throws java.sql.SQLClientInfoException
setClientInfo in interface java.sql.Connectionjava.sql.SQLClientInfoExceptionpublic java.lang.String getClientInfo(java.lang.String name)
throws java.sql.SQLException
getClientInfo in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.util.Properties getClientInfo()
throws java.sql.SQLException
getClientInfo in interface java.sql.Connectionjava.sql.SQLExceptionpublic boolean isWrapperFor(java.lang.Class<?> iface)
throws java.sql.SQLException
isWrapperFor in interface java.sql.Wrapperiface - 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.SQLExceptionpublic <T> T unwrap(java.lang.Class<T> iface)
throws java.sql.SQLException
unwrap in interface java.sql.Wrapperiface - 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.Connectionjava.sql.SQLExceptionpublic int getNetworkTimeout()
throws java.sql.SQLException
getNetworkTimeout in interface java.sql.Connectionjava.sql.SQLExceptionpublic java.lang.String getSchema()
throws java.sql.SQLException
getSchema in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setNetworkTimeout(java.util.concurrent.Executor executor,
int milliseconds)
throws java.sql.SQLException
setNetworkTimeout in interface java.sql.Connectionjava.sql.SQLExceptionpublic void setSchema(java.lang.String schema)
throws java.sql.SQLException
setSchema in interface java.sql.Connectionjava.sql.SQLExceptionpublic DatabaseChangeRegistration registerDatabaseChangeNotification(java.util.Properties options) throws java.sql.SQLException
OracleConnectionThis 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 OracleConnectionoptions - 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.SQLExceptionpublic DatabaseChangeRegistration getDatabaseChangeRegistration(int regid) throws java.sql.SQLException
OracleConnectionThis 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 OracleConnectionregid - The id of the registrationjava.sql.SQLExceptionpublic void unregisterDatabaseChangeNotification(DatabaseChangeRegistration registration) throws java.sql.SQLException
OracleConnectionThis method interrupts the notification thread and removes all listeners attached to this registration before closing it.
unregisterDatabaseChangeNotification in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.unregisterDatabaseChangeNotification(long,String)public void unregisterDatabaseChangeNotification(int registrationId,
java.lang.String host,
int tcpport)
throws java.sql.SQLException
OracleConnectionThis 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 OracleConnectionjava.sql.SQLExceptionOracleConnection.unregisterDatabaseChangeNotification(long,String)public void unregisterDatabaseChangeNotification(int registrationId)
throws java.sql.SQLException
OracleConnectionunregisterDatabaseChangeNotification in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.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 OracleConnectionjava.sql.SQLExceptionOracleConnection.unregisterDatabaseChangeNotification(oracle.jdbc.dcn.DatabaseChangeRegistration)public AQNotificationRegistration[] registerAQNotification(java.lang.String[] name, java.util.Properties[] options, java.util.Properties globaloptions) throws java.sql.SQLException
OracleConnectionThis 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 OracleConnectionname - 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.SQLExceptionpublic void unregisterAQNotification(AQNotificationRegistration registration) throws java.sql.SQLException
OracleConnectionunregisterAQNotification in interface OracleConnectionjava.sql.SQLExceptionpublic AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo) throws java.sql.SQLException
OracleConnectiondequeue in interface OracleConnectionqueueName - name of the queue from which to dequeue.opt - dequeue optionstdo - the Type Descriptor Object OID of the type of the queue.java.sql.SQLExceptionpublic AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo, int version) throws java.sql.SQLException
OracleConnectiondequeue in interface OracleConnectionqueueName - 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.SQLExceptionpublic AQMessage dequeue(java.lang.String queueName, AQDequeueOptions opt, java.lang.String typeName) throws java.sql.SQLException
OracleConnectiondequeue in interface OracleConnectionqueueName - 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.SQLExceptionpublic AQMessage[] dequeue(java.lang.String queueName, AQDequeueOptions opt, java.lang.String typeName, int deqsize) throws java.sql.SQLException
OracleConnectiondequeue in interface OracleConnectionqueueName - 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.SQLExceptionpublic AQMessage[] dequeue(java.lang.String queueName, AQDequeueOptions opt, byte[] tdo, int version, int deqsize) throws java.sql.SQLException
OracleConnectiondequeue in interface OracleConnectionqueueName - 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.SQLExceptionpublic void enqueue(java.lang.String queueName,
AQEnqueueOptions opt,
AQMessage mesg)
throws java.sql.SQLException
OracleConnectionenqueue in interface OracleConnectionqueueName - name of the queue where to enqueue.opt - enqueue options.mesg - the AQ message to enqueue.java.sql.SQLExceptionpublic int enqueue(java.lang.String queueName,
AQEnqueueOptions opt,
AQMessage[] mesgs)
throws java.sql.SQLException
OracleConnectionenqueue in interface OracleConnectionqueueName - name of the queue where to enqueue.opt - enqueue options.mesgs - the array of AQ messages to enqueue.java.sql.SQLExceptionpublic void commit(java.util.EnumSet<OracleConnection.CommitOption> flags) throws java.sql.SQLException
OracleConnectioncommit in interface OracleConnectionflags - commit optionsjava.sql.SQLExceptionpublic void cancel()
throws java.sql.SQLException
OracleConnectionFor 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 OracleConnectionjava.sql.SQLException - if the cancel operation failspublic void abort()
throws java.sql.SQLException
OracleConnectionabort in interface OracleConnectionjava.sql.SQLException - -- Io Exception: Socket closed - ORA-17002
TNS:not connected - ORA-12153public TypeDescriptor[] getAllTypeDescriptorsInCurrentSchema() throws java.sql.SQLException
OracleConnectiongetAllTypeDescriptorsInCurrentSchema in interface OracleConnectionjava.sql.SQLException - If an error occurs.public TypeDescriptor[] getTypeDescriptorsFromListInCurrentSchema(java.lang.String[] typeNames) throws java.sql.SQLException
OracleConnectiongetTypeDescriptorsFromListInCurrentSchema in interface OracleConnectiontypeNames - 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
OracleConnectiongetTypeDescriptorsFromList in interface OracleConnectionschemaAndTypeNamePairs - 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
OracleConnectiongetDataIntegrityAlgorithmName in interface OracleConnectionjava.sql.SQLExceptionpublic java.lang.String getEncryptionAlgorithmName()
throws java.sql.SQLException
OracleConnectiongetEncryptionAlgorithmName in interface OracleConnectionjava.sql.SQLExceptionpublic SecurityInformation getSecurityInformation() throws java.sql.SQLException
OracleConnectionThin driver.
Throws UnsupportedOperationException if this feature is not supported by
the underlying driver implementation.getSecurityInformation in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_WALLET_LOCATION,
OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL,
OracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVELpublic java.lang.String getAuthenticationAdaptorName()
throws java.sql.SQLException
OracleConnectiongetAuthenticationAdaptorName in interface OracleConnectionjava.sql.SQLExceptionpublic boolean isUsable()
OracleConnectionisUsable in interface OracleConnectionprotected oracle.jdbc.internal.OracleConnection getConnectionDuringExceptionHandling()
public void setDefaultTimeZone(java.util.TimeZone tz)
throws java.sql.SQLException
setDefaultTimeZone in interface OracleConnectiontz - 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 OracleConnectionjava.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
OracleConnectionsetApplicationContext in interface OracleConnectionnameSpace - 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
OracleConnectionclearAllApplicationContext in interface OracleConnectionnameSpace - The namespace which will be clearedjava.sql.SQLExceptionOracleConnection.setApplicationContext(java.lang.String, java.lang.String, java.lang.String),
Connection.setClientInfo(java.util.Properties)public void addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener) throws java.sql.SQLException
OracleConnectionLogicalTransactionIdEventListener
interface. A listener instance must then be registered using this method.addLogicalTransactionIdEventListener in interface OracleConnectionjava.sql.SQLExceptionpublic void addLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener, java.util.concurrent.Executor executor) throws java.sql.SQLException
OracleConnectionaddLogicalTransactionIdEventListener 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 OracleConnectionjava.sql.SQLExceptionpublic void removeLogicalTransactionIdEventListener(LogicalTransactionIdEventListener listener) throws java.sql.SQLException
OracleConnectionremoveLogicalTransactionIdEventListener in interface OracleConnectionjava.sql.SQLExceptionpublic LogicalTransactionId getLogicalTransactionId() throws java.sql.SQLException
OracleConnectiongetLogicalTransactionId in interface OracleConnectionjava.sql.SQLExceptionpublic java.util.Set<java.lang.String> getProviderAllowedProperties()
OracleConnectiongetProviderAllowedProperties in interface OracleConnectionpublic boolean needToPurgeStatementCache()
throws java.sql.SQLException
needToPurgeStatementCache in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.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 OracleConnectionjava.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 OracleConnectiontag - 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 OracleConnectionjava.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 OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAGpublic java.lang.String getDRCPReturnTag()
throws java.sql.SQLException
getDRCPReturnTag in interface OracleConnectionjava.sql.SQLExceptiondetachServerConnection(java.lang.String),
OracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAGpublic java.lang.String getDRCPPLSQLCallbackName()
throws java.sql.SQLException
NullgetDRCPPLSQLCallbackName in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_DRCP_PLSQL_CALLBACK,
OracleConnection.CONNECTION_PROPERTY_USE_DRCP_MULTIPLE_TAGpublic void beginRequest()
throws java.sql.SQLException
OracleConnectionbeginRequest in interface OracleConnectionjava.sql.SQLException - When called with an open transaction
on this connection.public void endRequest()
throws java.sql.SQLException
OracleConnectionendRequest in interface OracleConnectionjava.sql.SQLException - When called with an open transaction on this
connection.public void setShardingKey(OracleShardingKey key, OracleShardingKey superKey) throws java.sql.SQLException
OracleConnectionsetShardingKey in interface OracleConnectionkey - 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
OracleConnectionsetShardingKeyIfValid in interface OracleConnectionkey - 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
OracleConnectionsetShardingKeyIfValid in interface OracleConnectionshardingKey - 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
OracleConnectionsetShardingKey in interface OracleConnectionshardingKey - 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
OracleConnectiongetDRCPState in interface OracleConnectionOracleConnection.DRCPState.DETACHED if the connection is detached. OracleConnection.DRCPState.ATTACHED_IMPLICIT or OracleConnection.DRCPState.ATTACHED_EXPLICIT if the connection is attached.java.sql.SQLExceptionOracleConnection.attachServerConnection(),
OracleConnection.detachServerConnection(java.lang.String),
OracleConnection.isDRCPEnabled()public java.util.Properties getServerSessionInfo()
throws java.sql.SQLException
OracleConnectionoracle.jdbc.driver.T4CTTIoauthenticate,
many of the values are received from that TTC call.getServerSessionInfo in interface OracleConnectionProperties objectjava.sql.SQLExceptionpublic java.lang.String getServerSessionInfo(java.lang.String key)
throws java.sql.SQLException
OracleConnectionkey 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 OracleConnectionkey - Key to look upkey, or null if there is
no association.java.sql.SQLExceptionpublic boolean isValid(OracleConnection.ConnectionValidation effort, int timeout) throws java.sql.SQLException
OracleConnectioneffort 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 OracleConnectioneffort - 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.ConnectionValidationpublic java.lang.String getEncryptionProviderName()
throws java.sql.SQLException
OracleConnectionnull.getEncryptionProviderName in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVELpublic java.lang.String getChecksumProviderName()
throws java.sql.SQLException
OracleConnectionnull.getChecksumProviderName in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_THIN_NET_CHECKSUM_LEVELpublic java.lang.String getNetConnectionId()
throws java.sql.SQLException
OracleConnectiongetNetConnectionId in interface OracleConnectionjava.sql.SQLExceptionOracleConnection.CONNECTION_PROPERTY_THIN_NET_CONNECTIONID_PREFIXpublic void disableLogging()
throws java.sql.SQLException
OracleConnectiondisableLogging in interface OracleConnectionjava.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
OracleConnectionenableLogging in interface OracleConnectionjava.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
OracleConnectiondumpLog in interface OracleConnectionjava.sql.SQLException - if an error occurs while dumping the trace data.public byte[] startTransaction()
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to start, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
startTransaction in interface OracleConnectionjava.sql.SQLException - if auto-commit is set to true.public byte[] startTransaction(int timeout)
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to start, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
startTransaction in interface OracleConnectiontimeout - in seconds (non-negative). This controls how long the
transaction will stay alive after it has been suspended. If the transaction
is not resumed within the timeout it will be rolled-back, 0 indicates that
the transaction will be rolled-back immediately after the connection
is closed if it has not been resumed beforehand.java.sql.SQLException - if autcommit is set to true or negative timeout is
provided.public void startTransaction(byte[] GTRID)
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to start, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
startTransaction in interface OracleConnectionGTRID - (not-null) identifies the sessionless transaction to be
started.java.sql.SQLException - if autocommit is set to true, invalid GTRID is
provided or feature is not supported.public void startTransaction(byte[] GTRID,
int timeout)
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to start, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
startTransaction in interface OracleConnectionGTRID - (not-null) identifies the sessionless transaction to be
started.timeout - in seconds (non-negative). This controls how long the
transaction will stay alive after it has been suspended. If the transaction
is not resumed within the timeout it will be rolled-back, 0 indicates that
the transaction will be rolled-back immediately after the connection
is closed if it has not been resumed beforehand.java.sql.SQLException - if autocommit is set to true, invalid parameters are
provided or feature is not supported.public void suspendTransactionImmediately()
throws java.sql.SQLException
OracleConnectionUnlike OracleConnection.suspendTransaction() this operation is sent immediately
to the server.
After suspending the transaction, it will be rolled-back by the server if it is not resumed within the timeout value set during the start or resume calls. By default, this timeout is 60 seconds.
suspendTransactionImmediately in interface OracleConnectionjava.sql.SQLException - if transaction fails to suspend.public void suspendTransaction()
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to suspend, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
After suspending the transaction, it will be rolled-back by the server if it is not resumed within the timeout value set during the start or resume calls. By default, this timeout is 60 seconds.
suspendTransaction in interface OracleConnectionjava.sql.SQLException - if feature is not supported.public void resumeTransaction(byte[] GTRID)
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to resume, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
resumeTransaction in interface OracleConnectionGTRID - (not-null) identifies an existing sessionless transaction to
be resumed.java.sql.SQLException - if autocommit is set to true, invalid GTRID is
provided or feature is not supported.public void resumeTransaction(byte[] GTRID,
int timeout)
throws java.sql.SQLException
OracleConnectionThis call is not sent to the server immediately, instead it is queued
to be transmitted with the next call from the same connection that
initiates a round-trip to the server, for example PreparedStatement.execute() or OracleConnection.pingDatabase().
This implies that the local state of the transaction is not necessarily in
sync with the server. This also implies that in case the transaction
fails to resume, the exception may not be thrown by this method, rather
it will be thrown by the call that initiates the round-trip. Such
exception can be identified by the error code 18745, with its cause
indicating the original error from this call.
resumeTransaction in interface OracleConnectionGTRID - (not-null) identifies an existing sessionless transaction to
be resumed.timeout - in seconds (non-negative). This controls how long the
transaction will stay alive after it has been suspended. If the transaction
is not resumed within the timeout it will be rolled-back, 0 indicates that
the transaction will be rolled-back immediately after the connection
is closed if it has not been resumed beforehand.java.sql.SQLException - if autocommit is set to true, invalid parameters are
provided or feature is not supported.public byte[] getTransactionId()
throws java.sql.SQLException
getTransactionId in interface OracleConnectionjava.sql.SQLException - if feature is not supported.public boolean isXAThroughSessionlessTransactions()
isXAThroughSessionlessTransactions in interface OracleConnection