[cas-user] Cas 5.0.10 jpa-service-registry with oauth-webflow throws Field 'id' doesn't have a default value

[Man H]

Hi,

After installing maven overlay, adding jpa-service-registry with
oauth-webflow support throws following message:

Hibernate: insert into RegexRegisteredService (access_strategy,
attribute_release, description, evaluation_order, logo, logout_type,
logout_url, mfa_policy, name, proxy_policy, public_key, required_handlers,
serviceId, theme, username_attr, expression_type) values (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, 'oauthcba')
2017-11-07 18:36:02,184 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <SQL Error: 1364,
SQLState: HY000>
2017-11-07 18:36:02,184 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper] - <Field 'id' doesn't
have a default value


Overlays relevant pom lines:

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-jdbc</artifactId>
            <version>${cas.version}</version>
        </dependency>

        <dependency>
        <groupId>org.apereo.cas</groupId>
        <artifactId>cas-server-support-json-service-registry</artifactId>
        <version>${cas.version}</version>
        </dependency>

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-jpa-service-registry</artifactId>
            <version>${cas.version}</version>
        </dependency>

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-audit-jdbc</artifactId>
            <version>${cas.version}</version>
        </dependency>

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-jdbc-monitor</artifactId>
            <version>${cas.version}</version>
        </dependency>

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-saml</artifactId>
            <version>${cas.version}</version>
            <exclusions>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-attribute-filter-api</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.liberty</groupId>
                    <artifactId>idwsfconsumer</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-attribute-api</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-attribute-resolver-api</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-core</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-installer</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-profile-impl</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-profile-spring</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-saml-api</artifactId>
                </exclusion>
                <exclusion>
                    <groupId>net.shibboleth.idp</groupId>
                    <artifactId>idp-saml-impl</artifactId>
                </exclusion>
            </exclusions>
        </dependency>

        <dependency>
            <groupId>org.apereo.cas</groupId>
            <artifactId>cas-server-support-oauth-webflow</artifactId>
            <version>${cas.version}</version>
        </dependency>


RegexRegisteredService`

CREATE TABLE `RegexRegisteredService` (
  `expression_type` varchar(15) NOT NULL DEFAULT 'ant',
  `id` bigint(20) NOT NULL,
  `access_strategy` longblob,
  `attribute_release` longblob,
  `description` varchar(255) NOT NULL,
  `evaluation_order` int(11) NOT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `logout_type` int(11) DEFAULT NULL,
  `logout_url` varchar(255) DEFAULT NULL,
  `mfa_policy` longblob,
  `name` varchar(255) NOT NULL,
  `proxy_policy` longblob,
  `public_key` longblob,
  `required_handlers` longblob,
  `serviceId` varchar(255) NOT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `username_attr` longblob,
  `bypassApprovalPrompt` bit(1) DEFAULT NULL,
  `clientId` varchar(255) DEFAULT NULL,
  `clientSecret` varchar(255) DEFAULT NULL,
  `generateRefreshToken` bit(1) DEFAULT NULL,
  `jsonFormat` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
You received this message because you are subscribed to the Google Groups "CAS 
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to cas-user+unsubscr...@apereo.org.
To view this discussion on the web visit 
https://groups.google.com/a/apereo.org/d/msgid/cas-user/CAMY5mic-Gq%3DOSaMX_h1vtfmWcDRDqxOOqfkNZ6n19xU5tB4-fA%40mail.gmail.com.