JDBC connection through JAVA throwing an error, "Could not create connection; - nested throwable:"

Database
Enthusiast

JDBC connection through JAVA throwing an error, "Could not create connection; - nested throwable:"

Hi everyone,

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:

<local-tx-datasource>

   <jndi-name>WEB_xxxxxxxxxxxx-createrule-ds</jndi-name>

   <connection-url>jdbc:teradata://XXXXXX.XXX.XX.com,tmode=ANSI</connection-url>

   <driver-class>com.teradata.jdbc.TeraDriver</driver-class>

   <user-name>XXXXX_XXX_XXX</user-name>

   <check-valid-connection-sql>sel date</check-valid-connection-sql>

   <password></password>

   <min-pool-size>5</min-pool-size>

   <max-pool-size>100</max-pool-size>

</local-tx-datasource>

Any help or suggestions is very much appreciated.  Thank you!

Tags (3)
1 REPLY

Re: JDBC connection through JAVA throwing an error, "Could not create connection; - nested throwable:"

Try to replace , for / in the connection string:

jdbc:teradata://XXXXXX.XXX.XX.com,tmode=ANSI

to 

jdbc:teradata://XXXXXX.XXX.XX.com/tmode=ANSI