[
https://issues.apache.org/jira/browse/SYNCOPE-1065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò closed SYNCOPE-1065.
-------------------------------------------
Resolution: Cannot Reproduce
I was not able to reproduce this issue, with both MariaDB 10.0 and 10.1 on
Linux 64 bit.
Please be sure to follow the [indications for deploying on
MariaDB|http://syncope.apache.org/docs/reference-guide.html#mariadb]; in
particular
{code}
Master.databasePlatform=org.apache.openjpa.jdbc.sql.MariaDBDictionary(blobTypeName=LONGBLOB)
{code}
> Failure deploying with mysql/mariadb as internal storage
> --------------------------------------------------------
>
> Key: SYNCOPE-1065
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1065
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 2.0.3
> Environment: Real environment with MySQL/MariaDB as internal storage
> Reporter: fabio martelli
> Assignee: Francesco Chicchiriccò
>
> At DB initialization time the following exception is raised.
> Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: (conn:70)
> Specified key was too long; max key length is 767 bytes
> Query is : CREATE TABLE AccessToken (id VARCHAR(255) NOT NULL, body TEXT,
> expiryTime DATETIME, owner VARCHAR(255), PRIMARY KEY (id)) ENGINE = innodb
> {stmnt 131207471 CREATE TABLE AccessToken (id VARCHAR(255) NOT NULL, body
> TEXT, expiryTime DATETIME, owner VARCHAR(255), PRIMARY KEY (id)) ENGINE =
> innodb} [code=1071, state=42000]
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)