Re: Put SQL to connect to Teradata

[Jeremy Dyer]

Anuj - I would recommend using the Maven shade plugin to create and Uber
jar containing both tdfssconfig.jar and terajdbc4.jar. I used this method a
couple of days ago successfully after I was encountering the same issue you
were having. I wish I could just share the Uber jar with you but due to
Teradata's license model I am unable to do that. Here is the Maven pom.xml
that I used to create the Uber jar however. You will need to change the
groupId, artifactId, and version to match what you actually have installed
in your local Maven repository.

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0";
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
http://maven.apache.org/xsd/maven-4.0.0.xsd";>
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.jeremydyer</groupId>
    <artifactId>teradata-uber</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>

        <dependency>
            <groupId>com.jeremydyer.teradata</groupId>
            <artifactId>tdgsconfig</artifactId>
            <version>1.0.0-SNAPSHOT</version>
        </dependency>
        <dependency>
            <groupId>com.jeremydyer.teradata</groupId>
            <artifactId>terajdbc4</artifactId>
            <version>1.0.0-SNAPSHOT</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-shade-plugin</artifactId>
                <version>2.4.3</version>
                <configuration>

<createDependencyReducedPom>true</createDependencyReducedPom>
                    <filters>
                        <filter>
                            <artifact>*:*</artifact>
                            <excludes>
                                <exclude>META-INF/*.SF</exclude>
                                <exclude>META-INF/*.DSA</exclude>
                                <exclude>META-INF/*.RSA</exclude>
                            </excludes>
                        </filter>
                    </filters>
                </configuration>
                <executions>
                    <execution>
                        <phase>package</phase>
                        <goals>
                            <goal>shade</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>


On Thu, May 19, 2016 at 9:05 PM, Anuj Handa <anujha...@gmail.com> wrote:

> Hi  folks,
>
> I am using putsql on nifi-0.6.1 to connect to teradata and getting the
> below error
>
> 2016-05-19 20:06:33,230 ERROR [Timer-Driven Process Thread-4]
> o.apache.nifi.processors.standard.PutSQL
> java.lang.NoClassDefFoundError: Could not initialize class
> com.teradata.tdgss.jtdgss.TdgssManager
>
> The Teradata JDBC driver comes with two files, tdgssconfig.jar and
> terajdbc4.jar and i have specified the terajdbc4.jar in the
> DBCPConnectionPool
>
> reading about the error it seems like there's a dependent
> (tdgssconfig.jar) JAR file which its not able to find. both files were
> copied in the nifi Lib directory but that didn't help
>
> Because of this dependent driver can we use this method to connect to
> Teradata ?
>
> Anuj
>