syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chuck Messenger (JIRA)" <>
Subject [jira] [Commented] (SYNCOPE-1284) Maven install for MSSQL using postgres-style DDL
Date Tue, 20 Mar 2018 17:26:00 GMT


Chuck Messenger commented on SYNCOPE-1284:

Yes, that fixed that problem.  Started from a clean database.  Unfortunately, now when I
try and make a connector, no bundles show up in the bundles list, despite all the bundles
being in the directory which is indicated in the topology.

> Maven install for MSSQL using postgres-style DDL
> ------------------------------------------------
>                 Key: SYNCOPE-1284
>                 URL:
>             Project: Syncope
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 2.0.7
>         Environment: Windows 10 Enterprise, Apache Tomcat 8.5.27, Java 8, SQL Server
>            Reporter: Chuck Messenger
>            Priority: Major
>         Attachments:,
> Set up a new maven build of Syncope and made the documented changes to
and, but DDL which executes on startup is erroring because the DDL
being executed is Oracle or postgres-style DDL, not MSSQL.  So there is either an undocumented
change that needs to made to the configuration or something is broken.  Piece of the stack
> Caused by: <openjpa-2.4.2-r422266:1777108 nonfatal general error> org.apache.openjpa.persistence.PersistenceException:
Column, parameter, or variable #2: Cannot find data type BLOB. \{stmnt 658558941 CREATE TABLE
AccessToken (id VARCHAR(255) NOT NULL, authorities BLOB, body CLOB, expiryTime TIMESTAMP,
owner VARCHAR(255), PRIMARY KEY (id))} [code=2715, state=S0006]
>  at org.apache.openjpa.jdbc.meta.MappingTool.record(
>  at org.apache.openjpa.jdbc.meta.MappingTool.record(
> This also happens with the DDL update script to the AccessToken table when trying to
connect to an existing schema.

This message was sent by Atlassian JIRA

View raw message