I'm trying to connect to a database (SQL Server 2008) via the jTDS driver. (Running MacOSX 10.8.3.) PyCharm downloads automatically version 1.3. Connecting to the DB fails because:
Connection to Exception in thread "main" java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
The error seems to pop up because the jdk I have installed (1.6) is incompatible with the jTDS driver version.
Fair enough. I updated my java (jdk 1.7) and set the java home variable to point to the new location. I also verified that the symbolic link in /usr/local/bin was updated by checking the version at the command line.
Yet the error persists.
Is there any way to make this work?
As an aside, I'd also like to point out that having to upgrade my java JUST to support a new DB driver kind of irks me (if this is the case, which it seems to be). It would be nice if I could just use one of the half-dozen jTDSs that I already have downloaded, and which provide fine DB connectivity. But the UI gives me no other option. Also there may be a bug in this widget, the error messages persist in the UI as I navigate through the tabs "Database", "Schema & Tables", etc., see shot below: