syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chuck Messenger (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SYNCOPE-1284) Maven install for MSSQL using postgres-style DDL
Date Mon, 19 Mar 2018 17:14:00 GMT

     [ https://issues.apache.org/jira/browse/SYNCOPE-1284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Chuck Messenger updated SYNCOPE-1284:
-------------------------------------
    Attachment: Master.properties

> Maven install for MSSQL using postgres-style DDL
> ------------------------------------------------
>
>                 Key: SYNCOPE-1284
>                 URL: https://issues.apache.org/jira/browse/SYNCOPE-1284
>             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
2014
>            Reporter: Chuck Messenger
>            Priority: Major
>         Attachments: Master.properties, provisioning.properties
>
>
> Set up a new maven build of Syncope and made the documented changes to Master.properties
and provisioning.properties, 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
trace:
> 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(MappingTool.java:571)
>  at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:467)
>  
> 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
(v7.6.3#76005)

Mime
View raw message