Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4B648C0B.3010906@brighton.ac.uk>
Date: Sat, 30 Jan 2010 19:44:11 +0000
From: John English <je@brighton.ac.uk>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB;
 rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: Problem upgrading to 10.5.3: column named "xml"
References: <4B632124.1070702@brighton.ac.uk> <4B6324D2.80002@sun.com>
In-Reply-To: <4B6324D2.80002@sun.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 29/01/2010 18:11, Rick Hillegas wrote:
> John English wrote:
>> I've tried surrounding the name XML in double quotes ("xml") but that
>> doesn't work.
 >
> Hi John,
>
> Have you tried uppercasing as well as doublequoting the column name.
> E.g., "XML" rather than "xml"?

That is *exactly* the solution. I always write my column names in lower
case since SQL is generally case-insensitive, but of course everything
is stored internally in uppercase, so "xml" doesn't work while "XML"
does. I am once again a happy bunny!

Many thanks for the use of your wisdom,

----------------------------------------------------------------------
  John English              | mailto:je@brighton.ac.uk
  Senior Lecturer           | http://www.it.bton.ac.uk/staff/je
  School of Computing & MIS | "Those who don't know their history
  University of Brighton    |  are condemned to relive it" (Santayana)
----------------------------------------------------------------------