Teradata JDBC

<p>Hi,<br>
<br>
I want to use a datasource connected with a teradata database.<br><br>
So I try some way.<br>
<br>
At first I try to connect with ODBC with the driver "sun.jdbc.odbc.JdbcOdbcDriver (v2.1)" but that didn't work. So after I search a specific driver for teradata, I find the "com.teradata.jdbc.TeraDriver (v13.10)",<br>
That don't work either.<br>
We use a Teradata v14.00 that doesn't matters ? Or we need a driver more recent ?<br>
<br>
At last I try to install the Teradata Eclipse plugins to connect with a teradata database with the JDBC database for query builder. We try all the way (we think) in this method but nothing work, we have ever the same error "<br>
<br>
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.36] [Error 1277] [SQLState 08S01] Login timeout for Connection to 93.95.17.13 Wed Apr 15 09:56:47 CEST 2015 socket orig=93.95.17.13 cid=30f69c sess=0 java.net.SocketTimeoutException: Connect timed out at java.net.SocksSocketImpl.readSocksReply(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)<br><br>
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93)<br><br>
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)<br><br>
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206)<br><br>
at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61)<br><br>
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137)<br><br>
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116)<br><br>
at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580)<br><br>
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95)<br><br>
at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:209)<br><br>
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30)<br><br>
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22)<br><br>
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130)<br><br>
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120)<br><br>
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220)<br><br>
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153)<br><br>
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:276)<br><br>
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121)<br><br>
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)<br><br>
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)<br><br>
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)<br><br>
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36)<br><br>
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)<br><br>
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)<br><br>
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)<br><br>
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)<br><br>
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)<br><br>
Caused by: java.net.SocketTimeoutException: Connect timed out<br><br>
at java.net.SocksSocketImpl.readSocksReply(Unknown Source)<br><br>
at java.net.SocksSocketImpl.connect(Unknown Source)<br><br>
at java.net.Socket.connect(Unknown Source)<br><br>
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$ConnectThread.run(TDNetworkIOIF.java:968)<br>
</p>
<p>"</p>
<p> </p>
<p>I try to enter a random server to see if we had a difference. Instead of "login time out" we have "login faillure".</p>
<p> </p>
<p>I try also to open the command-line interface and write "ping <server database>" and that work, 0 lost.</p>
<p>We try to open the database with Teradata SQL Assistant and that work to. </p>
<p> </p>
<p>It's just the creation of a datasource with birt which don't work. Anybody can help please ?<br><br>
I saw we can modify the time for Login_timeout in the web.xlm file in WEB-INF folder, but I don't find the variable "login_timeout" I try so to writte something like that</p>
<p> </p>
<p><context-param><br>
<param-name>LOGIN_TIMEOUT</param-name><br>
<param-value>900</param-value><br>
</context-param></p>
<p> </p>
<p>But after that we can't restart eclipse.</p>

Find more posts tagged with

Comments

mwilliams

What teradata product are you using? If I download teradata express, will I be able to test what you've got?

Fuigi

<p>we use teradata datawarhouse 14.10.04.03</p>

mwilliams

Not sure I can get a trial of that. If you have a link, I'll try it out. I downloaded the Teradata Express 14.10.03 VMWare image. It should have a database where I can try using the JDBC connector.

Fuigi

<p>It's good ! It work now. That was just an error in the preference, in Network Connections.</p>

mwilliams

Awesome! Great to hear! Thanks for the update!

jlux33

