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

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] [Error 1277] [SQLState 08S01] Login timeout for Connection to Wed Apr 15 09:56:47 CEST 2015 socket orig= cid=30f69c sess=0 Connect timed out at Source) at Source) at Source) at$ConnectThrea

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJ DBCException(

at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeIoJDBCE xception(

at com.teradata.jdbc.jdbc_4.util.ErrorAnalyzer.analyzeIoE rror(

at Connection(


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


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

at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.(JDK6_SQL_C

at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.construct Connection(

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(

at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(

at com.teradata.jdbc.TeraDriver.doConnect( :220)

at com.teradata.jdbc.TeraDriver.connect( 153)

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.makeConnection(TeradataJDBCConnec

at com.teradata.datatools.dtp.connectivity.db.teradata.Te radataJDBCConnection.createConnection(TeradataJDBCConn

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

at org.eclipse.datatools.connectivity.DriverConnectionBas

at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCCo

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

at org.eclipse.datatools.connectivity.internal.Connection FactoryProvider.createConnection(ConnectionFactoryProv

at org.eclipse.datatools.connectivity.internal.Connection Profile.createConnection(

at org.eclipse.datatools.connectivity.ui.PingJob.createTe stConnection(


at 54)

Caused by: Connect timed out

at Source)

at Source)

at Source)

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
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.