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