<p>I am having trouble connecting to my Teradata data warehouse. My error is below. How did you get this working? I know I have connectivity because if I use a wrong IP address, I get a different error.</p>
<p> </p>
<p>I am using Birt designer pro on a mac.</p>
<p> </p>
<div>org.eclipse.birt.report.data.oda.jdbc.JDBCException: There is an error in get connection, [Teradata JDBC Driver] [TeraJDBC 13.10.00.38] [Error 1000] [SQLState 08S01] Login failure for Connection to 192.9.220.33:6666 Fri Jul 29 12:52:52 EDT 2016 socket orig=192.9.220.33:6666 cid=7c0e4e8c sess=0 java.net.UnknownHostException: 192.9.220.33:6666 at java.net.InetAddress.getAllByName0(InetAddress. ....</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.doConnect(JDBCDriverManager.java:336)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.getConnection(JDBCDriverManager.java:209)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.tryCreateConnection(JDBCDriverManager.java:824)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.testConnection(JDBCDriverManager.java:745)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:147)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.util.DriverLoader.testConnection(DriverLoader.java:175)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.testConnection(JDBCSelectionPageHelper.java:998)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper.access$11(JDBCSelectionPageHelper.java:960)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.ui.profile.JDBCSelectionPageHelper$8.widgetSelected(JDBCSelectionPageHelper.java:883)</div>
<div>at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4136)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1458)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1481)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1466)</div>
<div>at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1271)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3982)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3621)</div>
<div>at org.eclipse.jface.window.Window.runEventLoop(Window.java:825)</div>
<div>at org.eclipse.jface.window.Window.open(Window.java:801)</div>
<div>at org.eclipse.birt.report.designer.ui.dialogs.BaseDialog.open(BaseDialog.java:117)</div>
<div>at org.eclipse.birt.report.designer.data.ui.providers.EditableDataSourceNodeProvider.performEdit(EditableDataSourceNodeProvider.java:73)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.DefaultNodeProvider.performRequest(DefaultNodeProvider.java:472)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at org.eclipse.birt.report.designer.ui.views.ElementAdapterInvocationHandler.invoke(ElementAdapterInvocationHandler.java:89)</div>
<div>at com.sun.proxy.$Proxy43.performRequest(Unknown Source)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.EditAction.doAction(EditAction.java:85)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.actions.AbstractElementAction.run(AbstractElementAction.java:70)</div>
<div>at org.eclipse.birt.report.designer.internal.ui.views.RenameListener.doubleClick(RenameListener.java:214)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:845)</div>
<div>at org.eclipse.core.runtime.SafeRunner.run(SafeRunner.java:42)</div>
<div>at org.eclipse.ui.internal.JFaceUtil$1.run(JFaceUtil.java:49)</div>
<div>at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:175)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:843)</div>
<div>at org.eclipse.jface.viewers.AbstractTreeViewer.handleDoubleSelect(AbstractTreeViewer.java:1477)</div>
<div>at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1246)</div>
<div>at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:249)</div>
<div>at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:246)</div>
<div>at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:307)</div>
<div>at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)</div>
<div>at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4136)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1458)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1481)</div>
<div>at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1466)</div>
<div>at org.eclipse.swt.widgets.Widget.notifyListeners(Widget.java:1271)</div>
<div>at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3982)</div>
<div>at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3621)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1053)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:942)</div>
<div>at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:86)</div>
<div>at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:588)</div>
<div>at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)</div>
<div>at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:543)</div>
<div>at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)</div>
<div>at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)</div>
<div>at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)</div>
<div>at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)</div>
<div>at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)</div>
<div>at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)</div>
<div>at java.lang.reflect.Method.invoke(Method.java:597)</div>
<div>at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)</div>
<div>at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)</div>
<div>at org.eclipse.equinox.launcher.Main.run(Main.java:1438)</div>
<div> </div>

Clement Wong

<p>Please provide more information to troubleshoot this issue:</p>
<p> </p>
<p>What version is the Teradata JDBC client?</p>
<p> </p>
<p>What version is the Teradata server?</p>
<p> </p>
<p>Is the IP address, 192.9.220.33, a valid address you can reach from your computer? Please provide the results of "ping 192.9.220.33".</p>
<p> </p>
<p>Is the Teradata server listening on port 6666? Can you confirm that you can connect to that port? Please provide the results of "telnet 192.9.220.33 6666".</p>
<p> </p>
<p>Are you able to connect outside of BIRT Designer Pro? For example, a JDBC Java Client or DBVisualizer (<a data-ipb='nomediaparse' href='http://www.dbvis.com/download)?'>http://www.dbvis.com/download)?</a></p>