Re: How to set db property so that table name queries are case-insensitive?

2009-03-19 Thread Martijn Engler 
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names

I think you'll want to set it to 1

On Wed, Mar 18, 2009 at 22:15, David M. Karr davidmichaelk...@gmail.com wrote:
 Ubuntu 8.10.

 I was experimenting with the Spring Petclinic sample application, configured
 with MySQL.  I found that some of the tests were failing, apparently because
 of table name case-sensitivity issues.  I was able to fix some of the code
 references, but after that I hit other, probably for the same issue.  The
 tables were created with lower case names, but generated queries are using
 uppercase names.  I can't easily control how it generates the SQL (using
 Hibernate).

 I think I'd prefer to have table names be case-sensitive, but I guess for
 now I have to figure out how to disable that, at least for this database.

 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:
  http://lists.mysql.com/mysql?unsub=mart...@crystal-labs.nl



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

How to set db property so that table name queries are case-insensitive?

2009-03-18 Thread David M. Karr 

Ubuntu 8.10.

I was experimenting with the Spring Petclinic sample application, 
configured with MySQL.  I found that some of the tests were failing, 
apparently because of table name case-sensitivity issues.  I was able to 
fix some of the code references, but after that I hit other, probably 
for the same issue.  The tables were created with lower case names, but 
generated queries are using uppercase names.  I can't easily control how 
it generates the SQL (using Hibernate).


I think I'd prefer to have table names be case-sensitive, but I guess 
for now I have to figure out how to disable that, at least for this 
database.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org