Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Talk:EclipseLink/FAQ/JPA/PostgreSQL
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)