Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Problem with Query and specially named columns

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


Back to the top