The Essential Project Forum

Attempting a muti-user install. Have the client up and running and connecting to a SQL Server 2014 Express database.

For the server:
Java version - Amazon Corretto
openjdk version "1.8.0_202"
OpenJDK Runtime Environment Corretto-8.202.08.1 (build 1.8.0_202-b08)
OpenJDK 64-Bit Server VM Corretto-8.202.08.1 (build 25.202-b08, mixed mode)

Database driver:
Microsoft 4.2 driver from https://docs.microsoft.com/en-us/sql/co ... erver-2017

On server startup running:
C:\Program Files\Protege_3.5>.\run_protege_server.bat


Protege server is starting...
Protege 3.5 Build 663, JVM 1.6.0_26-b03, memory=506M, Windows 7, encoding=UTF-8, language=en, country=US
Server port = 0, registry port = 1099, compressed stream
Using metaproject from: file:/C:/Program%20Files/Protege_3.5/examples/server/metaproject.pprj
WARNING: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0 -- java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0

The warning then escalates to

WARNING: Unable to load knowledgebase jdbc:sqlserver://localhost:1433;databaseName=EnterpriseArchitect -- java.lang.RuntimeException: class not found: com.microsoft.sqlserver.jdbc.SQLServerDriver

WARNING: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0 -- java.lang.UnsupportedClassVersionError: com/microsoft/sqlserver/jdbc/SQLServerDriver : Unsupported major.minor version 52.0

And eventually:

SEVERE: server startup failed -- java.lang.RuntimeException: class not found: com.microsoft.sqlserver.jdbc.SQLServerDriver


Any pointers?

Hi,

Thanks for posting.

Normally, there are 2 versions of the JDBC driver that you can use - and this makes a difference depending on which Java runtime that you.

Are you using 'sqljbdc.jar' or 'sqljdbc4.jar'?

As you're running with Java 8, you should be using sqljdbc4.jar. The simplest way to use this is to copy it into 'driver.jar' in the Protege root directory. Make sure to remove 'sqljbdc.jar' from the Protege root folder to avoid any clashes

Jonathan

Thanks. I don't have the other sql server driver so downloaded the jTDS driver and it works.