Patrice DUROUX created OPENJPA-2887:
---------------------------------------
Summary: trouble mapping a map field using an XML ORM
Key: OPENJPA-2887
URL: https://issues.apache.org/jira/browse/OPENJPA-2887
Project: OpenJPA
Issue Type: Bug
Components: Enhance
Affects Versions: 3.2.0, 3.1.2
Reporter: Patrice DUROUX
Hi,
On a property field (locations) that is a Map<C1, C2> where C1 has a id class
(composite key) that is an embeddable:
But now if I try to apply the following mapping:
<entity class="Sequence">
<table name="sequences" />
<attributes>
<id name="id">
<column name="sequence_id" />
<generated-value strategy="IDENTITY" />
</id>
<many-to-many name="locations">
<map-key-join-column name="numacc" />
<map-key-join-column name="feanum" />
<join-table name="locations">
<join-column name="sequence_id" />
<inverse-join-column name="class_id" />
</join-table>
</many-to-many>
</attributes>
</entity>
Mapping is like loosing the "numacc" column while trying to insert values:
Caused by: <openjpa-3.2.0-r6f721f6 fatal general error>
org.apache.openjpa.persistence.PersistenceException: (conn=64888979) Field
'numacc' doesn't have a default value \{prepstmnt 2064897338 INSERT INTO
imgt2.locations (sequence_id, class_id, feanum) VALUES (?, ?, ?)} [code=1364,
state=HY000]
It is remaining me an old issue #1893 of mine where also some columns were lost
in translation. ;)
I admit myself being a little lost in among all the <map-key-*> elements. Am I
doing it right?
A current working solution is to not have the 2 elements <map-key-join-column
/> in the mapping and use the default JPA column names that are 'key0_numacc'
and 'key0_feanum' as the physical column names in the corresponding table. But
this is not the expected solution.
Thanks,
Patrice
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
