A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.

DataDirect JDBC Driver for Pivotal Greenplum

DataDirect JDBC drivers are compliant with the Type 4 architecture, but provide advanced features that define them as Type 5 drivers. Additionally, the drivers consistently support the latest database features and are fully compliant with Java™ SE 8 and JDBC 4.0 functionality.

The DataDirect JDBC Driver for Pivotal Greenplum is available for download from Pivotal Network.

Prerequisites

The DataDirect JDBC Driver requires Java SE 5 or higher. See System and Product Requirements in the DataDirect documentation for information and requirements associated with specific features of the JDBC driver.
The license key is embedded in the greenplum.jar file itself. You do not need to apply a specific license key to the driver to activate it.

Downloading the DataDirect JDBC Driver

To install the JDBC driver on your client:

Log into Pivotal Network and download the DataDirect JDBC driver file: PROGRESS_DATADIRECT_JDBC_DRIVER_PIVOTAL_GREENPLUM_5.1.4.zip.
Extract the downloaded ZIP file.
Add the full path to the PROGRESS_DATADIRECT_JDBC_DRIVER_PIVOTAL_GREENPLUM_5.1.4.jar to your Java CLASSPATH environment variable, or add it to your classpath with the -classpath option when executing a Java application.

Obtaining Version Details for the Driver

To view the JDBC driver version information:

Change to the directory that contains the downloaded PROGRESS_DATADIRECT_JDBC_DRIVER_PIVOTAL_GREENPLUM_5.1.4.jar driver file. For example:
```
$ cd /opt/Progress/DataDirect/Connect_for_JDBC_51/lib
```

Execute the data source class to display the version information.

For Linux/Unix systems:

$ java -classpath PROGRESS_DATADIRECT_JDBC_DRIVER_PIVOTAL_GREENPLUM_5.1.4.jar com.pivotal.jdbc.GreenplumDriver
[Pivotal][Greenplum JDBC Driver]Driver Version: 5.1.4.000223 (F000432.U000208)

For Windows systems:

java -classpath .;.\greenplum.jar com.pivotal.jdbc.GreenplumDriver
[Pivotal][Greenplum JDBC Driver]Driver Version: 5.1.4.000223 (F000432.U000208)

Usage Information

The JDBC driver is provided in the greenplum.jar file. Use the following data source class and connection URL information with the driver.

Property	Description
Driver File Name	greenplum.jar
Data Source Class	com.pivotal.jdbc.GreenplumDriver
Connection URL	jdbc:pivotal:greenplum://host:port;DatabaseName=<name>
Driver Defaults	ResultSetMetadataOptions=1 FetchTWFSasTime=true SupportsCatalogs=true MaxLongVarcharSize=8190 MaxNumericPrecision=28 MaxNumericScale=6

DataDirect Driver Documentation

For more information on working with the Data Direct JDBC driver, see documentation available online at https://www.progress.com/documentation/datadirect-connectors. Titles include: