MS SQL JDBC Issues

Hi,

I am trying to migrate from the internal DB to an external MS SQL one, following the steps in the documentation.

While trying to run the maintainDB script, I get a Java version error:

Unable to load JDBC driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver, due to exception: java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0 

This suggests that the machine has the wrong version of java installed. It is currently running Java 8 which corresponds to the driver I have downloaded from MS (sqljdbc_6.0.8112.100_enu.tar contains the jar sqljdbc42). Also, TeamCity has been running on this machine for awhile, suggesting that Java is working properly,

I am running this on OS X Sierra, obviously trying to connect to a Windows server. Has anyone had any issues with these JDBC drivers? Any ideas where I should be looking to solve this issue? I am sure there will be authentication issues, however it seems I can't even _attempt_ a connection yet.

I've tried older Java 8 versions of the driver, and the latest. Any pointers would be greatly appreciated.

0
1 comment

Hi Oliver,

I haven't been able to find many instances of this issue. Which TeamCity version are you running? The -42 jar is only thought for java 8, so if your teamcity version isn't running java 8 it won't work.

0

Please sign in to leave a comment.