Skip to main content
August 16, 2011
Question

Teradata JDBC 13 Exception on Coldfusion 9

  • August 16, 2011
  • 1 reply
  • 2330 views

We are using AIX 6.1, Websphere 7 and Coldfusion 9

Coldfusion 9 (Installed on Websphere) is raising an exception when TTU 13 JDBC is used.  However TTU12 works fine with Coldfusion 9. The following exception is thrown when trying to define a Teradata Data source with Version 13 JDBC driver.    There are no problems with the driver since it is working ok with the other java application.

Teradata 13 JDBC Driver   Error   Connection verification failed for data source: Test_TD_13
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Packet receive Fri Aug 12 13:03:34 EDT 2011 socket orig=a7db.it.att.com local=/130.8.68.31:53109 remote=a7dbcop4.it.att.com/130.8.39.73:1025 keepalive=false nodelay=false receive=65160 send=65160 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=5 connecttotaltime=6 connectattempts=1 connectfailures=0 failurecache={} cid=7e2a7e2a sess=24875882 com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1014] [SQLState HY000] TeraEncrypt: Error tdgss-stack-trace-begin>>> org.ietf.jgss.GSSException, major code: 6, minor code: 0 major string: Integrity check failed minor string: None at com.teradata.tdgss.jgssp2td2.Td2Crypto.unwrap(Unknown Source) at com.teradata.tdgss.jgssp2td2.Td2Context.unwrap(Unknown Source) at com.teradata.tdgss.jtdgss.TdgssContext.unwrap(Unknown Source) at com.teradata.jdbc.jdbc.GenericTeraEncrypt.decrypt(GenericTeraEncrypt.java:515) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.decryptIt(TDPacketStream.java:879) at com.teradata.jdbc.jdbc_4.io.TDPacketStream.readStream(TDPacketStream.java:821) at com.teradata.jdbc.jdbc.GenericConnectRspState.action(GenericConnectRspState.java:67) at com.teradata.jdbc.jdbc.GenericLogonController.run(GenericLogonController.java:120) at com.teradata.jdbc.jdbc_4.TDSession.(TDSession.java:218) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:593) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:736) <<(TDSession.java:218) at com.teradata.jdbc.jdk6.JDK6ConnectionFactory.constructConnection(JDK6ConnectionFactory.java:22) at com.teradata.jdbc.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:127) at com.teradata.jdbc.TeraDriver.doConnect(TeraDriver.java:219) at com.teradata.jdbc.TeraDriver.connect(TeraDriver.java:152) at coldfusion.server.j2ee.sql.pool.JDBCPool.createPhysicalConnection(JDBCPool.java:593) at coldfusion.server.j2ee.sql.pool.ConnectionRunner$RunnableConnection.run(ConnectionRunner.java:67) at java.lang.Thread.run(Thread.java:736)
The root cause was that: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1000] [SQLState 08S01] Login failure for Packet receive Fri Aug 12 13:03:34 EDT 2011 socket orig=a7db.it.att.com local=/130.8.68.31:53109 remote=a7dbcop4.it.att.com/130.8.39.73:1025 keepalive=false nodelay=false receive=65160 send=65160 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=5 connecttotaltime=6 connectattempts=1 connectfailures=0 failurecache={} cid=7e2a7e2a sess=24875882 com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.18] [Error 1014] [SQLState HY000] TeraEncrypt: Error tdgss-stack-trace-begin>>> org.ietf.jgss.GSSException, major code: 6, minor code: 0 major string: Integrity check failed minor string: None at com.teradata.tdgss.jgssp2td2.Td2Crypto.unwrap(Unknown Source) at com.teradata.tdgss.jgssp2td2.Td2Context.unwrap(Unknown Source) at com.teradata.tdgss.jtdgss.TdgssContext.unwrap(Unknown Source) at com.teradata.jdbc.jdbc.Generi...

    This topic has been closed for replies.

    1 reply

    June 7, 2012

    The following when  added to WebSphere JVM Arguments that solves the problem for Teradata JDBC 13.

    -Dcoldfusion.disablejsafe=true

    The option can be added via the Websphere console or directly to the server.xml

    Example :

    <jvmEntries xmi:id="JavaVirtualMachine_1308320513740" verboseModeClass="false" verboseModeGarbageCollection="false" verboseModeJNI="false" initialHeapSize="128" max

    imumHeapSize="1024" runHProf="false" hprofArguments="" debugMode="false" debugArgs="-agentlib:jdwp=transport=dt_socket,server=y,suspend=n,address=7777" genericJvmArgume

    nts="-Dcoldfusion.disablejsafe=true" executableJarFileName="" disableJIT="false">