Oracle database connection in java driver#

To do that, you set the _admin property to the location of the folder containing your TNSNAMES.ORA file, accessible from your machine: tProperty( Before you can connect to Oracle using this approach, there is one more thing you have to do вЂ“ you have to tell JDBC where to look for the TNSNAMES.ORA file. If you have an Oracle Client or Oracle Database Server installed, you may find the TNSNAMES.ORA file in the following the net service name is an entry from our protagonist file. On the other hand, if you would hardcode the host address in your applications, you would potentially have to change it in many places, probably missing one or more. Those aliases are very useful вЂ“ consider a situation, when the machine on which a database server is hosted changes вЂ“ if you use an alias from TNSNAMES.ORA, you only have to change address of the database server there. Each of the addresses is described by a connect descriptor composed of host address, port and SID or service name.

Put simply, TNSNAMES.ORA is a configuration file holding net service names which are aliases for database network addresses. Let me just shortly explain what this fellaвЂ™ is all about! Meet TNSNAMES.ORA However, instead of specifying HOST, PORT and SID values, we could provide the net service name from the TNSNAMES.ORA file.

SID вЂ“ Oracle System Identifier вЂ“ identifies an instance of Oracle database.

PORT вЂ“ port on which the database server is listening for incoming connections,.

HOST вЂ“ address of the database server or the hostвЂ™s name,.

Oracle database connection in java driver#

Jdbc:oracle:thin вЂ“ defines that we want the JDBC Thin Driver to be used to establish the connection,