You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Christina Kaskoura <Ch...@eurodyn.com> on 2010/09/06 10:09:02 UTC

Names of db tables created by jackrabbit

Hello,

I am using jackrabbit with a MySQL db and I noticed that while in 
Windows the names of the tables created by jackrabbit in the db are all 
lower case, in MacOS some table names are upper case while others are 
lower case. From a functionality point of view there is no problem with 
that, since there are no errors resulting from this difference in table 
names, but I would like to have all the tables in lower case for 
consistency reasons.
Does anyone know why this happens and if there is a way to control the 
case of the table names?

Thank you,
Christina


Re: Names of db tables created by jackrabbit

Posted by Christina Kaskoura <Ch...@eurodyn.com>.
James Abley wrote:
> On 6 September 2010 09:09, Christina Kaskoura <
> Christina.Kaskoura@eurodyn.com> wrote:
>
>   
>> Hello,
>>
>> I am using jackrabbit with a MySQL db and I noticed that while in Windows
>> the names of the tables created by jackrabbit in the db are all lower case,
>> in MacOS some table names are upper case while others are lower case. From a
>> functionality point of view there is no problem with that, since there are
>> no errors resulting from this difference in table names, but I would like to
>> have all the tables in lower case for consistency reasons.
>> Does anyone know why this happens and if there is a way to control the case
>> of the table names?
>>
>> Thank you,
>> Christina
>>
>>
>>     
> MySQL config - this is probably due to having a case-sensitive filesystem.
> From a backup and restore perspective, it may be easier to use the same
> names in all environments.
>
> You can configure MySQL to lower-case all table names.
>
> http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
>
> Cheers,
>
> James
>
>   
Hello James.
Thanks for your answer. It's true that I can use this property in MySQL, 
however I was wondering if there is a way to control the case of the 
table names from the jackrabbit end, so that it can be ported to any 
database, even in ones which may not have a relative property. Is there 
a specific reason why jackrabbit uses this casing in the table names?
Christina


Re: Names of db tables created by jackrabbit

Posted by James Abley <ja...@gmail.com>.
On 6 September 2010 09:09, Christina Kaskoura <
Christina.Kaskoura@eurodyn.com> wrote:

> Hello,
>
> I am using jackrabbit with a MySQL db and I noticed that while in Windows
> the names of the tables created by jackrabbit in the db are all lower case,
> in MacOS some table names are upper case while others are lower case. From a
> functionality point of view there is no problem with that, since there are
> no errors resulting from this difference in table names, but I would like to
> have all the tables in lower case for consistency reasons.
> Does anyone know why this happens and if there is a way to control the case
> of the table names?
>
> Thank you,
> Christina
>
>
MySQL config - this is probably due to having a case-sensitive filesystem.
>From a backup and restore perspective, it may be easier to use the same
names in all environments.

You can configure MySQL to lower-case all table names.

http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

Cheers,

James