On 26/04/2017 19:16, Tech wrote:
Hello,
using the Syncope 203, when we try to add a new type, we get this
error at the moment of saving the change.
Here we just try to add an additional email with an EmailValidator,
but this happen with any new field that we try to add.
Regars
[...]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException:
(conn:34) Incorrect arguments to mysqld_stmt_execute
Query is: INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?), parameters
['psy_p_emailWork',<null>,<null>,<Buffer:''>,<Buffer:''>,'false',<null>,0,0,<null>,'String',0,'org.apache.syncope.core.persistence.jpa.attrvalue.validation.EmailAddressValidator',<null>]
{prepstmnt 894668994 INSERT INTO PlainSchema (id, cipherAlgorithm,
conversionPattern, enumerationKeys, enumerationValues,
mandatoryCondition, mimeType, multivalue, readonly, secretKey, type,
uniqueConstraint, validatorClass, ANYTYPECLASS_ID) VALUES (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=1210, state=HY000]
Just google a bit and you will find that such error is often caused by
some versions of the MySQL JDBC driver (I assume that is applicable to
MariaDB) as well.
More generally, I do believe that most of the troubles you are
experiencing lately are due to bad MySQL / MariaDB versions, tuning and
configuration, as your errors are hardly reproducible with recent
versions of MySQL, MariaDB or their respective JDBC drivers.
Regards.
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Member at The Apache Software Foundation
Syncope, Cocoon, Olingo, CXF, OpenJPA, PonyMail
http://home.apache.org/~ilgrosso/