The document does not provide any guidance on where to download the respective jdbc driver jar files nor the version which are supported.
For ex: "Example: Reading From and Writing to an Oracle Table" (https://gpdb.docs.pivotal.io/pxf/6-2/using/jdbc_pxf_oracle.html)
This section under the heading "Configure the Oracle Connector" point (1.a) Download the Oracle JDBC driver and place it under $PXF_BASE/lib...
No indication is given from where to download and which version to use. The given example mentions ojdbc10.jar, however in the oracle maven repository at https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc10/ lists several versions. This applies to the other database jdbc driver jar files as well.
If there is version mismatch we get the following errors in the pxf logs, java.lang.UnsupportedClassVersionError: oracle/jdbc/driver/OracleDriver has been compiled by a more recent version of the Java Runtime (class file version 54.0), this version of the Java Runtime only recognizes class file versions up to 52.0, the error nor the pxf document tells the user which version of jar file to use.
The document does not provide any guidance on where to download the respective jdbc driver jar files nor the version which are supported.
For ex: "Example: Reading From and Writing to an Oracle Table" (https://gpdb.docs.pivotal.io/pxf/6-2/using/jdbc_pxf_oracle.html) This section under the heading "Configure the Oracle Connector" point (1.a) Download the Oracle JDBC driver and place it under
$PXF_BASE/lib... No indication is given from where to download and which version to use. The given example mentionsojdbc10.jar, however in the oracle maven repository at https://repo1.maven.org/maven2/com/oracle/database/jdbc/ojdbc10/ lists several versions. This applies to the other database jdbc driver jar files as well.If there is version mismatch we get the following errors in the pxf logs,
java.lang.UnsupportedClassVersionError: oracle/jdbc/driver/OracleDriver has been compiled by a more recent version of the Java Runtime (class file version 54.0), this version of the Java Runtime only recognizes class file versions up to 52.0, the error nor the pxf document tells the user which version of jar file to use.