Database error messages are uninformative when using Hypersonic

• Type: Improvement
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP3 (5.2.7)
• Component/s: Environments > Databases
• Labels: None
• Environment: All

Database error messages are uninformative when using Hypersonic because of a logging bug in the Hypersonic driver. The returned message in any failed operation is always "failed batch".

To address this issue, the suggested value for hibernate.jdbc.batch_size in portal(-ext).properties when using Hypersonic is now 0. Turning off batching uses another error report mechanism inside of Hypersonic where you will return the actual error message. The documentation in portal.properties has been updated to reflect this new recommendation.