Oct 2nd, 2008, 11:02 AM
org.springframework.jdbc.BadSqlGrammarException: acl_sid doesn't exist
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:
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