Recent Posts

Monday, 12 November 2018

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;

     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 { 
      Connection con=DriverManager.getConnection("jdbc:odbc:demodsn","scott","tiger"); 
      Statement st = con.createStatement();
      ResultSet rs = st.executeQuery("select * from emp");
      while( {
☀ Type-1 Driver is available until 1.7 Version only.
☀ From 1.8 Version onwards, the above Program won't work.

Next Tutorial : Working with Type-2 Driver

Previous Tutorial : Steps for developing JDBC Application

No comments:

Post a Comment