Tag Archives: SID

How to pass Service Name or SID in JDBC URL

Below is the way to send either Service Name or SID in JDBC URL to connect to Oracle SQL For Service Name @//host_name:port_number/service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename For SID @//host_name:port_number:service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521:myservicename Oracle DOC

Posted in Oracle, Oracle SQL | Tagged , , , , | Leave a comment