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.
- MarcusJ9 years agoModerator
Also, to add to what nmrao said please make sure you restart SoapUI after adding the JDBC driver jar files to {SoapUI install}\bin\ext directory.
Edit:
If you are connecting to the database using a Groovy script and not the JDBC test step then put the jar files in the {SoapUI install}\lib directory and restart SoapUI.
Regards,
Marcus
SmartBear Support
- nmrao9 years agoChampion Level 3What I noticed while connecting to other databases is that, it can connect to database if the libraries copied into SOAPUI_HOME\bin\ext directory. But have to register using
com.eviware.soapui.support.GroovyUtils.registerJdbcDriver('driver class').
Related Content
- 11 years ago
- 8 years ago
- 9 years ago
- 7 years ago
Recent Discussions
- 22 days ago