Working With Type-1 Driver
Type-1 Driver also known as JDBC ODBC Bridge Driver.
Type-1 Driver is available as the Part of JDK and hence we are not required to set any Class Path explicitly.
Driver Class Name : sun.jdbc.odbc.JdbcOdbcDriver JDBC URL : jdbc:odbc:demodsn username : scott password : tiger query : select * from emp;
Note
We should create emp table in the Database and insert some sample Data.
create table emp(eno number, ename varchar2(20), sal number(7,2),Address varchar2(50)); insert into emp values(1,'Ashok',50000,'Bhimavaram'); insert into emp values(2,'Vinod',120000,'Banglore'); insert into emp values(3,'Murty',75000,'Hyderabad');
import java.sql.*; /** * * @author ashok.mariyala * */ public class Type1DbConnectDemo { public static void main(String[] args) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:demodsn","scott","tiger"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getInt(3)+"\t"+rs.getString(4)); } con.close(); } }
Note
- Type-1 Driver is available until 1.7 Version only.
- From 1.8 Version on wards, the above Program won’t work.
Working With Type-1 Driver