db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Problem upgrading to 10.5.3: column named "xml"
Date Fri, 29 Jan 2010 18:11:30 GMT
Hi John,

Have you tried uppercasing as well as doublequoting the column name. 
E.g., "XML" rather than "xml"?

Thanks,
-Rick

John English wrote:
> I am trying to upgrade an old app (v8 or 9) to 10.5.3 but have run up
> against a serious problem. The DB contains several tables with columns
> called XML, which is now a reserved word in v10.x. These cause SQL
> exceptions when the app tries to access them.
>
> The older version of Derby that the app currently uses doesn't support
> column renaming, so I can't change the existing tables in situ, and as
> it's a live system I can't afford to just recreate the tables.
>
> I've tried surrounding the name XML in double quotes ("xml") but that
> doesn't work.
>
> Is there perhaps a version of Derby that I can download that supports
> column renaming but doesn't have XML as a reserved word? Or is there
> another solution that I've missed?
>
> TIA,
>
> ----------------------------------------------------------------------
>  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)
> ----------------------------------------------------------------------


Mime
View raw message