Re: Table case in CreateIfNoSchemaStrategy causes problems [3.1M4-SNAPSHOT]

2011-12-19 Thread Andrus Adamchik
Maybe try DataMap.setQuotingSQLIdentifiers(true) - this should ensure case sensitive operation of the strategy IIRC. Cheers, Andrus On Dec 15, 2011, at 9:37 AM, Kevin Meyer - KMZ wrote: > By default HSQLDB converts all table names and field names to upper > case, and is case sensitive on SELEC

Re: Table case in CreateIfNoSchemaStrategy causes problems [3.1M4-SNAPSHOT]

2011-12-15 Thread Michael Gentry
Thanks Kevin! On Thu, Dec 15, 2011 at 9:37 AM, Kevin Meyer - KMZ wrote: > By default HSQLDB converts all table names and field names to upper > case, and is case sensitive on SELECTS. > > I've created JIRA CAY-1645. I'm not sure about which component or > type, so I chose Task and left the compon

Re: Table case in CreateIfNoSchemaStrategy causes problems [3.1M4-SNAPSHOT]

2011-12-15 Thread Kevin Meyer - KMZ
By default HSQLDB converts all table names and field names to upper case, and is case sensitive on SELECTS. I've created JIRA CAY-1645. I'm not sure about which component or type, so I chose Task and left the component blank. Regards, Kevin On 15 Dec 2011 at 8:56, Michael Gentry wrote: > Hi

Re: Table case in CreateIfNoSchemaStrategy causes problems [3.1M4-SNAPSHOT]

2011-12-15 Thread Michael Gentry
Hi Kevin, I'm not familiar offhand with the case sensitivity of HSQLDB, but a JIRA would be nice so we can remember to explore it later. Thanks, mrg On Wed, Dec 14, 2011 at 12:31 AM, Kevin Meyer - KMZ wrote: > In CreateIfNoSchemaStrategy, I have run into problems with HSQLDB > and upper/mixed

Table case in CreateIfNoSchemaStrategy causes problems [3.1M4-SNAPSHOT]

2011-12-13 Thread Kevin Meyer - KMZ
In CreateIfNoSchemaStrategy, I have run into problems with HSQLDB and upper/mixed case table names. In particular, if I lower or mixed case my DBEntity name, the resulting tables are not found by CreateIfNoSchemaStrategy whenI use HSQLDB. I found that if I convert all table name checks to uppe