[OPENJPA-2558] Implement a way to select the db representation of Boolean values

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3.0, 2.4.0
• Fix Version/s: 2.2.3, 2.4.0
• Component/s: jdbc
• Assignee: Mark Struberg
• Reporter: Mark Struberg
• Created: 12/Jan/15 15:50
• Updated: 14/Oct/15 17:44
• Resolved: 26/Aug/15 21:56

Description

Many Databases do not natively support the SQL-99 BOOLEAN datatype. Boolean and boolean fields in JPA entities will thus get represented as another type in the database. OpenJPA currently has a hardcoded mapping to int 1/0 in the base DBDictionary.

But many existing databases don't use NUMBER(1) as column type but e.g. CHAR(1) (because it uses less space in the index).
There are also all sorts of possible representations where one of those is usually consistently used throughout a customer application:

• Native Boolean -> PreparedStatement#setBoolean
• Int 0/1 -> PreparedStatement#setInt
• String "Y"/"N" -> PreparedStatement#setString
• String "T"/"F" -> PreparedStatement#setString
• String "y"/"n" -> PreparedStatement#setString
• String "t"/"f" -> PreparedStatement#setString

And I've also seen translated ones: "J"/"N" in german apps for "Ja"/ "Nein" (yes/no).

So it should be possible to even add your own custom BooleanRepresentation.

Issue Links

• contains: OPENJPA-2551 Standard SQL boolean mapping impossible