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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >>> 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 <[email protected]> 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 <[email protected]> >>>>> 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 >>>>>> >>>>> >>>>> >>>> >>> >> >
