We're trying to connect to our teradata database through Java using TMODE=ANSI, and it's throwing the following error:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata JDBC Driver] [TeraJDBC 13.10.00.31] [Error 1000] [SQLState 08S01] Login failure for Connection to XXXXXX.XXX.XX.com,tmode=ANSI Sat Oct 20 17:47:14 IST 2012 socket orig=XXXXXX.XXX.XX.com,tmode=ANSI cid=633c3c sess=0
I didn't find much help on google with this, so I'm hoping someone here has either seen this error before, or can spot what could be the problem with my connection string.
Here's what the java code portion looks like:
Any help or suggestions is very much appreciated. Thank you!
Try to replace , for / in the connection string: