BestDesigns.Co.in

If anyone has run into a situation where sql queries from your java app were erroring out because of letter case in tables and column names in MySQL database, I have a quick solution for you.

First, what you should have done, but probably was too creative and used mixed case for creating table names/columns was,

If going back and modifying code is too much, there is a quick fix for UNIX/Linux side. As the article above states, you need to set lower_case_table_names property to 1.

Simply create file /etc/my.cnf or if already created then only add the variable there thus:

[mysqld]
lower_case_table_names=1

Then restart the mysql service on the server.

As a result your java app will be able to query against MySQL tables and ignore letter case, the same way it does on Windows.