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.

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