All Forums Connectivity
geetikak 3 posts Joined 11/14
01 Apr 2015
Teradata connectivity Issue through JDBC Driver in java

Hi All,
I am trying to connect my Teradata server through JDBC Driver in java to my Web Application. I am using the following Connection String:
String connectionString ="jdbc:teradata://DatabaseServerName/ DATABASE=xxx,DBS_PORT=1025,USER=xxxx,PASSWORD=xxxxx";
I am getting the following error:
com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC] [Error 1032] [SQLState HY000] Single Sign-On NOT supported for Mechanism TD2.
    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.GenericTeraEncrypt.initEncrypt(
    at com.teradata.jdbc.jdbc.GenericTeraEncrypt.<init>(Gener
    at com.teradata.jdbc.jdbc.GenericAssignState.action(Gener
    at com.teradata.jdbc.jdbc_4.TDSession.<init>(TDSession.ja va:199)
    at com.teradata.jdbc.jdbc_3.ifjdbc_4.TeraLocalConnection. <init>(
    at com.teradata.jdbc.jdbc.ConnectionFactory.createConnect ion(
    at com.teradata.jdbc.TeraDriver.doConnect( :217)
    at com.teradata.jdbc.TeraDriver.connect( 150)
    at java.sql.DriverManager.getConnection(DriverManager.jav a:664)
    at java.sql.DriverManager.getConnection(DriverManager.jav a:270)
I tried to solve this issue by adding LOGMECH=td2 in the connection string. Since my teradata server is implemented using the TD2 Log On Mechanism, But still i am facing the same issue.
Can anyone Please help me to solve this issue.
Thank you

Fred 1096 posts Joined 08/04
02 Apr 2015

Remove the space from your connection string.

tomnolan 594 posts Joined 01/08
02 Apr 2015

The error message "Single Sign-On NOT supported" typically means that you did not specify a username or password.
You are using a very old version of the Teradata JDBC Driver that does not offer the USER and PASSWORD JDBC URL connection parameters; therefore, the JDBC Driver behaves as though you did not specify a username or password at all.
The USER and PASSWORD JDBC URL connection parameters were introduced with Teradata JDBC Driver, as documented in the Teradata JDBC Driver User Guide here on Developer Exchange:
Upgrade to the latest version of the Teradata JDBC Driver available here on Developer Exchange.

geetikak 3 posts Joined 11/14
03 Apr 2015

Thank You Tomnolan. :)
Now its working. Thanks alot :)

You must sign in to leave a comment.