Ich habe Probleme bei einer Anfrage auf eine Vererbungsstruktur. Es existieren drei Klassen. Assembly, BaseAssembly und ComplexAssembly. Wobei BaseAssembly und ComplexAssembly von Assembly abgeleitet sind. Darüber hinaus hat Assembly eine Referenz auf sich selbst, so das eine Baumstruktur abgebildet werden kann. Die Klasse Assembly ist abstract, alle anderen Klassen können instantiert werden. Ich habe bereits das DB-Schema generiert und die Datenbank auch mit werten gefüllt´, doch beim selektieren einer Instanz der Klasse Assembly tritt der unten aufgeführte Fehler auf. Da ich schon Werte in die Tabelle Assembly eingefügt habe, denke ich das dass Mapping in ordnung ist. Die Klassen enthlaten nur setter und getter für die Attribute. Das Mapping wurde mit er Strategie "by Subclass" angelegt.

Über hilfe zu diesem Problem würde ich mich sehr freuen.

MfG

Lars Bachert

Hibernate version:

Hibernate3

Mapping documents:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="de.tmobile.ebf.blizzard.assembly.hbm.DesignObjectImpl" table="Designobject">

<id name="id" type="long" column="id" unsaved-value="0">
<generator class="sequence">
<param name="sequence">id_sequence</param>
</generator>
</id>
<property name="buildDate" type="date"/>
<property name="type" type="string"/>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl" table="Assembly">
<key column="id"/>
<property name="buildDate" type="date"/>
<property name="type" type="string"/>

<one-to-one name="module" class="de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl" cascade="all"/>

<one-to-one name="superAssembly" class="de.tmobile.ebf.blizzard.assembly.hbm.ComplexAssemblyImpl" cascade="all"/>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.BaseAssemblyImpl" table="BaseAssembly">
<key column="id"/>

<one-to-one name="module" class="de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl" cascade="all"/>

<one-to-one name="superAssembly" class="de.tmobile.ebf.blizzard.assembly.hbm.ComplexAssemblyImpl" cascade="all"/>

<set name="componentsPriv" table="componentsPriv">
<key column="componentsPriv_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.CompositePartImpl" />
</set>

<set name="componentsShar" table="componentsShar">
<key column="componentsShar_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.CompositePartImpl" />
</set>

<property name="buildDate" type="date"/>
<property name="type" type="string"/>
</joined-subclass>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.ComplexAssemblyImpl" table="ComplexAssembly">
<key column="id"/>

<set name="subAssemblies" cascade="all">
<key column="assembly_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl"/>
</set>

<one-to-one name="module" class="de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl" cascade="all"/>

<one-to-one name="superAssembly" class="de.tmobile.ebf.blizzard.assembly.hbm.ComplexAssemblyImpl" cascade="all"/>

<property name="buildDate" type="date"/>
<property name="type" type="string"/>
</joined-subclass>
</joined-subclass>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl" table="Module">
<key column="id"/>

<set name="assembly" table="Assembly" cascade="all">
<key column="module_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl"/>
</set>

<one-to-one name="manual" class="de.tmobile.ebf.blizzard.assembly.hbm.ManualImpl" cascade="all"/>

<one-to-one name="designRoot" class="de.tmobile.ebf.blizzard.assembly.hbm.ComplexAssemblyImpl" cascade="all"/>

<property name="buildDate" type="date"/>
<property name="type" type="string"/>
</joined-subclass>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.CompositePartImpl" table="CompositePart">
<key column="id"/>

<one-to-one name="documentation" class="de.tmobile.ebf.blizzard.assembly.hbm.DocumentImpl" cascade="all"/>

<one-to-one name="rootPart" class="de.tmobile.ebf.blizzard.assembly.hbm.AtomicPartImpl" cascade="all"/>

<set name="usedInPriv" table="usedInPriv">
<key column="usedInPriv_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.BaseAssemblyImpl"/>
</set>

<set name="usedInShar" table="usedInShar">
<key column="usedInShar_id" />
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.BaseAssemblyImpl"/>
</set>

<set name="parts" table="AtomicPart" inverse="true">
<key column="part_id"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.AtomicPartImpl"/>
</set>

<property name="buildDate" type="date"/>
<property name="type" type="string"/>
</joined-subclass>

<joined-subclass name="de.tmobile.ebf.blizzard.assembly.hbm.AtomicPartImpl" table="AtomicPart">
<key column="id"/>

<property name="docId"/>
<property name="x"/>
<property name="y"/>

<!--
<one-to-one name="partOf" class="de.tmobile.ebf.blizzard.assembly.hbm.CompositePartImpl" cascade="all"/>
-->

