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
Capture 24
Working With Type-5 Driver
Scroll to top