WORKING WITH TYPE - 1

JDBC-ODBC Bridge

Oracle Driver ----> oracle.jdbc.driver---->ojdbc6.jar

Name of Type - 1 driver class

sun.jdbc.odbc.jdbcodbcDriver---> rt.jar

URL of Type - 1

jdbc:odbc:dsn
jdbc:odbc ----> protocol used by driver manager to select driver.

DSN - Data Source Name. DSN contains - ODBC driver, database.

Steps to create DSN

Open Microsoft Access
Select Blank database and give name to it.
Create your column into your table and save it with appropriate name.
Open Control Panel.
Open Admin Tools.
Open ODBC Data Source.
Click on ADD -> creating new data source.
Select driver -> Microsoft Access driver (*.mdb,*,accdb)
Data Source Name -> Cmpdsn
Click on select database -> select database by default its in Documents folder


PROGRAM TO INSERT ROW USING TYPE -1 DRIVER

import java.sql.*;
class JdbcOdbcTest1{
public static void main(String[] args) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:Cmpdsn","","");
PreparedStatement ps = con.prepareStatement("insert into Cmp values(?,?)");
ps.setInt(1,1);
ps.setString(2,"rakesh");
int count = ps.executeUpdate();
System.out.println(count);
con.close();
}
}

Note - In JDK 8, jdbc odbc bridge is no longer used and thus removed from the JDK. to use Microsoft Access database in JAVA.