[OPENJPA-164] Need better logging on Java field type to SQL type mapping and exceptions

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0, 0.9.6
• Component/s: diagnostics, jdbc
• Assignee: Unassigned
• Reporter: Nick Johnson
• Created: 07/Mar/07 05:34
• Updated: 07/Aug/07 17:18

Description

When a Java field and its corresponding SQL field are of incompatible types (as can happen with programming errors), OpenJPA presently just wraps the exception thrown by the JDBC driver. For example, if the type is declared as long in Java but boolean in PostgreSQL, a PostgreSQL error that the value "f" is not compatible with the type BigDecimal.

The problem is that there's no indication of which mapped class is responsible for the exception, which can be a problem for a class with many relationships. Any of the related classes could have caused the problem.

Better logging (probably at level TRACE) around calls to resultSet.getX would greatly help in debugging these problems. Just knowing the classname and the field name the JDBC get is being called for would be tremendously helpful.