Oracle JDBC driver types used in weblogic

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

Reference:

[1] https://blogs.oracle.com/weblogicserver/oracle-driver-types-in-the-weblogic-console