Difference between revisions of "Implementing Devolved Constraints"

From MyWiki
Jump to: navigation, search
Line 3: Line 3:
 
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver<br>
 
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver<br>
 
''Requires a Java Runtime Environment (JRE) 7.0. Using JRE 6.0 or lower will throw an exception.''<br>
 
''Requires a Java Runtime Environment (JRE) 7.0. Using JRE 6.0 or lower will throw an exception.''<br>
 +
Looks like we need version 4 of the jdbc connector : https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix#java-and-jdbc-specification-support<br>
 
# Install the connector in the "lib" folder in the Tomcat Shibboleth application
 
# Install the connector in the "lib" folder in the Tomcat Shibboleth application
 
# Modify the CLASSPATH variable to include the connector
 
# Modify the CLASSPATH variable to include the connector

Revision as of 11:36, 31 January 2018

  1. Download the jdbc connector for Microsoft SQL Server

The oldish version of java on the server might cause a compatibility issue as the java version is 6 :
see https://docs.microsoft.com/en-us/sql/connect/jdbc/system-requirements-for-the-jdbc-driver
Requires a Java Runtime Environment (JRE) 7.0. Using JRE 6.0 or lower will throw an exception.
Looks like we need version 4 of the jdbc connector : https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix#java-and-jdbc-specification-support

  1. Install the connector in the "lib" folder in the Tomcat Shibboleth application
  2. Modify the CLASSPATH variable to include the connector
  3. Perform a re-install of Shibboleth using the install script
  4. Edit the Shibboleth config files

Useful link - https://wiki.shibboleth.net/confluence/display/SHIB2/ResolverRDBMSDataConnector