SID 与 Oracle tnsnames.ora 中的服务名称有何不同

SID 与 Oracle tnsnames.ora 服务名称的不同

plaintext
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = ORCL)
    )
  )

plaintext
ORCL_SERVICE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class OracleConnectionExample {
    public static void main(String[] args) {
        String jdbcUrlSID = "jdbc:oracle:thin:@//example.com:1521/ORCL";
        String jdbcUrlServiceName = "jdbc:oracle:thin:@//example.com:1521/ORCL_SERVICE";
        String username = "your_username";
        String password = "your_password";
        try {
            // Connecting using SID
            Connection connectionSID = DriverManager.getConnection(jdbcUrlSID, username, password);
            System.out.println("Connected using SID");
            // Connecting using Service Name
            Connection connectionServiceName = DriverManager.getConnection(jdbcUrlServiceName, username, password);
            System.out.println("Connected using Service Name");
            // Perform database operations...
            // Close connections
            connectionSID.close();
            connectionServiceName.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}