java.sql.SQLSyntaxErrorException: Invalid default value for 'creationDate'

[Vitaliy-1]

Greetings,
I am trying to deploy wombat, rhino and content-repo on tomcat using Quickstart Guide and get problems with the latter.
Receive the following error:
Error creating bean with name 'sqlService' defined in org.plos.repo.config.SpringConfig: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.plos.repo.service.SqlService]: Factory method 'sqlService' threw exception; nested exception is java.sql.SQLSyntaxErrorException: Invalid default value for 'creationDate'
Using latest mysql connector (maybe problem is in it? if so what version is preferred? )

just in case my context.xml:

<Resource name="jdbc/AmbraDS"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            validationQuery="SELECT 1"
            testOnBorrow="true"
            driverClassName="com.mysql.jdbc.Driver"
            username="root"
            password="*"
            url="jdbc:mysql://localhost:3306/ambra?useLegacyDatetimeCode=false&amp;serverTimezone=UTC&amp;useSSL=false"/>

  <!-- Local Crepo -->
  <Resource name="ambra/FileStore"
            type="org.ambraproject.filestore.FileStoreService"
            factory="org.ambraproject.filestore.impl.ContentRepoFactory"
            repoServer="http://localhost:8081"
            bucketName="corpus"/>

  <Resource name="repo/objectStore"
            type="org.plos.repo.service.ObjectStore"
            factory="org.plos.repo.config.FileSystemStoreFactory"
            dataDirectory="/etc/ambra/crepo_datastore"/> <!--crepo datastore directory. See the Quickstart-Guide - "Compiling Content Repo (crepo)" -->

  <Resource name="jdbc/repoDB"
            auth="Container"
            type="javax.sql.DataSource"
            factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
            validationQuery="SELECT 1"
            testOnBorrow="true"
            driverClassName="com.mysql.jdbc.Driver"
            username="root"
            password="*"
            url="jdbc:mysql://localhost:3306/repo?useLegacyDatetimeCode=false&amp;serverTimezone=UTC&amp;useSSL=false"/>

[sjtower]

Hi Vitaly,
Have you installed mysql and created the ambra database based on the schema we provide?
We don't have any columns with the name "creationDate" so it seems like something is wrong with the database schema you are using.
edit: sorry, didn't realize this problem is with the repo database, not the ambra database. I will look into this further.

[Lory9098]

bro is not gonna look into this further 🙏