Hello,

I'm using spring security and mysql. On my MacOS-X system every thing works fine. On linux there is the following excption:

org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT id FROM acl_sid WHERE principal=? AND sid=?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Table 'oncillaStat.acl_sid' doesn't exist

When I look at the tables in mysql, the acl_sid table is in capital letters:
ACL_SID

It seems that the system works on MacOS-X because the mysql system variable "lower_case_table_names" is set to 2, so mysql isn't case sensitive anymore. On linux it's set to 0, so case sensitive.

I guess spring-security creates ACL_SID in capital letters and tries to access them as acl_sid