HTTP Status 500 - org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence.BANDANA' doesn't exi

Question

howto resolve the issue in confluence..

Guilherme V. · Answer

Hi there,

The problem can be related to the collation of your database, please, check the Cause 2 of this site -> https://confluence.atlassian.com/confkb/upgrade-fails-java-sql-sqlexception-table-confluence-bandana-doesn-t-exist-due-to-case-sensitivity-123044020.html

Nic Brough -Adaptavist- · Answer

This means a damaged or unreachable database.

What did you do to provoke this error?