Mailing-List: contact empire-db-commits-help@incubator.apache.org;
 run by ezmlm
Precedence: bulk
Reply-To: empire-db-dev@incubator.apache.org
Message-ID: <1894911885.1219759844487.JavaMail.jira@brutus>
Date: Tue, 26 Aug 2008 07:10:44 -0700 (PDT)
From: =?utf-8?Q?J=C3=B6rg_Reiher_=28JIRA=29?=
 <empire-db-dev@incubator.apache.org>
To: empire-db-commits@incubator.apache.org
Subject: [jira] Resolved: (EMPIREDB-3) Add "useQuote" property to DBColum
 class so columns with SQL keywords as names get properly "escaped"
In-Reply-To: <337482484.1219757744320.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/EMPIREDB-3?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

J=C3=B6rg Reiher resolved EMPIREDB-3.
--------------------------------

    Resolution: Fixed

Added "useQuotes" property to DBColumn.

> Add "useQuote" property to DBColum class so columns with SQL keywords as =
names get properly "escaped"
> -------------------------------------------------------------------------=
----------------------------
>
>                 Key: EMPIREDB-3
>                 URL: https://issues.apache.org/jira/browse/EMPIREDB-3
>             Project: Empire-DB
>          Issue Type: Improvement
>          Components: Core
>    Affects Versions: empire-db-2.0.3-incubating
>            Reporter: J=C3=B6rg Reiher
>            Priority: Minor
>             Fix For: empire-db-2.0.3-incubating
>
>
> HSQLDB doesn't like "COUNT" as an SQL column name, because it is also a f=
unction.
> So it would be helpful to add a property "useQuote" to the DBColumn class=
 so that if set to "true" the column in the generated SQL statement gets su=
rrounded by quotation marks. This allows the use of "keywords" as column na=
mes.

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.