Eclipse Community Forums: EMF "Technology" (Ecore Tools, EMFatic, etc) » [Teneo] Problem using JOINED value for PersistenceOptions.INHERITANCE

Home » Modeling » EMF "Technology" (Ecore Tools, EMFatic, etc) » [Teneo] Problem using JOINED value for PersistenceOptions.INHERITANCE_MAPPING

Show: Today's Messages :: Show Polls :: Message Navigator

[Teneo] Problem using JOINED value for PersistenceOptions.INHERITANCE_MAPPING [message #76933]

Tue, 27 March 2007 21:30

Mark Geib

Messages: 432
Registered: July 2009

Senior Member

Martin,

I have a problem in that my model has sub-classes which have attributes of
the same name, but different types. So using the default SINGLE_TABLE will
not work.

I tried to set the PersistenceOptions.INHERITANCE_MAPPING to JOINED, but
then have a problem in that there seems to be a limit in mysql that
prevents accessing my objects when there are more than 61 tables in a
join...

So, can I use TABLE_PER_CLASS.? If so how do I handle the issue with not
being able to use generated column keys...?

I get this when I use TABLE_PER_CLASS..

Exception in thread "main" org.hibernate.MappingException: Cannot use
identity column key generation with <union-subclass> mapping for:
AttrCueSource
at
org.hibernate.persister.entity.UnionSubclassEntityPersister. <init>(UnionSubclassEntityPersister.java:67)
at
org.hibernate.persister.PersisterFactory.createClassPersiste r(PersisterFactory.java:61)

Thanks,
Mark.

Report message to a moderator

Re: [Teneo] Problem using JOINED value for PersistenceOptions.INHERITANCE_MAPPING [message #76948 is a reply to message #76933]

Tue, 27 March 2007 21:41

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

This is a multi-part message in MIME format.
--------------050409010800020100050706
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit

Mark,
For single-table: you can try to set a column annotation on these attributes with the same name so
that they are stored in different columns.
So something like:
@Column(name="myothercolumnname")

Or for table-per-class you can use a different id-strategy (there are others which also
auto-generate the ids). I attached an example which is used as a testcase in Teneo.

Note that you can also set annotations on EDataType, that is sometimes easier if efeatures share the
same edatatype.

gr. Martin

Mark wrote:
> Martin,
>
> I have a problem in that my model has sub-classes which have attributes
> of the same name, but different types. So using the default SINGLE_TABLE
> will not work.
>
> I tried to set the PersistenceOptions.INHERITANCE_MAPPING to JOINED, but
> then have a problem in that there seems to be a limit in mysql that
> prevents accessing my objects when there are more than 61 tables in a
> join...
>
> So, can I use TABLE_PER_CLASS.? If so how do I handle the issue with not
> being able to use generated column keys...?
>
> I get this when I use TABLE_PER_CLASS..
>
> Exception in thread "main" org.hibernate.MappingException: Cannot use
> identity column key generation with <union-subclass> mapping for:
> AttrCueSource
> at
> org.hibernate.persister.entity.UnionSubclassEntityPersister. <init>(UnionSubclassEntityPersister.java:67)
>
> at
> org.hibernate.persister.PersisterFactory.createClassPersiste r(PersisterFactory.java:61)
>
>
>
> 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

--------------050409010800020100050706
Content-Type: text/xml;
name="id.ecore"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="id.ecore"

<?xml version="1.0" encoding="UTF-8"?>
<ecore:EPackage xmi:version="2.0"
xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:ecore="http://www.eclipse.org/emf/2002/Ecore" name="id"
nsURI=" http://www.eclipse.org/emf/teneo/samples/emf/annotations/hb/ generator/id"
nsPrefix="id">
<eAnnotations source="teneo.hibernate">
<details key="appinfo" value=" 
@GenericGenerator(name="system-uuid&qu ot;, strategy = "uuid")
@GenericGenerator(name=&am p;quot;hibseq", strategy = "hilo",
 parameters = {
 @Parameter(name="table", value = "hilo_table"),
 @Parameter(name="column", value="the_hilo_column")
 }
)
		"/>
</eAnnotations>
<eClassifiers xsi:type="ecore:EClass" name="IdentityID">
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="name" value="IdentityID"/>
<details key="kind" value="elementOnly"/>
</eAnnotations>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="myid" unique="false" lowerBound="1"
eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long" unsettable="true">
<eAnnotations source="teneo.hibernate">
<details key="appinfo" value="
				@Id @GeneratedValue(strategy="IDENTITY")&# xA;			 "/>
</eAnnotations>
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="kind" value="element"/>
<details key="name" value="myid"/>
</eAnnotations>
</eStructuralFeatures>
</eClassifiers>
<eClassifiers xsi:type="ecore:EClass" name="SimpleID">
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="name" value="SimpleID"/>
<details key="kind" value="elementOnly"/>
</eAnnotations>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="autoID" unique="false"
lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long"
unsettable="true">
<eAnnotations source="teneo.hibernate">
<details key="appinfo" value="
				@Id @GeneratedValue 
				@Column(name=&a mp;quot;AUTOD" nullable="false")
	&#x 9;	 "/>
</eAnnotations>
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="kind" value="element"/>
<details key="name" value="autoID"/>
</eAnnotations>
</eStructuralFeatures>
</eClassifiers>
<eClassifiers xsi:type="ecore:EClass" name="TableID">
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="name" value="TableID"/>
<details key="kind" value="elementOnly"/>
</eAnnotations>
<eStructuralFeatures xsi:type="ecore:EAttribute" name="myid" unique="false" lowerBound="1"
eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long" unsettable="true">
<eAnnotations source="teneo.hibernate">
<details key="appinfo" value="
				@Id @GeneratedValue(generator="hibseq")&#x A;			 "/>
</eAnnotations>
<eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
<details key="kind" value="element"/>
<details key="name" value="myid"/>
</eAnnotations>
</eStructuralFeatures>
</eClassifiers>
</ecore:EPackage>

--------------050409010800020100050706--

Report message to a moderator

Re: [Teneo] Problem using JOINED value for PersistenceOptions.INHERITANCE_MAPPING [message #76962 is a reply to message #76948]

Tue, 27 March 2007 21:50

Martin Taal

Messages: 5468
Registered: July 2009

Senior Member

As an extra tip, after adding annotations to the ecore you need to regenerate the java code (and the
hbm file), otherwise the annotations are not visible at runtime.
Annotations can also be added in a separate xml file, then regeneration of the java code is not
required. See the elver.org website for more information.

gr. Martin

Martin Taal wrote:
> Mark,
> For single-table: you can try to set a column annotation on these
> attributes with the same name so that they are stored in different columns.
> So something like:
> @Column(name="myothercolumnname")
>
> Or for table-per-class you can use a different id-strategy (there are
> others which also auto-generate the ids). I attached an example which is
> used as a testcase in Teneo.
>
> Note that you can also set annotations on EDataType, that is sometimes
> easier if efeatures share the same edatatype.
>
> gr. Martin
>
> Mark wrote:
>> Martin,
>>
>> I have a problem in that my model has sub-classes which have
>> attributes of the same name, but different types. So using the default
>> SINGLE_TABLE will not work.
>>
>> I tried to set the PersistenceOptions.INHERITANCE_MAPPING to JOINED,
>> but then have a problem in that there seems to be a limit in mysql
>> that prevents accessing my objects when there are more than 61 tables
>> in a join...
>>
>> So, can I use TABLE_PER_CLASS.? If so how do I handle the issue with
>> not being able to use generated column keys...?
>>
>> I get this when I use TABLE_PER_CLASS..
>>
>> Exception in thread "main" org.hibernate.MappingException: Cannot use
>> identity column key generation with <union-subclass> mapping for:
>> AttrCueSource
>> at
>> org.hibernate.persister.entity.UnionSubclassEntityPersister. <init>(UnionSubclassEntityPersister.java:67)
>>
>> at
>> org.hibernate.persister.PersisterFactory.createClassPersiste r(PersisterFactory.java:61)
>>
>>
>>
>> Thanks,
>> Mark.
>>
>
>
>
> ------------------------------------------------------------ ------------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <ecore:EPackage xmi:version="2.0"
> xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:ecore="http://www.eclipse.org/emf/2002/Ecore" name="id"
> nsURI=" http://www.eclipse.org/emf/teneo/samples/emf/annotations/hb/ generator/id"
> nsPrefix="id">
> <eAnnotations source="teneo.hibernate">
> <details key="appinfo" value=" 
@GenericGenerator(name="system-uuid&qu ot;, strategy = "uuid")
@GenericGenerator(name=&am p;quot;hibseq", strategy = "hilo",
 parameters = {
 @Parameter(name="table", value = "hilo_table"),
 @Parameter(name="column", value="the_hilo_column")
 }
)
		"/>
> </eAnnotations>
> <eClassifiers xsi:type="ecore:EClass" name="IdentityID">
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="name" value="IdentityID"/>
> <details key="kind" value="elementOnly"/>
> </eAnnotations>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="myid" unique="false" lowerBound="1"
> eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long" unsettable="true">
> <eAnnotations source="teneo.hibernate">
> <details key="appinfo" value="
				@Id @GeneratedValue(strategy="IDENTITY")&# xA;			 "/>
> </eAnnotations>
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="kind" value="element"/>
> <details key="name" value="myid"/>
> </eAnnotations>
> </eStructuralFeatures>
> </eClassifiers>
> <eClassifiers xsi:type="ecore:EClass" name="SimpleID">
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="name" value="SimpleID"/>
> <details key="kind" value="elementOnly"/>
> </eAnnotations>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="autoID" unique="false"
> lowerBound="1" eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long"
> unsettable="true">
> <eAnnotations source="teneo.hibernate">
> <details key="appinfo" value="
				@Id @GeneratedValue 
				@Column(name=&a mp;quot;AUTOD" nullable="false")
	&#x 9;	 "/>
> </eAnnotations>
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="kind" value="element"/>
> <details key="name" value="autoID"/>
> </eAnnotations>
> </eStructuralFeatures>
> </eClassifiers>
> <eClassifiers xsi:type="ecore:EClass" name="TableID">
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="name" value="TableID"/>
> <details key="kind" value="elementOnly"/>
> </eAnnotations>
> <eStructuralFeatures xsi:type="ecore:EAttribute" name="myid" unique="false" lowerBound="1"
> eType="ecore:EDataType http://www.eclipse.org/emf/2003/XMLType#//Long" unsettable="true">
> <eAnnotations source="teneo.hibernate">
> <details key="appinfo" value="
				@Id @GeneratedValue(generator="hibseq")&#x A;			 "/>
> </eAnnotations>
> <eAnnotations source="http:///org/eclipse/emf/ecore/util/ExtendedMetaData">
> <details key="kind" value="element"/>
> <details key="name" value="myid"/>
> </eAnnotations>
> </eStructuralFeatures>
> </eClassifiers>
> </ecore:EPackage>
a

--

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

Report message to a moderator