<set name="fromConnections" inverse="true" cascade="all">
<key column="fromCon"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.ConnectionImpl"/>
</set>

<set name="toConnections" inverse="true" cascade="all">
<key column="toCon"/>
<one-to-many class="de.tmobile.ebf.blizzard.assembly.hbm.ConnectionImpl"/>
</set>

<many-to-one name="partOf" class="de.tmobile.ebf.blizzard.assembly.hbm.CompositePartImpl" column="compositeParts" cascade="all"/>
<!--
<many-to-one name="fromConnections" column="fromCon"/>

<many-to-one name="toConnections" column="toCon"/>
-->
<property name="buildDate" type="date"/>
<property name="type" type="string"/>
</joined-subclass>
</class>
</hibernate-mapping>



Code between sessionFactory.openSession() and session.close():

AssemblyImpl a = (AssemblyImpl) getSession().load(AssemblyImpl.class, new Long(2419));

Full stack trace of any exception that occurs:

[java] 8121 [2005-04-28 16:59:59,817] INFO org.hibernate.impl.SessionFactoryImpl - Checking 0 named queries
[java] Hibernate: select assemblyim0_.id as id0_, assemblyim0_1_.buildDate as buildDate0_0_, assemblyim0_1_.type as type0_0_, assemblyim0_.buildDate as buildDate1_0_, assemblyim0_.type as type1_0_, assemblyim0_2_.buildDate as buildDate2_0_, assemblyim0_2_.type as type2_0_, assemblyim0_3_.buildDate as buildDate3_0_, assemblyim0_3_.type as type3_0_, decode(assemblyim0_.id, assemblyim0_2_.id, 2, assemblyim0_3_.id, 3, 1) as clazz_0_ from Assembly assemblyim0_, Designobject assemblyim0_1_, BaseAssembly assemblyim0_2_, ComplexAssembly assemblyim0_3_ where assemblyim0_.id=assemblyim0_1_.id and assemblyim0_.id=assemblyim0_2_.id(+) and assemblyim0_.id=assemblyim0_3_.id(+) and assemblyim0_.id=?
[java] 8252 [2005-04-28 16:59:59,948] WARN org.hibernate.engine.PersistenceContext - Narrowing proxy to class de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl - this operation breaks ==
[java] 8382 [2005-04-28 17:00:00,078] ERROR org.hibernate.property.BasicPropertyAccessor - IllegalArgumentException in class: de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl, setter method of property: module
[java] 8382 [2005-04-28 17:00:00,078] ERROR org.hibernate.property.BasicPropertyAccessor - expected type: de.tmobile.ebf.blizzard.assembly.hbm.ModuleImpl, actual value: de.tmobile.ebf.blizzard.assembly.hbm.BaseAssemblyImpl
[java] 8382 [2005-04-28 17:00:00,078] INFO org.hibernate.event.def.DefaultLoadEventListener - Error performing load command
[java] org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl.module
[java] at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPropertyAccessor.java:70)
[java] at org.hibernate.tuple.AbstractTuplizer.setPropertyValues(AbstractTuplizer.java:207)
[java] at org.hibernate.tuple.PojoTuplizer.setPropertyValues(PojoTuplizer.java:171)
[java] at org.hibernate.persister.entity.BasicEntityPersister.setPropertyValues(BasicEntityPersister.java:2923)
[java] at org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:113)
[java] at org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:494)
[java] at org.hibernate.loader.Loader.doQuery(Loader.java:413)
[java] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:208)
[java] at org.hibernate.loader.Loader.loadEntity(Loader.java:1278)
[java] at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:141)
[java] at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:126)
[java] at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2491)
[java] at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:386)
[java] at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:367)
[java] at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:166)
[java] at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:140)
[java] at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:119)
[java] at org.hibernate.impl.SessionImpl.immediateLoad(SessionImpl.java:593)
[java] at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:59)
[java] at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:80)
[java] at org.hibernate.proxy.CGLIBLazyInitializer.intercept(CGLIBLazyInitializer.java:134)
[java] at de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl$$EnhancerByCGLIB$$eae6aa2c.getType(<generated>)
[java] at de.tmobile.ebf.blizzard.hbmclient.Query_Q4.testQuery_Q4(Query_Q4.java:72)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

Name and version of the database you are using:

Oracle 9i

The generated SQL (show_sql=true):

