This section lists known issues and associated solutions related to the Java Persistence API.
The query compiler does not check all the rules as defined in the Java Persistence Language chapter of the specification. In particular, it does not check:
Type compatibility of function arguments.
Type compatibility of operands of arithmetic, logical, and comparison operators
SELECT clause requirements for an ORDER BY query.
An invalid query may compile but may cause a SQLException at runtime. Or it might happen that the underlying database is less restrictive and supports the generated SQL, but executing the same query on a different database fails with a SQLException.
Verify the above conditions manually.
For more information, see https://glassfish.dev.java.net/issues/show_bug.cgi?id=550.
Manually verify what is wrong in the query.
Use different class names.
For more information, see https://glassfish.dev.java.net/issues/show_bug.cgi?id=558.
Do not list MappedSuperclass explicitly.
Use Java wrapper types for mapping to nullable database columns.