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.
lvogelaar's avatar
lvogelaar
New Contributor

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.

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!

    • nmrao's avatar
      nmrao
      Champion Level 3
      8 years ago
      Glad to know that it helped.