[schemaexport] create table Assembly (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] assembly_id number(19,0),
[schemaexport] module_id number(19,0),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table AtomicPart (
[schemaexport] id number(19,0) not null,
[schemaexport] docId number(19,0),
[schemaexport] x number(19,0),
[schemaexport] y number(19,0),
[schemaexport] compositeParts number(19,0),
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] part_id number(19,0),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table BaseAssembly (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] usedInPriv_id number(19,0),
[schemaexport] usedInShar_id number(19,0),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table CONNECTION (
[schemaexport] id number(19,0) not null,
[schemaexport] fromCon number(19,0),
[schemaexport] toCon number(19,0),
[schemaexport] type varchar2(255),
[schemaexport] length number(19,0),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table ComplexAssembly (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table CompositePart (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] componentsPriv_id number(19,0),
[schemaexport] componentsShar_id number(19,0),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table DOCUMENT (
[schemaexport] id number(19,0) not null,
[schemaexport] text varchar2(255),
[schemaexport] title varchar2(255),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table Designobject (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table MANUAL (
[schemaexport] id number(19,0) not null,
[schemaexport] title varchar2(255),
[schemaexport] text varchar2(255),
[schemaexport] blob blob,
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] create table Module (
[schemaexport] id number(19,0) not null,
[schemaexport] buildDate date,
[schemaexport] type varchar2(255),
[schemaexport] primary key (id)
[schemaexport] );
[schemaexport] alter table Assembly add constraint FKED98A20660340CAB foreign key (id) references Designobject;
[schemaexport] alter table Assembly add constraint FKED98A206D1D261ED foreign key (module_id) references Module;
[schemaexport] alter table Assembly add constraint FKED98A20674035DF7 foreign key (assembly_id) references ComplexAssembly;
[schemaexport] alter table AtomicPart add constraint FK7F177CDE193A7E6E foreign key (part_id) references CompositePart;
[schemaexport] alter table AtomicPart add constraint FK7F177CDE60340CAB foreign key (id) references Designobject;
[schemaexport] alter table AtomicPart add constraint FK7F177CDE43B9FE40 foreign key (compositeParts) references CompositePart;
[schemaexport] alter table BaseAssembly add constraint FK900A9BF7F6C384F4 foreign key (id) references Assembly;
[schemaexport] alter table BaseAssembly add constraint FK900A9BF74A2BBE50 foreign key (usedInPriv_id) references CompositePart;
[schemaexport] alter table BaseAssembly add constraint FK900A9BF7D75B6C59 foreign key (usedInShar_id) references CompositePart;
[schemaexport] alter table CONNECTION add constraint FKEEAE6ADE886D6B18 foreign key (toCon) references AtomicPart;
[schemaexport] alter table CONNECTION add constraint FKEEAE6ADE5E6A1F89 foreign key (fromCon) references AtomicPart;
[schemaexport] alter table ComplexAssembly add constraint FKFE3B0E96F6C384F4 foreign key (id) references Assembly;
[schemaexport] alter table CompositePart add constraint FK79BBDEFA4820A49F foreign key (componentsPriv_id) references BaseAssembly;
[schemaexport] alter table CompositePart add constraint FK79BBDEFA60340CAB foreign key (id) references Designobject;
[schemaexport] alter table CompositePart add constraint FK79BBDEFAD55052A8 foreign key (componentsShar_id) references BaseAssembly;
[schemaexport] alter table Module add constraint FK89B0928C60340CAB foreign key (id) references Designobject;
[schemaexport] create sequence id_sequence;
[schemaexport] 12007 [2005-04-28 17:10:49,892] INFO org.hibernate.tool.hbm2ddl.SchemaExport - schema export complete
[schemaexport] 12017 [2005-04-28 17:10:49,902] INFO org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:oracle:thin:@localhost:1521:hbdb
BUILD SUCCESSFUL
Total time: 13 seconds

offenbar passiert der fehler hier:

IllegalArgumentException in class: de.tmobile.ebf.blizzard.assembly.hbm.AssemblyImpl, setter method of property: module

also der methode setModule wird ein andere Argument übergeben als erwartet.

Hallo,

die Setter und Getter der Klassen sollten meiner Meinung nach Ok sein, da ich ja über hibernate die Datenbank schon gefüllt habe. Ich weiss wirklich nicht mehr was ich noch machen soll. Unten habe ich mal die dazugehörigen Klassen Moule und Assembly aufgeführt. Ist es vielleicht noch ein Bug? Ich mache ja wirklich nur ein Select auf ein Objekt das ich vorher (in einer abgeschlossenen Transaktion) eingefügt habe.

Die Klasse DesignObject




Die Klasse Assembly


Die Klasse Module

Du hast die one-to-one Beziehung zur Klasse ModuleImpl zweimal definiert (AssemblyImpl und in der joined-subclass BaseAssemblyImpl).

War das deine Absicht??

Reto

Nein, das war nicht meine Absicht. Habe sie schon entfernt. Die Exception bleibt allerdings die selbe. Kann es sein, dass es vielleicht doch ein Bug ist?

Grüsse

Lars