[SYNCOPE-1284] Maven install for MSSQL using postgres-style DDL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 2.0.7
• Component/s: core
• Environment: Windows 10 Enterprise, Apache Tomcat 8.5.27, Java 8, SQL Server 2014
• Assignee: Unassigned
• Reporter: Chuck Messenger
• Created: 19/Mar/18 16:50
• Updated: 21/Mar/18 07:42
• Resolved: 21/Mar/18 07:42

Description

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.