Software >> Middleware >> Weblogic >> Configuration >> 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