Working With Type-5 Driver

Working With Type-5 Driver
  • Type-5 Driver introduced by “Progress Data Direct” Software Company.
  • This Driver is the enhanced Version of Type-4 Driver.
  • This Driver is not Industry recognized Driver.
  • We have to Download Driver Software from Progress Data Direct Web Site as follows.
https://www.progress.com/jdbc βž” Available JDBC Data Sources βž” 
Relational and Analytics βž” Oracle Database βž” 
Download JDBC connectors βž” Windows βž” Fill Form and Download

We will get Setup File and execute so that Driver Software available in our System. Type-5 Driver Software available in oracle.jar which is available in the following Location.

C:\Program Files\Progress\DataDirect\Connect_for_JDBC_51\lib\oracle.jar

We have to Place this Jar File in the Class Path.

Driver Class Name : com.ddtek.jdbc.oracle.OracleDriver
JDBC URL : jdbc:datadirect:oracle://localhost:1521;ServiceName=XE
import java.sql.*;
/**
 * 
 * @author ashok.mariyala
 *
 */
public class Type5DbConnectDemo { 
   public static void main(String[] args) throws Exception { 
      Class.forName("com.ddtek.jdbc.oracle.OracleDriver"); 
      Connection con=DriverManager.getConnection("jdbc:datadirect:oracle://localhost:1521;ServiceName=XE","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();
   }
}
Summary of All JDBC 5 Drivers
Working With Type-5 Driver


Scroll to top