title: HikariCP - Integration with Teradata
body: <p>I am trying to integrate Teradata with HikariCP in a Grails application and facing issues. I am able to connect to Teradata with the same configuration using the default Grails connection pool or datasource. 
  I tried tweaking the connection timeout also.</p>
  
  <p><strong>libraries used:</strong></p>
  
  <p><strong>Teradata:</strong></p>
  
  <pre><code>runtime (group: 'com.teradata', name:'terajdbc4', version:'13.10.0.8')
  runtime (group: 'com.teradata', name:'tdgssconfig', version:'13.10.0.8')
  </code></pre>
  
  <p><strong>HikariCp:</strong></p>
  
  <pre><code>compile (group: 'com.zaxxer', name: 'HikariCP-java6', version: '2.2.4')
  </code></pre>
  
  <p><strong>Connection Properties Used:</strong></p>
  
  <pre><code>[logSql:false, loggingSql:true, dialect:org.hibernate.dialect.TeradataDialect,
   driverClassName:com.teradata.jdbc.TeraDriver, username:userId, password:pwd,
   url:jdbc:teradata://DBName, pooled:true,
   properties:[initialSize:5, minIdle:1, maxIdle:5, maxActive:3, maxWait:2000,
               maxAge:60000, minEvictableIdleTimeMillis:30000, timeBetweenEvictionRunsMillis:30000,
               abandonWhenPercentageFull:50, numTestsPerEvictionRun:3, testOnBorrow:true,
               testWhileIdle:true, testOnReturn:true, validationQuery:SELECT 1,
               validationInterval:500], jndiName:[:], readOnly:[:], passwordEncryptionCodec:[:]]
  </code></pre>
  
  <p><strong>Error Log:</strong></p>
  
  <pre><code>TERAJDBC4 ERROR [HikariCP connection filler (pool HikariPool-0)] com.teradata.jdbc.jdbc_4.TDSession@5f045975 Connection to DBName
  Tue May 05 17:20:50 CDT 2015 socket orig=DBName cid=247608ab sess=0 com.teradata.jdbc.jdbc_4.util.JDBCException:
  [Teradata JDBC Driver] [TeraJDBC 13.10.00.08] [Error 1276] [SQLState 08S01] Exceeded login timeout for DBName
     at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:92)
     at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:67)
     at com.teradata.jdbc.jdbc.ConnectionBase.checkRemainingLoginTime(ConnectionBase.java:81)
     at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF$Lookup.&lt;init&gt;(TDNetworkIOIF.java:168)
     at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:289)
     at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.&lt;init&gt;(TDNetworkIOIF.java:108)
     at com.teradata.jdbc.jdbc_4.TDSession.getIO(TDSession.java:584)
     at com.teradata.jdbc.jdbc.GenericStateController.&lt;init&gt;(GenericStateController.java:41)
     at com.teradata.jdbc.jdbc.GenericLogonController.&lt;init&gt;(GenericLogonController.java:40)
     at com.teradata.jdbc.jdbc_4.TDSession.&lt;init&gt;(TDSession.java:202)
     at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection.&lt;init&gt;(TeraLocalConnection.java:99)
     at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:58)
     at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:218)
     at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:151)
     at java.sql.DriverManager.getConnection(DriverManager.java:571)
     at java.sql.DriverManager.getConnection(DriverManager.java:187)
     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:56)
     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:62)
     at com.zaxxer.hikari.pool.HikariPool.addConnection(HikariPool.java:415)
     at com.zaxxer.hikari.pool.HikariPool.access$400(HikariPool.java:73)
     at com.zaxxer.hikari.pool.HikariPool$1AddConnection.run(HikariPool.java:316)
     at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
     at java.util.concurrent.FutureTask.run(FutureTask.java:262)
     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
     at java.lang.Thread.run(Thread.java:745)
  Error | 2015-05-05 17:20:51,234 [HikariCP connection filler (pool HikariPool-0)] ERROR pool.HikariPool  - JDBC4 Connection.isValid() method not supported, connection test query must be configured
  Error | 2015-05-05 17:20:51,821 [HikariCP connection filler (pool HikariPool-0)] ERROR pool.HikariPool  - JDBC4 Connection.isValid() method not supported, connection test query must be configured
  </code></pre>