Symptoms

There may be a small performance hit due to the workaround described in Unable to Move Pages - Tree is Not Displayed in Edit Mode Due to DB Case Sensitivity.

- url: /pages/children.action | userName: ******** | action: children | space: 13205506
ognl.OgnlException: JSONString [org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: Invalid column name 'title'.

Cause

Queries that use 'lower' do not use index because of case sensitivity.

Resolution

Set the database collation to case-insensitive. Be aware that some complications could arise later down the track if you use case-insensitive database collation during migration. For more information, please refer to the Migrate to Another Database document in the Confluence documentation space.