Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » [Teneo] single join table for mtm results in exception
[Teneo] single join table for mtm results in exception [message #79743] |
Thu, 12 April 2007 20:03 |
Mark Geib Messages: 432 Registered: July 2009 |
Senior Member |
|
|
Martin,
I updated my model so all many-to-many relationships include the
annotation for setting indexed=false. The resulting database tables look
great. I loaded my data and saved into the database with no problem.
However, when I try to access objects via these single join tables I get
Hibernate exceptions that state the indexed column is NULL, etc.
The mapping file for one of these looks like...
<bag name="contacts" lazy="true"
cascade="merge,persist,save-update,lock,refresh" table="`service_contact`">
<key update="true">
<column name="`service_e_id`" not-null="true" unique="false"/>
</key>
<many-to-many entity-name="Contact" unique="false">
<column name="`contact_e_id`" not-null="true" unique="false"/>
</many-to-many>
</bag>
and ....
<bag name="services" lazy="true"
cascade="merge,persist,save-update,lock,refresh" inverse="true"
table="`service_contact`">
<key update="true">
<column name="`contact_e_id`" not-null="true" unique="false"/>
</key>
<many-to-many entity-name="Service" unique="false">
<column name="`service_e_id`" not-null="true" unique="false"/>
</many-to-many>
</bag>
Any ideas...?
Thanks,
Mark.
|
|
|
Re: [Teneo] single join table for mtm results in exception [message #79758 is a reply to message #79743] |
Thu, 12 April 2007 20:50 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Mark,
The mapping looks fine, can you post the stack trace?
The exception is thrown for a specific many-to-many probably, can you check which one it is and
check the mapping for that specific many-to-many?
gr. Martin
Mark wrote:
> Martin,
>
> I updated my model so all many-to-many relationships include the
> annotation for setting indexed=false. The resulting database tables look
> great. I loaded my data and saved into the database with no problem.
>
> However, when I try to access objects via these single join tables I get
> Hibernate exceptions that state the indexed column is NULL, etc.
>
> The mapping file for one of these looks like...
>
> <bag name="contacts" lazy="true"
> cascade="merge,persist,save-update,lock,refresh" table="`service_contact`">
> <key update="true">
> <column name="`service_e_id`" not-null="true"
> unique="false"/>
> </key>
> <many-to-many entity-name="Contact" unique="false">
> <column name="`contact_e_id`" not-null="true"
> unique="false"/>
> </many-to-many>
> </bag>
>
>
> and ....
>
>
> <bag name="services" lazy="true"
> cascade="merge,persist,save-update,lock,refresh" inverse="true"
> table="`service_contact`">
> <key update="true">
> <column name="`contact_e_id`" not-null="true"
> unique="false"/>
> </key>
> <many-to-many entity-name="Service" unique="false">
> <column name="`service_e_id`" not-null="true"
> unique="false"/>
> </many-to-many>
> </bag>
>
>
> Any ideas...?
>
> Thanks,
> Mark.
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
| | |
Re: [Teneo] single join table for mtm results in exception [message #604718 is a reply to message #79743] |
Thu, 12 April 2007 20:50 |
Martin Taal Messages: 5468 Registered: July 2009 |
Senior Member |
|
|
Mark,
The mapping looks fine, can you post the stack trace?
The exception is thrown for a specific many-to-many probably, can you check which one it is and
check the mapping for that specific many-to-many?
gr. Martin
Mark wrote:
> Martin,
>
> I updated my model so all many-to-many relationships include the
> annotation for setting indexed=false. The resulting database tables look
> great. I loaded my data and saved into the database with no problem.
>
> However, when I try to access objects via these single join tables I get
> Hibernate exceptions that state the indexed column is NULL, etc.
>
> The mapping file for one of these looks like...
>
> <bag name="contacts" lazy="true"
> cascade="merge,persist,save-update,lock,refresh" table="`service_contact`">
> <key update="true">
> <column name="`service_e_id`" not-null="true"
> unique="false"/>
> </key>
> <many-to-many entity-name="Contact" unique="false">
> <column name="`contact_e_id`" not-null="true"
> unique="false"/>
> </many-to-many>
> </bag>
>
>
> and ....
>
>
> <bag name="services" lazy="true"
> cascade="merge,persist,save-update,lock,refresh" inverse="true"
> table="`service_contact`">
> <key update="true">
> <column name="`contact_e_id`" not-null="true"
> unique="false"/>
> </key>
> <many-to-many entity-name="Service" unique="false">
> <column name="`service_e_id`" not-null="true"
> unique="false"/>
> </many-to-many>
> </bag>
>
>
> Any ideas...?
>
> Thanks,
> Mark.
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal@springsite.com - mtaal@elver.org
Web: www.springsite.com - www.elver.org
|
|
| | |
Goto Forum:
Current Time: Wed Sep 25 02:02:53 GMT 2024
Powered by FUDForum. Page generated in 0.05492 seconds
|