You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@nifi.apache.org by Anuj Handa <an...@gmail.com> on 2016/05/20 01:05:18 UTC
Put SQL to connect to Teradata
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
Re: Put SQL to connect to Teradata
Posted by Jeremy Dyer <jd...@gmail.com>.
Anuj - I apologize I missed your last email but I'm really glad to hear
that it is working now!
On Tue, May 24, 2016 at 2:00 PM, Anuj Handa <an...@gmail.com> wrote:
> Hi Jeremy,
> its working now, I restarted the nifi service ,moved the JAR file into the
> lib folder and unpacked the TDgsss.jar which had an xml file. so one of
> them worked :)
>
> Thanks. This was just testing connecting to Teradata now i have to work
> out loading millions of rows in seconds in Teradata ;)
>
> Anuj
>
> On Mon, May 23, 2016 at 7:21 PM, Anuj Handa <an...@gmail.com> wrote:
>
>> Hi Jeremy,
>>
>> I figured out that maven was looking for Jar files and not able to find
>> them so i had install the JAR files. there were few typos and names
>> incorrect which were causing problems. I was finally able to create the
>> Uber JAR but still getting class not found errors in NIFI.
>>
>> Here's the copy of the JAR file opened in winrar and both JDBC and TDGSS
>> are in it com/teradata.
>>
>>
>> [image: Inline image 1]
>>
>> [image: Inline image 2]
>> my updated POM File
>>
>> <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/maven-v4_0_0.xsd">
>> <modelVersion>4.0.0</modelVersion>
>> <groupId>com.anuj</groupId>
>> <artifactId>teradata-uber</artifactId>
>> <packaging>jar</packaging>
>> <version>1.0-SNAPSHOT</version>
>> <name>teradata-uber</name>
>> <url>http://maven.apache.org</url>
>>
>>
>> <dependencies>
>> <dependency>
>> <groupId>com.anuj.teradata</groupId>
>> <artifactId>tdgssconfig</artifactId>
>> <version>15.00.00.33</version>
>> </dependency>
>> <dependency>
>> <groupId>com.anuj.teradata</groupId>
>> <artifactId>terajdbc4</artifactId>
>> <version>15.00.00.33</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>
>>
>>
>> Anuj
>>
>> On Mon, May 23, 2016 at 8:29 AM, Jeremy Dyer <jd...@gmail.com> wrote:
>>
>>> Anuj - Your close. Maven relies on "repositories' to find 3rd party jars
>>> that are needed as part of an application. Since the Teradata jars do not
>>> exist in your local repository you will need to install them there. You can
>>> do that by running these 2 commands and then attempting the "mvn clean
>>> install package" again. Note you need to place the "path" with the actual
>>> location of the jar on your local machine.
>>>
>>> mvn install:install-file -Dfile=<path-to-file>
>>> -DgroupId=com.anuj.teradata -DartifactId=tdgsconfig
>>> -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
>>> mvn install:install-file -Dfile=<path-to-file>
>>> -DgroupId=com.anuj.teradata -DartifactId= terajdbc4 -Dversion=1.0.0-SNAPSHOT
>>> -Dpackaging=jar
>>>
>>>
>>> On Sat, May 21, 2016 at 11:03 PM, Anuj Handa <an...@gmail.com>
>>> wrote:
>>>
>>>> hi Jeremy,
>>>>
>>>> I have no idea on how to use maven but i gave it a try and i am getting
>>>> the error
>>>>
>>>> [ERROR] Failed to execute goal on project teradata-uber: Could not
>>>> resolve dependencies for project com.anuj:teradata-uber:jar:1.0-SNAPSHOT:
>>>> The following artifacts could not be resolved:
>>>> com.anuj.teradata:tdgsconfig:jar
>>>>
>>>> i am not sure what location the teradata jar files should be and i
>>>> tried multiple locations.
>>>> MVN command
>>>> c:\apache-maven-3.3.9\teradata-uber> mvn archetype:generate
>>>> -DgroupId=com.anuj -DartifactId=teradata-uber
>>>> -DarchetypeArtifactId=maven-archetype-quickstart
>>>> -DinteractiveMode=false
>>>>
>>>> my pom file
>>>> <?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.anuj</groupId>
>>>> <artifactId>teradata-uber</artifactId>
>>>> <version>1.0-SNAPSHOT</version>
>>>>
>>>> <dependencies>
>>>>
>>>> <dependency>
>>>> <groupId>com.anuj.teradata</groupId>
>>>> <artifactId>tdgsconfig</artifactId>
>>>> <version>1.0.0-SNAPSHOT</version>
>>>> </dependency>
>>>> <dependency>
>>>> <groupId>com.anuj.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 10:40 PM, Jeremy Dyer <jd...@gmail.com> wrote:
>>>>
>>>>> 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 <an...@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
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
Re: Put SQL to connect to Teradata
Posted by Anuj Handa <an...@gmail.com>.
Hi Jeremy,
its working now, I restarted the nifi service ,moved the JAR file into the
lib folder and unpacked the TDgsss.jar which had an xml file. so one of
them worked :)
Thanks. This was just testing connecting to Teradata now i have to work out
loading millions of rows in seconds in Teradata ;)
Anuj
On Mon, May 23, 2016 at 7:21 PM, Anuj Handa <an...@gmail.com> wrote:
> Hi Jeremy,
>
> I figured out that maven was looking for Jar files and not able to find
> them so i had install the JAR files. there were few typos and names
> incorrect which were causing problems. I was finally able to create the
> Uber JAR but still getting class not found errors in NIFI.
>
> Here's the copy of the JAR file opened in winrar and both JDBC and TDGSS
> are in it com/teradata.
>
>
> [image: Inline image 1]
>
> [image: Inline image 2]
> my updated POM File
>
> <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/maven-v4_0_0.xsd">
> <modelVersion>4.0.0</modelVersion>
> <groupId>com.anuj</groupId>
> <artifactId>teradata-uber</artifactId>
> <packaging>jar</packaging>
> <version>1.0-SNAPSHOT</version>
> <name>teradata-uber</name>
> <url>http://maven.apache.org</url>
>
>
> <dependencies>
> <dependency>
> <groupId>com.anuj.teradata</groupId>
> <artifactId>tdgssconfig</artifactId>
> <version>15.00.00.33</version>
> </dependency>
> <dependency>
> <groupId>com.anuj.teradata</groupId>
> <artifactId>terajdbc4</artifactId>
> <version>15.00.00.33</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>
>
>
> Anuj
>
> On Mon, May 23, 2016 at 8:29 AM, Jeremy Dyer <jd...@gmail.com> wrote:
>
>> Anuj - Your close. Maven relies on "repositories' to find 3rd party jars
>> that are needed as part of an application. Since the Teradata jars do not
>> exist in your local repository you will need to install them there. You can
>> do that by running these 2 commands and then attempting the "mvn clean
>> install package" again. Note you need to place the "path" with the actual
>> location of the jar on your local machine.
>>
>> mvn install:install-file -Dfile=<path-to-file>
>> -DgroupId=com.anuj.teradata -DartifactId=tdgsconfig
>> -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
>> mvn install:install-file -Dfile=<path-to-file>
>> -DgroupId=com.anuj.teradata -DartifactId= terajdbc4 -Dversion=1.0.0-SNAPSHOT
>> -Dpackaging=jar
>>
>>
>> On Sat, May 21, 2016 at 11:03 PM, Anuj Handa <an...@gmail.com> wrote:
>>
>>> hi Jeremy,
>>>
>>> I have no idea on how to use maven but i gave it a try and i am getting
>>> the error
>>>
>>> [ERROR] Failed to execute goal on project teradata-uber: Could not
>>> resolve dependencies for project com.anuj:teradata-uber:jar:1.0-SNAPSHOT:
>>> The following artifacts could not be resolved:
>>> com.anuj.teradata:tdgsconfig:jar
>>>
>>> i am not sure what location the teradata jar files should be and i tried
>>> multiple locations.
>>> MVN command
>>> c:\apache-maven-3.3.9\teradata-uber> mvn archetype:generate
>>> -DgroupId=com.anuj -DartifactId=teradata-uber
>>> -DarchetypeArtifactId=maven-archetype-quickstart
>>> -DinteractiveMode=false
>>>
>>> my pom file
>>> <?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.anuj</groupId>
>>> <artifactId>teradata-uber</artifactId>
>>> <version>1.0-SNAPSHOT</version>
>>>
>>> <dependencies>
>>>
>>> <dependency>
>>> <groupId>com.anuj.teradata</groupId>
>>> <artifactId>tdgsconfig</artifactId>
>>> <version>1.0.0-SNAPSHOT</version>
>>> </dependency>
>>> <dependency>
>>> <groupId>com.anuj.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 10:40 PM, Jeremy Dyer <jd...@gmail.com> wrote:
>>>
>>>> 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 <an...@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
>>>>>
>>>>
>>>>
>>>
>>
>
Re: Put SQL to connect to Teradata
Posted by Anuj Handa <an...@gmail.com>.
Hi Jeremy,
I figured out that maven was looking for Jar files and not able to find
them so i had install the JAR files. there were few typos and names
incorrect which were causing problems. I was finally able to create the
Uber JAR but still getting class not found errors in NIFI.
Here's the copy of the JAR file opened in winrar and both JDBC and TDGSS
are in it com/teradata.
[image: Inline image 1]
[image: Inline image 2]
my updated POM File
<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.anuj</groupId>
<artifactId>teradata-uber</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>teradata-uber</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>com.anuj.teradata</groupId>
<artifactId>tdgssconfig</artifactId>
<version>15.00.00.33</version>
</dependency>
<dependency>
<groupId>com.anuj.teradata</groupId>
<artifactId>terajdbc4</artifactId>
<version>15.00.00.33</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>
Anuj
On Mon, May 23, 2016 at 8:29 AM, Jeremy Dyer <jd...@gmail.com> wrote:
> Anuj - Your close. Maven relies on "repositories' to find 3rd party jars
> that are needed as part of an application. Since the Teradata jars do not
> exist in your local repository you will need to install them there. You can
> do that by running these 2 commands and then attempting the "mvn clean
> install package" again. Note you need to place the "path" with the actual
> location of the jar on your local machine.
>
> mvn install:install-file -Dfile=<path-to-file> -DgroupId=com.anuj.teradata
> -DartifactId=tdgsconfig -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
> mvn install:install-file -Dfile=<path-to-file> -DgroupId=com.anuj.teradata
> -DartifactId= terajdbc4 -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
>
>
> On Sat, May 21, 2016 at 11:03 PM, Anuj Handa <an...@gmail.com> wrote:
>
>> hi Jeremy,
>>
>> I have no idea on how to use maven but i gave it a try and i am getting
>> the error
>>
>> [ERROR] Failed to execute goal on project teradata-uber: Could not
>> resolve dependencies for project com.anuj:teradata-uber:jar:1.0-SNAPSHOT:
>> The following artifacts could not be resolved:
>> com.anuj.teradata:tdgsconfig:jar
>>
>> i am not sure what location the teradata jar files should be and i tried
>> multiple locations.
>> MVN command
>> c:\apache-maven-3.3.9\teradata-uber> mvn archetype:generate
>> -DgroupId=com.anuj -DartifactId=teradata-uber
>> -DarchetypeArtifactId=maven-archetype-quickstart
>> -DinteractiveMode=false
>>
>> my pom file
>> <?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.anuj</groupId>
>> <artifactId>teradata-uber</artifactId>
>> <version>1.0-SNAPSHOT</version>
>>
>> <dependencies>
>>
>> <dependency>
>> <groupId>com.anuj.teradata</groupId>
>> <artifactId>tdgsconfig</artifactId>
>> <version>1.0.0-SNAPSHOT</version>
>> </dependency>
>> <dependency>
>> <groupId>com.anuj.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 10:40 PM, Jeremy Dyer <jd...@gmail.com> wrote:
>>
>>> 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 <an...@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
>>>>
>>>
>>>
>>
>
Re: Put SQL to connect to Teradata
Posted by Jeremy Dyer <jd...@gmail.com>.
Anuj - Your close. Maven relies on "repositories' to find 3rd party jars
that are needed as part of an application. Since the Teradata jars do not
exist in your local repository you will need to install them there. You can
do that by running these 2 commands and then attempting the "mvn clean
install package" again. Note you need to place the "path" with the actual
location of the jar on your local machine.
mvn install:install-file -Dfile=<path-to-file> -DgroupId=com.anuj.teradata
-DartifactId=tdgsconfig -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
mvn install:install-file -Dfile=<path-to-file> -DgroupId=com.anuj.teradata
-DartifactId= terajdbc4 -Dversion=1.0.0-SNAPSHOT -Dpackaging=jar
On Sat, May 21, 2016 at 11:03 PM, Anuj Handa <an...@gmail.com> wrote:
> hi Jeremy,
>
> I have no idea on how to use maven but i gave it a try and i am getting
> the error
>
> [ERROR] Failed to execute goal on project teradata-uber: Could not resolve
> dependencies for project com.anuj:teradata-uber:jar:1.0-SNAPSHOT: The
> following artifacts could not be resolved: com.anuj.teradata:tdgsconfig:jar
>
> i am not sure what location the teradata jar files should be and i tried
> multiple locations.
> MVN command
> c:\apache-maven-3.3.9\teradata-uber> mvn archetype:generate
> -DgroupId=com.anuj -DartifactId=teradata-uber
> -DarchetypeArtifactId=maven-archetype-quickstart
> -DinteractiveMode=false
>
> my pom file
> <?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.anuj</groupId>
> <artifactId>teradata-uber</artifactId>
> <version>1.0-SNAPSHOT</version>
>
> <dependencies>
>
> <dependency>
> <groupId>com.anuj.teradata</groupId>
> <artifactId>tdgsconfig</artifactId>
> <version>1.0.0-SNAPSHOT</version>
> </dependency>
> <dependency>
> <groupId>com.anuj.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 10:40 PM, Jeremy Dyer <jd...@gmail.com> wrote:
>
>> 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 <an...@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
>>>
>>
>>
>
Re: Put SQL to connect to Teradata
Posted by Anuj Handa <an...@gmail.com>.
hi Jeremy,
I have no idea on how to use maven but i gave it a try and i am getting the
error
[ERROR] Failed to execute goal on project teradata-uber: Could not resolve
dependencies for project com.anuj:teradata-uber:jar:1.0-SNAPSHOT: The
following artifacts could not be resolved: com.anuj.teradata:tdgsconfig:jar
i am not sure what location the teradata jar files should be and i tried
multiple locations.
MVN command
c:\apache-maven-3.3.9\teradata-uber> mvn archetype:generate
-DgroupId=com.anuj -DartifactId=teradata-uber
-DarchetypeArtifactId=maven-archetype-quickstart
-DinteractiveMode=false
my pom file
<?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.anuj</groupId>
<artifactId>teradata-uber</artifactId>
<version>1.0-SNAPSHOT</version>
<dependencies>
<dependency>
<groupId>com.anuj.teradata</groupId>
<artifactId>tdgsconfig</artifactId>
<version>1.0.0-SNAPSHOT</version>
</dependency>
<dependency>
<groupId>com.anuj.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 10:40 PM, Jeremy Dyer <jd...@gmail.com> wrote:
> 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 <an...@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
>>
>
>
Re: Put SQL to connect to Teradata
Posted by Jeremy Dyer <jd...@gmail.com>.
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 <an...@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
>