Teradata Birt JDBC datasource creation

Connectivity

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

Thanks if someone have any solution.

1 REPLY
Fan

Re: Teradata Birt JDBC datasource creation

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