Forum Discussion

cwlovell13's avatar
cwlovell13
Occasional Contributor
12 years ago

JDBC Connection to Microsoft SQL

Hello,

I am trying to create a SQL connection using JDBC. I have added the sqljdbc.jar & sqljdbc4.jar files to the bin\ext folder. I am getting an error and I am not sure how to fix it. I have the correct driver but it is not seeing it...

Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String: jdbc:sqlserver://ServerName;databaseName=DBName;user=un;password=pw

Error: 2013-09-17 09:56:05 - Error getting response; java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

6 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    12 years ago
    I think error message is clear - it is not supported with jre 1.7. May be you can try with jre 1.6.
  • cwlovell13's avatar
    cwlovell13
    Occasional Contributor
    12 years ago
    "Use the sqljdbc4.jar class library, which provides support for JDBC 4.0."

    I have sqljdbc4.jar in the ext folder, but it tells me to use it???

    EDIT: Also changing things like my JRE version is a PITA because the company I am contracting for has insane IT policies that block me from installing or updating\rolling back anything...
  • nmrao's avatar
    nmrao
    Community Hero
    12 years ago
    Only place expected jar file under SOAPUI_HOME/bin/ext, and remove other file and try.
  • redfish4ktc2's avatar
    redfish4ktc2
    Super Contributor
    12 years ago
    yes, if you have several jars for the same driver, you cannot be sure which driver version will be used (usually, it uses classes in the jar that appears at the first place regarding the alphabetic order)