Forum Discussion

  • alex1's avatar
    alex1
    New Contributor
    9 years ago

    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