rzo1 opened a new pull request, #221: URL: https://github.com/apache/openjpa/pull/221
Reported on #220 by @ilgrosso while testing Apache Syncope against 4.2.0-SNAPSHOT. A column declared with `columnDefinition = "jsonb"` (or `column-definition="jsonb"` in a mapping file) on PostgreSQL was generated as `jsonb(255)`, which the database rejects with `type modifier is not allowed for type "jsonb"`. The same happens for `json` on MySQL and MariaDB. `DBDictionary.appendSize()` appends the column length to a type name unless the type is in `fixedSizeTypeNameSet`. `PostgresDictionary` did not list `JSON` or `JSONB`, and `MySQLDictionary` and `MariaDBDictionary` did not list `JSON`. This change adds them. `MariaDBDictionary` keeps its own list, so it needs the change separately. Until this is released, the workaround is `openjpa.jdbc.DBDictionary=postgres(FixedSizeTypeNames=JSONB)`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
