85 Advanced Java Tutorial | Type 5 JDBC Driver | Java Database Connectivity | adv java

Показать описание

#Advanced java JDBC Tutorial | adv java:Java Database Connectivity | How to work with JDBC Type 5 Driver : Step To Develop Java Application Using Type 5 JDBC Driver:
Step 1:

Register your details, and u will get the email attachment, regarding the downloads

Download the Windows or Java installer from the location provided by Progress DataDirect:

• Windows: PROGRESS_DATADIRECT_CONNECT_JDBC_5.1.4_WIN.zip

Step 2:

Once you have downloaded you will get PROGRESS_DATADIRECT_CONNECT_JDBC_5.1.1_WIN.jar

Step 3:

Extract that jar and you will get a setup file. Click on this setup file then the Driver will be install in your machine.

Step 4:

C:\Program Files\Progress\DataDirect\Connect_for_JDBC_51\lib

Step 5:

By doing this we have set the environment for using Type 5 JDBC driver.

Step 6) Create Java JDBC Application using JDBC Type 5 driver

public class Type5Test
{
public static void main(String[] args) throws Exception
{

// Register the driver with the driver manager.
// If using Java SE 6, you can omit this step.
// Java SE 6 automatically registers the driver.
//I am Using JDK 8 so Commented below statement/line

// Establish the Connection
String url="jdbc:datadirect:oracle://localhost:1521;ServiceName=orcl";
//send & execute the query
{
}

}
}