You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Mark Struberg (JIRA)" <ji...@apache.org> on 2015/06/07 08:56:00 UTC
[jira] [Resolved] (OPENJPA-2596) schema-delta generation
(sqlAction=refresh) drops columns if they have an alternative typeName
[ https://issues.apache.org/jira/browse/OPENJPA-2596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mark Struberg resolved OPENJPA-2596.
------------------------------------
Resolution: Fixed
> schema-delta generation (sqlAction=refresh) drops columns if they have an alternative typeName
> ----------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2596
> URL: https://issues.apache.org/jira/browse/OPENJPA-2596
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.4.0
> Reporter: Mark Struberg
> Assignee: Mark Struberg
> Fix For: 2.4.1
>
> Attachments: OPENJPA-2596.patch
>
>
> I use Oracle with the following in my persistence.xml:
> {code}
> <property name="openjpa.jdbc.Dictionary" value="(BitTypeName=CHAR(1),BooleanTypeName=CHAR(1),BooleanRepresentation=STRING_10)"/>
> {code}
> It is all about the *TypeName. The BooleanRepresentation has no impact. I just added it to show the full use case.
> The problem is that during the MappingTool retain there is a Column#equalsColumn which only looks at the Type integers but not on any typeName representation in the DBDictionary.
> What now happens is that during openjpa:sql with sqlAction=build it perfectly creates a CHAR(1) for every boolean and Boolean field in my entity.
> But during a sqlAction=refresh it *wrongly* believes that the types it gets from the SchemaTool by parsing the real db (CHAR length1 java.sql.Types#CHAR=1) is not compatible to the type it sees in the MappingTool from parsing the Entity annotations + orm.xml (java.sql.Tpyes.BIT=-7).
> The result is that generated delta script wrongly drops the column and later adds it again with exactly the same definitions. And this happens every time...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)