Jump to: navigation, search

Talk:EclipseLink/FAQ/JPA/PostgreSQL

< Talk:EclipseLink/FAQ
Revision as of 10:23, 19 May 2011 by James.sutherland.oracle.com (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Case

RE: Fixing case This does not work. If your table or column names contain uppercase letters, converting the entire name to uppercase will result in null results. Names need to be surrounded with backticks to make this work. This is obviously a bug that needs fixing.

What exactly does not work? In general if your table are created as FOO in will really be foo in PostgreSQL on the database, but using either FOO or foo will work in any query. If you specifically create the table as 'Foo' then you will need to use 'Foo' as the name. You can include the ' in your table name, or EclipseLink has a flag to always use ', as defined in JPA 2.0.
James.sutherland.oracle.com 14:23, 19 May 2011 (UTC)