Forum Discussion

lvogelaar's avatar
lvogelaar
New Contributor
8 years ago

Cant get JDBC connection to microsoft sqlserver to work

Hello,   I'm having issues getting a jdbc connection to work. I've tried several things regarding to other topics but no success so far.   So, I'm using ReadyApi 2.2   bin\ext folder contains s...
  • nmrao's avatar
    nmrao
    8 years ago
    Alternative library available if you want to try.

    Download jtds-1.3.1.jar
    And place it under READYAPI_HOME/bin/ext directory and restart.

    Use driver class as : net.sourceforge.jtds.jdbc.Driver

    Use connection string as :
    jdbc:jtds:sqlserver://${dbServer}:${port}/${dbName};domain=${domain}

    NOTE: replace the above place holder values.
testhrishi's avatar
testhrishi
Frequent Contributor
8 years ago

Try adding sqljdbc4.jar and sqljdbc.jar files in addition to the sqljdbc42.jar that you have

  • lvogelaar's avatar
    lvogelaar
    New Contributor
    8 years ago

    Hello,

     

    I've first tried adding the sqljdbc4.jar to bin\ext which gives the same result. Then also the sqljdbc.jar which results in the following error:

     

    java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.8 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

     

    documentation:

    sqljdbc.jar class library requires a Java Runtime Environment (JRE) of version 5.0. Using sqljdbc.jar on JRE 6.0 or JRE 7.0 will throw an exception when connecting to a database.

    • testhrishi's avatar
      testhrishi
      Frequent Contributor
      8 years ago

      Sorry I use com.mysql.jdbc.Driver. So you may have other issue with MS drivers

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Alternative library available if you want to try.

      Download jtds-1.3.1.jar
      And place it under READYAPI_HOME/bin/ext directory and restart.

      Use driver class as : net.sourceforge.jtds.jdbc.Driver

      Use connection string as :
      jdbc:jtds:sqlserver://${dbServer}:${port}/${dbName};domain=${domain}

      NOTE: replace the above place holder values.
      • lvogelaar's avatar
        lvogelaar
        New Contributor
        8 years ago

        Hi Rao,

         

        Finally I've managed to get it to work! Thanks for the solution!