Oracle Autonomous JDBC Thin Driver
DataSource
Transaction Type | DataSource Class |
NO_TRANSACTION, LOCAL_TRANSACTION | oracle.jdbc.pool.OracleDataSource |
XA_TRANSACTION | oracle.jdbc.xa.client.OracleXADataSource |
Driver Type Setting
Specify the driver-dependent parameters based on the JDBC driver and the transaction type that the connection is using in the Other Properties field:
Parameter | Description |
driverType | For example: driverType=thin |
Other Properties
Specify the following properties in the Other Properties field:
Parameter | Description |
retry_count | Number of times to retry after the initial attempt fails. For example: (retry_count=20) |
retry_delay | Time (milliseconds) to delay the retry. For example: (retry_delay=3) |
service_name | Name of the service to run. For example: (service_name=xxx.adb.oraclecloud.com) |
ssl_server_dn_match | Flag to indicate if the SSL Server DN is a match. Possible values are:  yesno. Default. For example: (ssl_server_dn_match=yes) |
TNS_ADMIN | Path to an autonomous wallet. An autonomous wallet is an encrypted folder that contains certificates and/or database credentials, such as username and password used to connect to the Oracle Database. The wallet is in the zip file format. You must unzip the wallet and add this path to TNS_ADMIN. For example: TNS_ADMIN="C:\\XXX\\Wallet_XXXX" Autonomous wallet prevents specifying usernames and passwords in a shell script or in an application database configuration file. |
For example:
url=jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)
(address=(protocol=tcps)(port=1522)(host=adb.aaa-xxx.oraclecloud.com))
(connect_data=(service_name=sss.adb.oraclecloud.com))
(security=(ssl_server_dn_match=yes)))?TNS_ADMIN="C:\\XXX\\Wallet_XXXX"
Required Connection Property Fields
Driver Name | Server Name | User | Password | Database Name | Port Number | Network Protocol |
Oracle Autonomous JDBC Thin Driver | Yes | Yes | Yes | Yes | Yes | Yes |
Retry Count | Retry Delay | Service Name | Database Name | SSL Server DNS Match | TNS ADMIN |
Yes | Yes | Yes | Yes | Yes | Yes |
For more information about limitations, see
Limitations.