Link a driver file with a resource created with CREATE DRIVER.

Syntax


ADD RESOURCE TO DRIVER driverName AT 'resourcePath';

Arguments

  • driverName is the driver name specified in the driver creation step.

  • resourcePath is the local or network path to the driver files which should be added to /usr/share/thirdparty prior to issuing ADD RESOURCE.

Examples

LDAP registration for Active Directory


CREATE DRIVER JTDS_DVR OF TYPE SQLSERVER WITH CLASSNAME 'net.sourceforge.jtds.jdbc.Driver';

ADD RESOURCE TO DRIVER JTDS_DVR AT '/usr/share/thirdparty/jtds-1.3.1.jar';

Greenplum

ADD RESOURCE TO DRIVER greenplumdriver AT '/tmp/jdbc/42.1.4_jdbc_42.jar';

MySQL

ADD RESOURCE TO DRIVER mysql1 AT '/tmp/jdbc/mysql-connector-java-5.1.44.tar';

Netezza

ADD RESOURCE TO DRIVER puredatadriver AT '/tmp/jdbc/nzjdbc3.jar';

Oracle

ADD RESOURCE TO DRIVER oracledriver AT '/tmp/jdbc/ojdbcX.jar';

Postgres

ADD RESOURCE TO DRIVER postgresdriver AT '/tmp/jdbc/42.1.4_jdbc_42.jar';

Redshift

ADD RESOURCE TO DRIVER redshiftdriver AT '/tmp/jdbc/RedshiftJDBC42-1.2.10.1009.jar';

SQL Server

ADD RESOURCE TO DRIVER sqlserverdriver AT '/tmp/jdbc/sqljdbc41.jar';

SybaseIQ

ADD RESOURCE TO DRIVER sybaseiqdriver AT '/tmp/jdbc/jtds-1.3.1.jar';

Teradata

ADD RESOURCE TO DRIVER teradatadriver AT '/tmp/jdbc/terajdbc4.jar';
ADD RESOURCE TO DRIVER teradatadriver AT '/tmp/jdbc/tdgssconfig.jar';

Vertica

ADD RESOURCE TO DRIVER verticadriver AT '/tmp/jdbc/vertica-jdbc-9.0.0-0.jar';

See Also