Forum Discussion

alex1's avatar
alex1
New Contributor

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

nmrao's avatar
nmrao
Champion Level 3
9 years ago
Please see if the below link helps.
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.
  • MarcusJ's avatar
    MarcusJ
    Moderator
    9 years ago

    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

    • nmrao's avatar
      nmrao
      Champion Level 3
      9 years ago
      What 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').