Java JDBC – How to connect to Oracle using tnsnames.ora

by

I wasn’t even aware that using tnsnames with the thin driver is possible, but apparently it was added somewhere in version 10:

http://docs.oracle.com/cd/B19306_01/java.102/b14355/urls.htm#BEIDIJCE

In particular:

Note:

When using TNSNames with the JDBC Thin driver, you must set the oracle.net.tns_admin property to the directory that contains your tnsnames.ora file.

java -Doracle.net.tns_admin=%ORACLE_HOME%\network\admin

As mentioned, I haven’t checked if this actually works.

I don’t think that the “find the actual network config directory” logic is available via some Oracle function. You’ll have to do it manually as outlined in your question, or maybe rely on the TNS_ADMIN environment variable being present. In that case, the java invocation would be

java -Doracle.net.tns_admin=%TNS_ADMIN%

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. How to connect to Oracle using Service Name instead of SID
  6. Where’s my invalid character (ORA-00911)
  7. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  8. How to call oracle stored procedure which include user-defined type in java?
  9. java.sql.SQLException: Exhausted Resultset
  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. Call an Oracle function from Java
  20. Cannot use a LIKE query in a JDBC PreparedStatement?
  21. ojdbc14.jar vs. ojdbc6.jar
  22. Connection timeout for DriverManager getConnection
  23. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  24. Connection cannot be cast to oracle.jdbc.OracleConnection
  25. Oracle JDBC : invalid username/password (ora-01017)
  26. PreparedStatement and setTimestamp in oracle jdbc
  27. The Network Adapter could not establish the connection when connecting with Oracle DB
  28. Iterating a ResultSet using the JDBC for Oracle takes a lot of time about 16s?
  29. MyBatis Batch Insert/Update For Oracle
  30. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver

Leave a Comment