Connecting to an Oracle DB using JDBC URL


There is a connection option, called JDBC_URL, available on widely used DB Management tools like TOAD, sqldeveloper, etc.

Most of the dbas prefer tns connections and they have less preference to connections using jdbc url.

Here, I will explain you, how to make a jdbc connection to oracle db using sqldeveloper.

Step 1: Click on the new connection.
Step 2: provide Connection name, username, password details.
Step 3: Select "advanced" on connection type.
Step 4: Copy the tns connection details from tnsnames.ora file (without connection name) and prepend "jdbc:oracle:thin:@" with the tns connection details.
Example:
jdbc:oracle:thin:@DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=host-name)(PORT=1521))
(CONNECT_DATA=
(SID=DEV)
)
)

Step 5: Paste this block on the space provided for "Custome JDBC URL".

Test the connection and voila !!!