[nageswarkv]

Hi there,

When I try to connect to TeraData using Database Explorer, I couldnt connect and I got logon Encryption failed.

*** Date: Wed Jun 07 12:33:34 CDT 2006

*** System properties:
OS=WindowsXP
OS version=5.1
Java version=1.5.0_04

*** MyEclipse details:
MyEclipse Enterprise Workbench

Version: 5.0 Milestone 1
Build id: 20060515-5.0-M1

*** Eclipse details:
Eclipse SDK

Version: 3.2.0
Build id: I20060602-1317

Eclipse Platform

Version: 3.2.0.v20060602-0010-_OZ2h-8eOaU1uKq
Build id: I20060602-1317

Eclipse RCP

Version: 3.2.0.v20060602-0010-VDNgVdItGFMTNJo
Build id: I20060602-1317

Eclipse Java Development Tools

Version: 3.2.0.v20060602-0010-F7snq0fulF-UQcP
Build id: I20060602-1317

Eclipse Plug-in Development Environment

Version: 3.2.0.v20060602-0010-6zXJJzJvOWpFYED
Build id: I20060602-1317

Eclipse Project SDK

Version: 3.2.0.v20060404-uDfm0S6NTspEZqy
Build id: I20060602-1317

Eclipse startup command=-os
win32
-ws
win32
-arch
x86
-launcher
C:\DummyTesting\eclipse-SDK-3.2RC7-win32\eclipse\eclipse.exe
-name
Eclipse
-showsplash
600
-exitdata
19fc_4c
-vm
c:\Software\J2SDK1.5.0_04\bin\javaw.exe

ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-06-07 10:38:20.989
!MESSAGE Error while trying to login to database
!STACK 0
com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : Encrypted logon failed: EncryptContextState action: local=/69.58.203.75:1426 remote=slgo1093COP3/69.58.249.196:1025 cid=1cbe54c sess=5804166 Wed Jun 07 10:38:20 CDT 2006 java.lang.NoClassDefFoundError: tdgssjava/tdgssmessageprop at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:62) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56) at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99) at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43) at java.lang.Thread.run(Thread.java:595)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:46)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:136)
at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:127)
at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56)
at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103)
at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-06-07 12:02:02.241
!MESSAGE Error while trying to login to database
!STACK 0
com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : Encrypted logon failed: EncryptContextState action: local=/69.58.203.75:1710 remote=slgo1093COP4/69.58.249.210:1025 cid=1cc521e sess=5808400 Wed Jun 07 12:02:01 CDT 2006 java.lang.NoClassDefFoundError: tdgssjava/tdgssmessageprop at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:62) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56) at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99) at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43) at java.lang.Thread.run(Thread.java:595)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:46)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:136)
at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:127)
at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56)
at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103)
at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-06-07 12:04:27.116
!MESSAGE Error while trying to login to database
!STACK 0
com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : Encrypted logon failed: EncryptContextState action: local=/69.58.203.75:1714 remote=slgo1093COP14/69.58.249.212:1025 cid=14baaaf sess=5808516 Wed Jun 07 12:04:26 CDT 2006 java.lang.NoClassDefFoundError: tdgssjava/tdgssmessageprop at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:62) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56) at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99) at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43) at java.lang.Thread.run(Thread.java:595)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:46)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:136)
at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:127)
at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56)
at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103)
at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

!ENTRY com.genuitec.eclipse.sqlexplorer 4 4 2006-06-07 12:27:41.400
!MESSAGE Error while trying to login to database
!STACK 0
com.ncr.teradata.jdbc_4.util.JDBCException: [NCR] [Teradata JDBC Driver] : Encrypted logon failed: EncryptContextState action: local=/69.58.203.75:1742 remote=slgo1093COP13/69.58.249.211:1025 cid=1b53fe9 sess=5809589 Wed Jun 07 12:27:41 CDT 2006 java.lang.NoClassDefFoundError: tdgssjava/tdgssmessageprop at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:62) at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56) at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87) at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103) at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267) at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99) at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43) at java.lang.Thread.run(Thread.java:595)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:68)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeDriverJDBCException(ErrorFactory.java:46)
at com.ncr.teradata.jdbc_4.util.ErrorFactory.makeIoJDBCException(ErrorFactory.java:136)
at com.ncr.teradata.jdbc_4.statemachine.EncryptContextState.action(EncryptContextState.java:127)
at com.ncr.teradata.jdbc_4.statemachine.LogonController.run(LogonController.java:56)
at com.ncr.teradata.jdbc_4.TDSession.connect(TDSession.java:87)
at com.ncr.teradata.jdbc_3.ifjdbc_4.TeraLocalConnection.<init>(TeraLocalConnection.java:103)
at com.ncr.teradata.TeraDriver.connect(TeraDriver.java:267)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:43)
at java.lang.Thread.run(Thread.java:595)

I couldnt find what are all the Databases that MyEclipse5.1 with Eclipse 3.2 supports ?

I rather remember finding some time ago that MyEclipse5.1 does not include teradata in the list of Databases it supports

Appreciate quicker response

[Haris Peco]

nageswarkv ,

We test mysql, postgresql, derby , db2, oracle, sybase, mssql, hsqldb, but some databases with
jdbc driver will work – at least base operation like explore tables, tables info, sql editor etc
We can’t test your databases, but from your log it looks that we have problems with drivers – your drivers can’t find some requested class
I suggest that you try simple java application ofr login – see this link for example
http://myeclipseide.com/PNphpBB2+file-viewtopic-t-11228.html

Best regards

[nageswarkv]

I am able to connect to TeraData Db after loading tera data drivers in classpath but
I am not seeing create Hiberante Mappings for those tables.

Also, I think MyEclipse doesnot have Teradata driver class or Teradata dialect when you are creatin database profile name

in either Hibernate console configuration or when new DB connection is made. I am assuming that MyEclipse doesnot support Teradata but when I select Generic driver for Teradata, It is giving error saying that not able to recognize teradata drivers which i have given in CLASSPATH.

I am able to successfully using MyEclipse5.1 with Eclipse3.2 for Oracle Tables and Now I need to make it work with Teradata.

Also, I was not able to create generate mapping files for Oracle tables with MyEclipse4.1 and Eclipse3.1.2 and I was having Invalid Strange column name and I have posted previously and I was struggling that time. Now I am encountered another Obstacle.

Overall support for this tool is not satisfactory and one point of time, we have moved away from MyEclipse and wanted to use Hiberante tools available on http://www.hiberante.org and do reverse Engineering.

[Haris Peco]

You will be able to use teradata in db explorer , except if your driver is bad, but you can’t use hibernate with teradata, because doesn’t exists hibernate dialect

see http://www.hibernate.org/80.html

Oracle and MyEclipse (db explorer and hibernate) work fine

Best regards

[nageswarkv]

1. Does this means, that I cant generate Mapping file for Teradata tables. But I am able to generate Config file for Teradata database.

This means, I cant do Reverse Engineering for Teradata tables.

2. But as per http://www.hibernate.org/80.html , it seems we can derived Teradata dialect from available dialect, Can you guys explain how I can do this.

[Haris Peco]

yes, you can’t make mappings without hibernate dialect

If you want make hibernate dialect you have to create class which extends org.hibernate.dialect.Dialect and add specific informations for your databases – for help you can see some dialects (for example OracleDialect) in hibernate source)

Best regards

[Author]

Posts