Build fails because of the version of tools

[chytonpide]

Couldn't download libraries when building project with Gradle v2.3 and Java7

Maven central discontinued support for TLSv1.1 and below. Gradle v2.3 with Java7 used in the project use TLSv1.1 so it is needed to use Gradle version 4.8.1 and above or Java8 and above that supports TLSv1.2.

Available options

• Use gradlew version 4.8.1 and above.(from v4.8.1 to 6.9.2 available. on v7.0 and above, the build script needs to be changed.)
• Use Java8.
  • The version of spring needs to be changed to v3.2.18.

mysql-connector-java v5.1.6 is not compatible with MySQL latest image(v8.0.28) on docker

It is needed to use a compatible version of MySQL with mysql-connector-java.

Available options

• Use MySQL v5.7; specify the version of MySQL on the line that runs the docker container in the setup script.
• Use MySQL latest image on docker with mysql-connector-java v8.0.28.
  • The column data type on collaboration.sql needs to be changed from varchar(65000) to text or specify charset as latin1 when creating DB because MySQL v8.0.28 default database charset is utf8mb4.
  • AbstractQueryService needs to be changed to use ResultSet.TYPE_SCROLL_SENSITIVE as resultSetType.

Summary

Every combination of available options passed all tests except two SlotMQ tests. The combination of using Java7, MySQL v5.7, and Gradle v4.8.1 is the minimum change. Using Java8 needs to change the Spring dependency of the version to v3.2.18. Using MySQL v8.0.28 needs to change "collaboration.sql" and AbscractQueryService.