Dear Friends,
I want to write a
java code that connects with Oracle database using host,pid,address information from tnsnames.ora file using
jdbc thin driver. I dont want to hard code any of these values accept SID.
As per my findings,JDBC thin driver doesnt reads these values from tnsnames.ora file.The usual
Class.forName("oracle.jdbc.driver.OracleDriver");
String url = "jdbc:oracle:thin:@host:port:SID";
Connection conn = DriverManager.getConnection(url, userName, pwd);
doesnt work for me since I have to get host,port values at runtime.
Also as per my understanding OCI driver should be used if tnsnames.ora file needs to be referred by program. I dont want to use OCI since it needs extra installation stuff. I want to make connection with JDBC thin driver only.
So I thought of using OracleDatasource contained in package : oracle.jdbc.pool
I want to know is OracleDatasource is the best way to make connection with Oracle database when tnsnames.ora file needs to be used in my case?
Please reply ASAP as its very urgent for me