Actions
task #10109
openInvestigate best practice for HQL with enumset
Start date:
Due date:
% Done:
0%
Estimated time:
Severity:
normal
Description
Sine #7957 we use EnumSets as types. Hibernate mapping is implemented in EnumSetUserType class. The open issue here is how to handle EnumSets best in HQL queries.
Typical "contains()" syntax does not work, also LIKE does not work as it is stored as a String but it is not a String.
Is there a possibility to adapt the EnumSetUserType to allow such queries or is there another workaround like using patially native SQL? Or is it not possible and we do have to filter the result afterwards as described in #10084#note-3.
Related issues
Updated by Andreas Müller over 1 year ago
- Copied from bug #10084: Adding a new specimen to character matrix fails added
Updated by Andreas Müller over 1 year ago
- Related to feature request #7957: Add types for taxon description (as EnumSet) added
Updated by Andreas Müller over 1 year ago
- Related to feature request #9026: Implement Feature.supportedDataTypes as EnumSet added
- Related to feature request #9027: Implement Feature.availableFor added
Actions