[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] Problem with Query and specially named columns
|
Thanks a lot!
-----Ursprüngliche Nachricht-----
Von: eclipselink-users-bounces@xxxxxxxxxxx [mailto:eclipselink-users-bounces@xxxxxxxxxxx] Im Auftrag von Tom Ware
Gesendet: Donnerstag, 26. Juli 2012 19:39
An: eclipselink-users@xxxxxxxxxxx
Betreff: Re: [eclipselink-users] Problem with Query and specially named columns
JPA allows your identifiers to be delimited. From the spec:
To specify delimited identifiers, one of the following approaches must be used:
. It is possible to specify that all database identifiers in use for a persistence unit be treated as delimited identifiers by specifying the <delimited-identifiers/> element within the persistence-unit-defaults element of the object/relational xml mapping file. If the <delimited-identifiers/> element is specified, it cannot be overridden.
. It is possible to specify on a per-name basis that a name for a database object is to be interpreted as a delimited identifier as follows:
. Using annotations, a name is specified as a delimited identifier by enclosing the name within double quotes, whereby the inner quotes are escaped, e.g., @Table(name="\"customer\"").
. When using XML, a name is specified as a delimited identifier by use of double quotes, e.g., <table name=""customer""/>[25]
On 26/07/2012 1:31 PM, Michael Simons wrote:
> Hello,
>
> We've got a table (OI) with columns named like "AED#".
> The JPQL Query "select x from OI as x where x.ovak != :ovak1 and x.ovak != :ovak2"
> produces as SQL Query:
> SELECT AFNR, FIR, STS, TRKZ, AED#, ESD#, USR, OVAK FROM OI WHERE
> ((OVAK<> ?) AND (OVAK<> ?))
>
> But it should be
> SELECT AFNR, FIR, STS, TRKZ, "AED#", "ESD#", USR, OVAK FROM OI WHERE
> ((OVAK<> ?) AND (OVAK<> ?))
>
> Any hints what I can do to solve or work-around this?
> The solution I have in mind is to build a view to "rename" the columns.
>
> Kind Regards,
> Michael Simons
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users