Hi all,
I am very new to hibernate and I ran into this problem "DEBUG JDBCExceptionReporter:63 - could not initialize a collection: [com.genuitec.person.Person.events#1] [select events0_.PERSON_ID as PERSON1_1_, events0_.EVENT_ID as EVENT2_1_, events1_.EVENT_ID as EVENT1_0_, events1_.TITLE as TITLE1_0_, events1_.EVENT_DATE as EVENT3_1_0_ from PERSON_EVENTS events0_ inner join EVENTS events1_ on events0_.EVENT_ID=events1_.EVENT_ID where events0_.PERSON_ID=?]" when an A unidirectional Set-based association
When I tried to
Transaction tx = session.beginTransaction();
Person aPerson = (Person)session.load(Person.class,personId);
Events aEvent = (Events)session.load(Events.class,eventId);
System.out.println("loaded person: " + aPerson.getPersonId() + ", loaded event: " + aEvent.getEventId());
/** This is where it starts failing. I expect it to create a new row in PERSON_EVENTS table **/
aPerson.getEvents().add(aEvent);
tx.commit();
Note: I have data on both PERSON and Event tables
My tables Desc:
SQL> desc person
Name Null? Type
------------------------------- -------- ----
PERSON_ID NOT NULL NUMBER(11)
AGE NUMBER
FIRSTNAME VARCHAR2(50)
LASTNAME VARCHAR2(50)
SQL> desc events
Name Null? Type
------------------------------- -------- ----
EVENT_ID NOT NULL NUMBER(11)
TITLE VARCHAR2(255)
EVENT_DATE DATE
SQL> desc person_events
Name Null? Type
------------------------------- -------- ----
PERSON_ID NUMBER
EVENT_ID NUMBER
My Person.hbm.xml defination is
<hibernate-mapping package="com.genuitec.person">
<class name="Person" table="PERSON">
<id name="personId" column="PERSON_ID">
<generator class="increment"/>
</id>
<property name="age" column="AGE" type="long" />
<property name="firstname" column="FIRSTNAME" type="string" />
<property name="lastname" column="LASTNAME" type="string" />
<set name="events" table="PERSON_EVENTS">
<key column="PERSON_ID"/>
<many-to-many column="EVENT_ID" class="com.genuitec.events.Events"/>
</set>
Please help me to find what's the issue is.
Thanks a bunch.
Binh Tran.
Login
FAQ
Search
