How to connect Java Application with Oracle Database using JDBC Driver - Part 1

Today I will go through the basic steps to connect a Java Application with Oracle Database using JDBC Driver (Java Database Connectivity). To develop Enterprise Product connectivity of java application and oracle database is essential. When I was new to java, i have faced some problem for java and database connectivity using jdbc. So I want to make all this process bit easier for all the new comer in java and windows platform.

Your Ad Here

Prerequisites :

Microsoft Windows Xp Service Pack 2 or above.

Java Developement Kit.

Oracle Database.

Oracle JDBC Driver.According to your database version.

One Integrated Development Environment.like Netbeans,Eclipse

Steps for configuring the system and creating DSN (ODBC Data Source):

Install Java Development Kit and Oracle Database.

Place Oracle JDBC Driver (*.jar file) in java runtime folder and java development kit folder . eg: 'C:\Program Files\Java\jre1.6.0\lib\ext' and 'C:\Program Files\Java\jdk1.6.0\jre\lib\ext'.

Create a Data Source Name (DSN) required for database connectivity in windows.

For DSN go to Start->Control Panel->Administrative Tools->Data Sources (ODBC).

ODBC Data Source Administrator will open. Click on the Add button to create a new data source.

Select 'Microsoft ODBC for Oracle' & click Next.

Fill the Data Source Name - name for the data source, Description - Just a simple description, User Name - Oracle Database User name, Server - name of the server where database is installed ,( localhost - if it is installed in the local machine or the IP if the the database is installed in a remote machine). Click OK and close the ODBC Data Source Administrator.

Now, the system is configured to run any java oracle connectivity program.You can start coding the program in any IDE or open a notpad.

Below is the source code of a jdbc program to determine wheather all your setting are OK or not. Compile the program and execute it. If the program is executed without any error or exception and you get 'JDBC Driver loaded' and 'Connected to the Oracle Database' as output then you have done all the setting correctly and you are able to connect to the oracle database through your java program.

If you encounter any problem please get back to me, I will help you to sought out the problem.

Source code :

import java.sql.*;

public class ConnectOracle {

 public static void main(String[] args) {

 

  String driver="sun.jdbc.odbc.JdbcOdbcDriver"; //

  String cs="jdbc:odbc:connectOracle"; //connectOracle is the data source name

  String user = "system"; //username of oracle database

  String pwd = "tom"; //password of oracle database

  Connection con = null; //connection variable assigned to null

 

  try

  {

   Class.forName(driver);// for loading the jdbc driver

  }

  catch(Exception e)

  {

   System.out.println(e);

  }

 

  System.out.println("JDBC Driver loaded");

 

  try

  {

   con=DriverManager.getConnection(cs,user,pwd);// for establishing connection with database

  }

  catch(Exception e)

  {

   System.out.println(e);

  }

 

  System.out.println("Connected to the Oracle Database");

 

  try

  {

   con.close();

  }

  catch(Exception e)

  {

   System.out.println(e);

  }

 

  }//end of main()

 }//end of class()