EclipseLink & Cell Names with White Space [message #654471] |
Tue, 15 February 2011 22:38 |
Betsuni Messages: 3 Registered: February 2011 |
Junior Member |
|
|
Performing a normal query like
List<Contact> list = em.createNamedQuery("Contact.findAll").getResultList();
gets translated into
SELECT No_, Mitgl_ in Firmenmitgliedschaft, Telex Answer Back, Profession, [...]
which results in an java.sql.SQLException because of wrong syntax. Is there any way to deal with columns containing white spaces?
I got to use MS SQL here, so the normal way of doing such a query would be
SELECT No_, [Mitgl_ in Firmenmitgliedschaft], [Telex Answer Back], Profession, [...]
I set NATIVE_SQL and SQL Server in the persistence.xml, but it did not help for this issue...
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.05284 seconds