Page Comparison

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift (default JAR/manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default JAR)

Authenticates successfully.

Redshift (manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (manual upload)

Authenticates successfully using the manually uploaded JAR file.

PostgreSQL (default JAR/manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR)

Authenticates successfully.

PostgreSQL (manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR/manual upload)

Authenticates successfully using the manually uploaded JAR file.

Redshift (manual upload)

org.postgresql.Driver

jdbc:postgresql (default JAR/manual upload)

Authenticates successfully using the default PostgreSQL JAR file.

PostgreSQL (manual upload)

com.amazon.redshift.jdbc42.Driver

jdbc:redshift (default JAR/manual upload)

Authenticates successfully using the default Redshift JAR file.

JDBC Driver JAR

JDBC Driver Class

JDBC URL

Authentication

Redshift JAR

com.amazon.redshift.jdbc42.Driver

jdbc:postgresql

Authentication fails.

Redshift JAR

org.postgresql.Driver

jdbc:redshift

Authentication fails.

PostgreSQL JAR

com.amazon.redshift.jdbc42.Driver

jdbc:postgresql

Authentication fails.

PostgreSQL JAR

org.postgresql.Driver

jdbc:redshift

Authentication fails.