The last time you used JDBC to connect to an Oracle database, you reported a SID-related error. Unable to connect to SID. The workaround is to use the format of the following method to connect
Format one::
Jdbc:oracle:thin:@//Example:jdbc:oracle:thin:@//192.168.2.1:1521/xe
Note The format here, which is followed by//, which is the main difference from using SIDS.
This format is recommended by Oracle because the SID for each node is different for the cluster, but the service_name can contain all nodes.
Format two: Oracle JDBC Thin using an SID:
Jdbc:oracle:thin:@example:jdbc:oracle:thin:@192.168.2.1:1521:x01a
Note:
The support for SID is being phased out. Oracle recommends this users switch over to Usingservice names.
Format three: Oracle JDBC Thin using a tnsname:
Jdbc:oracle:thin:@<tnsname>
Example:jdbc:oracle:thin: @GL
Note:
Support for TNSNames is added in the driver release 10.2.0.1
Troubleshooting Java Connection Oracle report SID errors