Tuesday, May 20, 2014

Using TNS names for Java Application

Here are the steps

  1. Add jvm commandline option '-Doracle.net.tns_admin'. Value of this property should point to the directory containing 'tnsnames.ora' file.  
  2. Change value of jdbc.url property to 'jdbc:oracle:thin:@MYDB' Here MYDB is one of the entries in tnsnames.ora file. That's it

No comments:

Post a Comment