• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Deployment on Linux (jdbc driver pb)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Follow-Ups:
    • Re: Deployment on Linux (jdbc driver pb)
      • From: Kieran Kelleher <email@hidden>
References: 
 >Deployment on Linux (jdbc driver pb) (From: Jean Pierre Malrieu <email@hidden>)
 >Re: Deployment on Linux (jdbc driver pb) (From: Paul Yu <email@hidden>)
 >Re: Deployment on Linux (jdbc driver pb) (From: Jean Pierre Malrieu <email@hidden>)
 >Re: Deployment on Linux (jdbc driver pb) (From: Pascal Robert <email@hidden>)
 >Re: Deployment on Linux (jdbc driver pb) (From: Jean Pierre Malrieu <email@hidden>)

  • Prev by Date: Re: ERREST response and NSDictionary
  • Next by Date: Re: one last Eclipse mystery... can't connect to any database.
  • Previous by thread: Re: Deployment on Linux (jdbc driver pb)
  • Next by thread: Re: Deployment on Linux (jdbc driver pb)
  • Index(es):
    • Date
    • Thread