[ https://issues.apache.org/jira/browse/OPENJPA-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14281807#comment-14281807 ]
ASF subversion and git services commented on OPENJPA-2558: ---------------------------------------------------------- Commit 1652761 from [~struberg] in branch 'openjpa/trunk' [ https://svn.apache.org/r1652761 ] OPENJPA-2558 implement BooleanRepresentation which can be switched via config Each DBDictionary has it's own default BooleanRepresentation but can easily get changed by the user e.g. via <property name="openjpa.jdbc.DBDictionary" value="(BitTypeName=CHAR(1),BooleanTypeName=CHAR(1),BooleanRepresentation=STRING_10)"/> > Implement a way to select the db representation of Boolean values > ----------------------------------------------------------------- > > Key: OPENJPA-2558 > URL: https://issues.apache.org/jira/browse/OPENJPA-2558 > Project: OpenJPA > Issue Type: New Feature > Components: jdbc > Affects Versions: 2.3.0 > Reporter: Mark Struberg > Assignee: Mark Struberg > Attachments: OPENJPA-2558.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)