All Forums Connectivity
haunties 1 post Joined 04/15
15 Apr 2015
Teradata Birt JDBC datasource creation

Hi,
I'm on a windows 7 in 32 bits and I use Eclipse IDE for Java EE developper and I install Birt framework manually.
 
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$ConnectThrea d.run(TDNetworkIOIF.java:968)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:93)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(ErrorFactory.java:68)

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCE xception(ErrorFactory.java:206)

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoE rror(ErrorAnalyzer.java:61)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocket Connection(TDNetworkIOIF.java:137)

at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.(TDNetworkIO IF.java:116)

at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.jav a:580)

at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:95)

at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java: 209)

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_C onnection.java:30)

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct Connection(JDK6ConnectionFactory.java:22)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(ConnectionFactory.java:130)

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(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.Te radataJDBCConnection.makeConnection(TeradataJDBCConnec tion.java:276)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.createConnection(TeradataJDBCConn ection.java:121)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.internalCreateConnection(DriverConnectionBase.java: 105)

at org.eclipse.datatools.connectivity.DriverConnectionBas e.open(DriverConnectionBase.java:54)

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo nnection.open(JDBCConnection.java:96)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataPingFactory.createConnection(TeradataPingFactory .java:36)

at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv ider.java:83)

at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(ConnectionProfile.java:359)

at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(PingJob.java:76)

at org.eclipse.datatools.connectivity.ui.PingJob.run(Ping Job.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$ConnectThrea d.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.
 
Thanks if someone have any solution.

 

jlux33 1 post Joined 07/16
30 Jul 2016

Did you ever get the JDBC data source for Teradata workign in BIRT?

You must sign in to leave a comment.