Sunday, November 20, 2011

case sensitivity

Hi all,

Last week when we were testing our hibernate-oracle application with mysql (mysql server running on linux server), some of our queries failed due to the case difference of some of the tables. The solution we did was to set a variable   value to 1 in /etc/my.cnf file. This makes mysql ignore the cases and hibernate was happy to run the queries.
Since I need to run the same application with cloud-sql instance, there is a probability that same problem could occour. Is there any workaround to avoid case-sensitivity in cloud-sql instance? A stitch in time might help me save nine :) .

---Thanks,
Abhishek

No comments:

Post a Comment