When trying to install or upgrade UVMS to version 6.10.x with a Java version lower than Java 8, it will fail with the kind of errors below :
Exception in thread "main" java.lang.UnsupportedClassVersionError: org/apache/derby/tools/ij : Unsupported major.minor version 52.0
Exception in thread "main" org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'dbPurgeManager': Unsatisfied dependency expressed through field 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [datasource-local-config.xml]: Cannot resolve reference to bean 'centralEntityManagerFactory' while setting bean property 'entityManagerFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'centralEntityManagerFactory' defined in class path resource [datasource-local-config.xml]: Invocation of init method failed; nested exception is java.lang.UnsupportedClassVersionError: org/dom4j/DocumentException : Unsupported major.minor version 52.0
Invocation of init method failed; nested exception is java.lang.UnsupportedClassVersionError: org/dom4j/DocumentException : Unsupported major.minor version 52.0
If the product is started after upgrading avoiding these errors, some tables will be missing and Errors will be displayed in the log as follows:
Table/View 'UNI_UV_DPL_TRANSLAT' does not exist.
Table/View 'UNI_UV_DPL_TRANSLAT_TABLE' does not exist.
Table/View 'UNI_UV_USERSETTINGS' does not exist.
Table/View 'UNI_TELEMETRY' does not exist.
Caused by: java.sql.SQLSyntaxErrorException: Column 'NOTIFICATI1_.EMAIL_NOTIFICATION' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NOTIFICATI1_.EMAIL_NOTIFICATION' is not a column in the target table.
Dollar Universe 6.10.x Products (UVMS / UVC / Reporter / DUX / Manager for Java ) do not support Java 6 or Java 7 so the installation or upgrade fails when executing the database create or update scripts.
Extract from the Compatibility Matrix:
Release : 6.10.x and superior
Component : Univiewer Management Server (UVMS)
Upgrade to Java 8 prior to performing the installation or upgrade of the UVMS 6.10.x or superior.
In case the upgrade is performed, the UVMS database tables will not be upgraded and you will need to rollback to the previous backup in order to attempt the upgrade with Java 8.
To do so, please follow the steps explained here