All Forums Connectivity
30 May 2011
Could you tell me the reason why login time out?

I could connect the DBS via bteq when the program was retrying to connect to TD DBS(14f.00.00.00).
But who can tell me it is an issue of c3p0 module or TeraDriver?
DEBUG com.mchange.v2.resourcepool.BasicResourcePool - An exception occurred while acquiring a poolable resource. Will retry.
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1276] [SQLState 08S01] Exceeded login timeout for 153.64.211.204
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.ConnectionBase.checkRemainingLo ginTime(ConnectionBase.java:91)
at com.teradata.jdbc.jdbc.GenericEncryptContextState.acti on(GenericEncryptContextState.java:119)
at com.teradata.jdbc.jdbc.GenericLogonController.run(Gene ricLogonController.java:120)
at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java: 218)
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:127)
at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java :219)
at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java: 152)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnect ion(DriverManagerDataSource.java:134)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.ge tPooledConnection(WrapperConnectionPoolDataSource.java :182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.ge tPooledConnection(WrapperConnectionPoolDataSource.java :171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1Poo ledConnectionResourcePoolManager.acquireResource(C3P0P ooledConnectionPool.java:152)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquir e(BasicResourcePool.java:1074)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquir eAndDecrementPendingAcquiresWithinLockOnSuccess(BasicR esourcePool.java:1061)
at com.mchange.v2.resourcepool.BasicResourcePool.access$8 00(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$Scattere dAcquireTask.run(BasicResourcePool.java:1796)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$Pool Thread.run(ThreadPoolAsynchronousRunner.java:620)

Tags:
30 May 2011

It is timeout too when using like:
{code}
Class.forName("com.teradata.jdbc.TeraDriver");
DriverManager.getConnection("jdbc:teradata://" + getDBServer().getIp(), getDBServer().getDbUsername(), getDBServer().getDbPassword());
{code}
to get a new connection.

tomnolan 594 posts Joined 01/08
31 May 2011

>>> Could you tell me the reason why login time out?

By default, there is no login timeout for the Teradata JDBC Driver.

The exception you listed "Exceeded login timeout" occurs when you specify a non-zero login timeout using the either the DriverManager.setLoginTimeout method or the DataSource.setLoginTimeout method.

3edcvfr4 2 posts Joined 01/16
30 Jan 2016

Hi Tomnolan,
we got the same error when connecting teradata, could you tell us what properites the com.teradata.jdbc.jdbc.ConnectionBase.checkRemainingLoginTime method is looking for, so that we can set that value to avoid being timeout, or could you paste the code in com.teradata.jdbc.jdbc.ConnectionBase.checkRemainingLoginTime?
another question is do you provide source code of the teradata jdbc so that we can check the error our selves. currently there is not enough information for us to trouble shooting.

3edcvfr4 2 posts Joined 01/16
30 Jan 2016

Hi Tomnolan,
we got the same error when connecting teradata, could you tell us what properites the com.teradata.jdbc.jdbc.ConnectionBase.checkRemainingLoginTime method is looking for, so that we can set that value to avoid being timeout, or could you paste the code in com.teradata.jdbc.jdbc.ConnectionBase.checkRemainingLoginTime?
another question is do you provide source code of the teradata jdbc so that we can check the error our selves. currently there is not enough information for us to trouble shooting.

tomnolan 594 posts Joined 01/08
01 Feb 2016

As I said in my earlier post, by default, there is no login timeout for the Teradata JDBC Driver. A login timeout only occurs when your application (or application server) specifies a non-zero login timeout using the either the DriverManager.setLoginTimeout method or the DataSource.setLoginTimeout method.

You must sign in to leave a comment.