Forum Discussion
nmrao, MarcusJ, Hello, I did it, but still get the following error:
- Error getting response; com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [com.teradata.jdbc.TeraDriver], connectionString [jdbc:teradata://host/USER=yyyyy,PASSWORD=xxxxx]
The connection string is tested with java and works with the same jdbc, that is placed in SoapUI/bin/ext
Edit: Trying to make this work, in Groovy Script I run following code:
import groovy.sql.Sql;
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver( "com.teradata.jdbc.TeraDriver" )
def con = Sql.newInstance("jdbc:teradata://dbhost", "usr", "pass", "com.teradata.jdbc.TeraDriver");
And it says
- java.lang.ClassNotFoundException: com.teradata.jdbc.TeraDriver
But the path in Teradata jar in SoapUI/bin/ext is correct: exactly com.teradata.jdbc.TeraDriver
https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html
According to the above link, it requires two jar files:
terajdbc4.jar
tdgssconfig.jar
And see which connection string works:
JDBC Type 3: jdbc:teradata://gwhost:port/DatabaseServerName
JDBC Type 4: jdbc:teradata://DatabaseServerName
Another one:
Sql.newInstance("try type 3 or type 4 ", "usr", "pass") -- note no 4th parameter.