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
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?