Product: Confluence
Environment
| Operating System | |
|---|---|
| Affect Version/s | |
| JVM | |
| Database | MySQL 4.1.x |
| Application Server | Tomcat 5.5.x |
Error Message
2007-11-27 04:59:01,724 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.BANDANA' doesn't exist 2007-11-27 04:59:01,724 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.BANDANA' doesn't exist 2007-11-27 04:59:01,728 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.BANDANA' doesn't exist 2007-11-27 04:59:01,728 ERROR [main] [sf.hibernate.util.JDBCExceptionReporter] logExceptions Table 'confluence.BANDANA' doesn't exist
Symptom
When checking the database, the table bandana does exist!
The connection details to the database (which can be found in the confluence.cfg.xml file) are also correct.
Diagnostics/Test
Connect to the database using your sql client. Run the query
select * from BANDANA;
which will fail with an error that the table doesn't exist, however the query
select * from bandana;
will return the rows as expected.
Root Cause
Your database is case sensitive.
Solution
You will need to make your database case insensitive. For MySQL the instructions can be found in this article.