nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Teradata JDBC

Migrateduser

Hi, 
 
I want to use a datasource connected with a teradata database. 
So I try some way. 
 
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)", 
That don't work either. 
We use a Teradata v14.00 that doesn't matters ? Or we need a driver more recent ? 
 
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 " 
 
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) 
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:93) 
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68) 
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:206) 
at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoError(ErrorAnalyzer.java:61) 
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:137) 
at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIOIF.java:116) 
at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:580) 
at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:95) 
at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:209) 
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_Connection.java:30) 
at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) 
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:130) 
at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:120) 
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:220) 
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:153) 
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.makeConnection(TeradataJDBCConnection.java:276) 
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataJDBCConnection.createConnection(TeradataJDBCConnection.java:121) 
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) 
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) 
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96) 
at com.teradata.datatools.dtp.connectivity.db.teradata.TeradataPingFactory.createConnection(TeradataPingFactory.java:36) 
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) 
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359) 
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76) 
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59) 
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54) 
Caused by: 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) 

"
 
I try to enter a random server to see if we had a difference. Instead of "login time out" we have "login faillure".
 
I try also to open the command-line interface and write "ping <server database>" and that work, 0 lost.
We try to open the database with Teradata SQL Assistant and that work to. 
 
It's just the creation of a datasource with birt which don't work. Anybody can help please ? 
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
 
<context-param> 
<param-name>LOGIN_TIMEOUT</param-name> 
<param-value>900</param-value> 
</context-param>
 
But after that we can't restart eclipse.

Find more posts tagged with

Comments

There are no comments yet