1. Database Driver Type in Console: Oracle’s Driver (Thin XA) for Application Continuity; Versions: Any
URL Input: Database is used as service name (the "Database" header is really a misnomer), host, port
Sample Generated URL: jdbc:oracle:thin:@//host:1521/service
Driver: oracle.jdbc.replay.OracleXADataSourceImpl (XA replay driver)
2. Database Driver Type in Console: Oracle’s Driver (Thin XA) for Instance connections; Versions: Any
URL Input: Database is used as SID, host, port. The use of SID is deprecated. You should stop using this format and instead use the service name.
Sample Generated URL: jdbc:oracle:thin:@host:1521:SID
Driver: oracle.jdbc.xa.client.OracleXADataSource
3. Database Driver Type in Console: Oracle’s Driver (Thin XA) for Service-Instance connections; Versions: Any
URL Input: Database is used as instance name (the header "Database" is really a misnomer), service name, host, port. This format is used when the service is available on multiple instances and the URL should map to a single instance for GENERIC and Multi Datasource. A long format URL is generated so that the instance name can be specified.
Sample Generated URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=service)(INSTANCE_NAME=instance)))
Driver: oracle.jdbc.xa.client.OracleXADataSource
4. Database Driver Type in Console: Oracle’s Driver (Thin XA) for Service connections; Versions: Any
URL Input: Database is used as service, host, port. Note that a slash precedes the service name (a colon precedes the SID).
Sample Generated URL: jdbc:oracle:thin:@host:1521/service
Driver: oracle.jdbc.xa.client.OracleXADataSource
5. Database Driver Type in Console: Oracle’s Driver (Thin) for Application Continuity; Versions: Any
URL Input: Database is used as service, host, port
Sample Generated URL: jdbc:oracle:thin:@//host:1521/service
Driver: oracle.jdbc.replay.OracleDataSourceImpl
6. Database Driver Type in Console: Oracle’s Driver (Thin) for Instance connections; Versions: Any
URL Input: Database is used as SID, host, port. The use of SID is deprecated. You should stop using this format and instead use the service name.
Sample Generated URL: jdbc:oracle:thin:@host:1521:SID
Driver: oracle.jdbc.OracleDriver
7. Database Driver Type in Console: Oracle’s Driver (Thin) for Service connections; Versions: Any
URL Input: Database is used as service, host, port. This is the default and most popular format for GENERIC datasources. The service should be available on a single instance for GENERIC and Multi Datasource.
Sample Generated URL: jdbc:oracle:thin:@host:1521/service
Driver: oracle.jdbc.OracleDriver
8. Database Driver Type in Console: Oracle’s Driver (Thin) for Service-Instance connections; Versions: Any
URL Input: Database is used as instance, service, host, port
Sample Generated URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=service)(INSTANCE_NAME=instance)))
Driver: oracle.jdbc.OracleDriver
9. Database Driver Type in Console: Oracle’s Driver (Thin) for pooled instance connections; Versions: Any
URL Input: Database is used as SID, host, port. This format is used to get a pooled datasource and is not commonly used.
Sample Generated URL: jdbc:oracle:thin:@host:1521:SID
Driver: oracle.jdbc.pool.OracleDataSource