Connecting to Oracle Database Using Service Name.
While creating a connection to Database we give SID as Database Name.
While creating a connection to Database we give SID as Database Name.
To give Service name instead of SID.
- Give a back slash before the Service name Eg: /Service name
If you are using JNDI connection give URL as shown below.
Service URL is:
jdbc:oracle:thin:@Host name:port/service name
jdbc:oracle:thin:@Host name:port/service name
