Hi, it seems it was not a real bug. If you are on linux, pay attention
to the default character encoding "character-set-server": utf8mb4 is not
compatible with Apache Syncope >2.0.3.
BTW, I think your DataIntegrityViolation is not due to the problem above.
I've just been able to replicate your issue by using MariaDB 10.0 and
Java connector 1.5.9.
It seems that there are a sort of incompatibility that affect certain
insert statement.
I solved the problem by changing the java connector version: MariaDB
10.0 and JConnector 1.4.6 seem to work fine together.
Please, find your compatible versions, drop and recreate your db and
check it out again.
Best regards,
F.
Il 10/04/2017 16:50, Fabio Martelli ha scritto:
Hi, it seems we have a bug.
See the issue [1]; it will be solved ASAP.
Thank you for reporting.
Regards,
F.
[1] https://issues.apache.org/jira/browse/SYNCOPE-1065
Il 10/04/2017 12:35, Tech ha scritto:
Dear experts,
We are working with the Syncope 2.0.3-SNAPSHOT, we are doing nothing
but changing the default database, from Postgres to MariaDB.
We compile and we start a brand new Syncope deployment with a new
empty database.
We are able to create users, but we every time we try to create a new
Type, we get an error "DataIntegrityViolation [The transaction has
been rolled back.." and we cannot add any other type.
Have you any idea why this could happen?
--
Fabio Martelli
https://it.linkedin.com/pub/fabio-martelli/1/974/a44
http://blog.tirasa.net/author/fabio/index.html
Tirasa - Open Source Excellence
http://www.tirasa.net/
Apache Syncope PMC
http://people.apache.org/~fmartelli/
