back to forum.

Topic: teradata connection

Topic by
sheridany

2011-03-12
06:58

teradata connection

I am trying to get a connection to teradata through jdbc and here is the log. Can someone assist in telling me what is wrong here.


Could not establish connection


Message:
java.lang.NullPointerException
Level:
SEVERE
Stack Trace:
null
com.teradata.tdgss.jtdgss.TdgssConfigApi.GetMechanisms(DashoA1*..)
com.teradata.tdgss.jtdgss.TdgssManager.<init>(DashoA1*..)
com.teradata.tdgss.jtdgss.TdgssManager.getInstance(DashoA1*..)
com.teradata.jdbc.jdbc.GenericTeraEncrypt.getGSSM(GenericTeraEncrypt.java:583)
com.teradata.jdbc.jdbc.GenericTeraEncrypt.getConfig(GenericTeraEncrypt.java:601)
com.teradata.jdbc.jdbc.GenericTeraEncrypt.getUserNameForOid(GenericTeraEncrypt.java:694)
com.teradata.jdbc.AuthMechanism.<init>(AuthMechanism.java:50)
com.teradata.jdbc.jdbc.GenericInitDBConfigState.action(GenericInitDBConfigState.java:105)
com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:49)
com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.java:196)
com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:94)
com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:55)
com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:216)
com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:149)
org.eobjects.datacleaner.database.DriverWrapper.connect(DriverWrapper.java:47)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.eobjects.analyzer.connection.JdbcDatastore.createConnection(JdbcDatastore.java:160)
org.eobjects.datacleaner.windows.JdbcDatastoreDialog$4.actionPerformed(JdbcDatastoreDialog.java:272)
javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
javax.swing.DefaultButtonModel.setPressed(Unknown Source)
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
java.awt.Component.processMouseEvent(Unknown Source)
javax.swing.JComponent.processMouseEvent(Unknown Source)
java.awt.Component.processEvent(Unknown Source)
java.awt.Container.processEvent(Unknown Source)
java.awt.Component.dispatchEventImpl(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
java.awt.Container.dispatchEventImpl(Unknown Source)
java.awt.Window.dispatchEventImpl(Unknown Source)
java.awt.Component.dispatchEvent(Unknown Source)
java.awt.EventQueue.dispatchEvent(Unknown Source)
java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.pumpEvents(Unknown Source)
java.awt.EventDispatchThread.run(Unknown Source)

Reply by
sheridany

2011-03-12
18:28
I figured it. YOu have to set the classpath on the command line to point to the jdbc and the gssconfig in the data cleaner directory. I have a new problem and going to start a new topic.

Reply by
kasper

2011-03-12
18:38
Hi sheridany,

This might be very valuable information. Please share what you find out because I don't think we have too much information regarding how to set up teradata and we could use some improvements here. If you give us all the details we can make it a lot easier in the upcoming versions to configure teradata.

For example: Tell me more about gssconfig - what is it and how should a user obtain it?

Reply by
sheridany

2011-03-12
19:23
Not a problem. Happy to share what I did. We are running Teradata 13 so this applies to TD 12 or 13.
1) Download the jar files. There are two of them.
-terajdbc4.jar
-tdgssconfig.jar
Both of those are available for free from the Teradata site in the zipfile.
Put both of them in the datacleaner directory.
Open the DOS window. Navigate to the datacleaner folder. Set the classpath=terajdbc4.jar;tdgssconfig.jar
Go to manage database drivers in the setup database connection. Go to Teradata. Add database driver. Point to both jar files (listed above as separate entries) in the configuration that are located in the data cleaner directory.
Save and close.
Configure your connection string and test connection.
It should work.

You need to be logged in to participate

In order to post your own comments on this topic, you need to be logged in.

Username:

Log in by clicking the login link at the top of the screen

 

Go back to forum.