Q) Develop a JDBC application that connects to oracle database server by using database product wander provided JDBC driver.

A)

import java.sql.*;

classoracledatabaseConnection {

       public static void main(String[] args) {

              Class.forName("oracle.jdbc.driver.OracleDriver");

              System.out.println("driver loaded");

              Connection con=DriverManager.getConnection("jdbc:oracle:thin:@locahost:1521:server","scott","tiger");

              System.out.println("connected");

              con.close();

              System.out.println("connection closed");

       }

}

Note:

->For the successful execution of above of the application we need to place “classes12.jar” in the CLASSPATH.

->we also should verify “tnsnames.ora” file for PORTNUMBER and DATABASE SERVER NAME of the connection string.

Additional information:
set classpath= .; D:\classes12.jar

Java checks what type of exception are there and system, class, system classes are belong to long package so the long package is default package to any java program.

Ex:
set classpath = .; D:\oracle\ora90\jdbc\lib\classes12.jar