ETL: Simplified configuration for JDBC drivers

Details

Detail name Value
Changelog Number 14924
Type Improvement
Status Resolved
Fix Versions Exasol 8.0.3
Resolution Date 2022-06-10

Background

When uploading a new driver, you previously needed to specify the main class of the driver and all jar files within the ‘settings.cfg’ file.

Improvement

The main class and all jar files no longer need to be specified in the driver configuration. Instead the ‘settings.cfg’ must only contain the following lines:

  • DRIVERNAME
  • PREFIX
  • FETCHSIZE
  • INSERTSIZE

An example for the Exasol JDBC driver looks like:

DRIVERNAME=EXA
PREFIX=jdbc:exa: 
FETCHSIZE=100000 
INSERTSIZE=-1

Changed behavior

When adding a new JDBC driver for use with IMPORT/EXPORT INTO/FROM JDBC, the 'settings.cfg' file for the driver does not require the 'DRIVERMAIN' or 'JAR' lines anymore.