Working With Type 5 Driver
In this tutorial, we are going to discuss about 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
That’s all about the Working With Type 5 Driver in JDBC. If you have any queries or feedback, please write us email at contact@waytoeasylearn.com. Enjoy learning, Enjoy Java.!!
Working With Type 5 Driver