How to connect to Oracle using Service Name instead of SID

by

http://download.oracle.com/docs/cd/B28359_01/java.111/b31224/urls.htm#BEIDHCBA

Thin-style Service Name Syntax

Thin-style service names are supported only by the JDBC Thin driver. The syntax is:

@//host_name:port_number/service_name

For example:

jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename

So I would try:

jdbc:oracle:thin:@//oracle.hostserver2.mydomain.ca:1522/ABCD

Also, per Robert Greathouse’s answer, you can also specify the TNS name in the JDBC URL as below:

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL=TCP)(HOST=blah.example.com)(PORT=1521)))(CONNECT_DATA=(SID=BLAHSID)(GLOBAL_NAME=BLAHSID.WORLD)(SERVER=DEDICATED)))

More Related Contents:

  1. having an exception when saving oracle type object in some entity
  2. Is java.sql.Timestamp timezone specific?
  3. java.sql.SQLException: – ORA-01000: maximum open cursors exceeded
  4. Using setDate in PreparedStatement
  5. Where’s my invalid character (ORA-00911)
  6. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  7. How to call oracle stored procedure which include user-defined type in java?
  8. java.sql.SQLException: Exhausted Resultset
  9. Create a jTDS connection string
  10. How to enable logging for SQL statements when using JDBC
  11. Difference between Oracle jdbc driver classes?
  12. PLSQL JDBC: How to get last row ID?
  13. Oracle JDBC intermittent Connection Issue
  14. Getting output from dbms_output.get_lines using JDBC
  15. JDBC ResultSet get columns with table alias
  16. How to write / update Oracle blob in a reliable way?
  17. Setting Network Timeout for JDBC connection
  18. Getting an exception ORA-00942: table or view does not exist – when inserting into an existing table
  19. Java JDBC – How to connect to Oracle using tnsnames.ora
  20. Call an Oracle function from Java
  21. Cannot use a LIKE query in a JDBC PreparedStatement?
  22. ojdbc14.jar vs. ojdbc6.jar
  23. Connection timeout for DriverManager getConnection
  24. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  25. Connection cannot be cast to oracle.jdbc.OracleConnection
  26. Oracle JDBC : invalid username/password (ora-01017)
  27. PreparedStatement and setTimestamp in oracle jdbc
  28. The Network Adapter could not establish the connection when connecting with Oracle DB
  29. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?
  30. Database independence through JDBC in java

Leave a Comment