Re: Deployment on Linux (jdbc driver pb)
Re: Deployment on Linux (jdbc driver pb)
- Subject: Re: Deployment on Linux (jdbc driver pb)
- From: James Cicenia <email@hidden>
- Date: Mon, 16 Jul 2012 12:49:41 -0400
Does this also work with ERTags and Attachments? I converted a database that was also all lowercase and those tables got added redundantly with camel case. I basically copied the data from the lower case to the upper case tables and it worked, but in the future, I would prefer not to do that.
Regards
James
On Mon, Jul 16, 2012 at 11:27 AM, Kieran Kelleher
<email@hidden> wrote:
This is the setting I use in my.cnf (read the comments, especially last line before trying this)
<snip>
# If set to 0, table names are stored as specified and comparisons are case
# sensitive. If set to 1, table names are stored in lowercase on disk and
# comparisons are not case sensitive. If set to 2, table names are stored as given
# but compared in lowercase. This option also applies to database names and table
# aliases. For additional information, see Section 8.2.2, “Identifier Case
# Sensitivity”.
# You should not set this variable to 0 if you are running MySQL on a system that
# has case-insensitive file names (such as Windows or Mac OS X). If you set this
# variable to 0 on such a system and access MyISAM tablenames using different
# lettercases, index corruption may result. On Windows the default value is 1. On
# Mac OS X, the default value is 2.
# If you are using InnoDB tables, you should set this variable to 1 on all
# platforms to force names to be converted to lowercase. Prior to MySQL Cluster
# NDB 6.3.35, MySQL Cluster NDB 7.0.15, and MySQL Cluster NDB 7.1.4, this is also
# true for tables using the NDB storage engine.
# KK: We want setting of 1 for innodb and linux compatability
# KK: Do not change this to 1 without first changing the actual table names to lower case first
lower_case_table_names = 1
</snip>
Also here is a simple *quick hack* script for converting a database's tables all to lowercase names. Understand it and take necessary precautions before using:
HTH, Kieran
On Jul 16, 2012, at 9:48 AM, Jean Pierre Malrieu wrote:
> Thank you both. It works.
> Now discovering that on UNIX, mysql table name are case sensitive... Grrrr!
>
> Le 16 juil. 2012 à 15:00, Pascal Robert a écrit :
>
>>
>> Le 2012-07-16 à 08:58, Jean Pierre Malrieu a écrit :
>>
>>> Meaning you add it directly in the "Libraries" folder and ant build picks it up?
>>
>> Yes.
>>
>>> Le 16 juil. 2012 à 14:26, Paul Yu a écrit :
>>>
>>>> I embed the jdbc library in my app bundle,
>>>>
>>>> Sent from my iPad
>>>>
>>>> On Jul 16, 2012, at 8:07 AM, Jean Pierre Malrieu <email@hidden> wrote:
>>>>
>>>>> Hi,
>>>>>
>>>>> I am trying my first deployment on LINUX, and thanks to the instructions in the wiki, things seem to work more or less (application deployed and launched).
>>>>> But I have got an exception (cannot obtain database channel) when trying to talk to mysql.
>>>>> I have installed the jdbc driver, but how do I tell the app where to find it?
>>>>>
>>>>> TIA
>>>>>
>>>>> JPM
>>>>> _______________________________________________
>>>>> Do not post admin requests to the list. They will be ignored.
>>>>> Webobjects-dev mailing list (email@hidden)
>>>>> Help/Unsubscribe/Update your Subscription:
>>>>>
>>>>> This email sent to email@hidden
>>>
>>>
>>> _______________________________________________
>>> Do not post admin requests to the list. They will be ignored.
>>> Webobjects-dev mailing list (email@hidden)
>>> Help/Unsubscribe/Update your Subscription:
>>>
>>> This email sent to email@hidden
>>
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden