Recent Posts

Monday, 12 November 2018

Working With Type-5 Driver

☀ This 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. ➔ 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 :
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 { 
      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( {

Summary of All JDBC 5 Drivers

Next Tutorial : JDBC - Create a Table Example

Previous Tutorial : Working With Type-4 Driver 

No comments:

Post a Comment