Hey all,


I can't add mapping files here as it's forbidden by the client.

But i can give a general overview

I have class 1 that can contain multiple class B's .

Upon insertion off my first class, i get the NonUniqueObjectException.
And truly if i look into the object i see that the Class A contains 2 classB's but they have the same id.
The id in the mappingfile is specified with sequence (param name="sequence" value="Name_sequence").
How come my class B's don't get the id's incremented?

I'm using a postgresql db.

thank you


Jochen

What client is forbidding you to include mapping files ?

the client i'm trying to implement something for.

I'm a consultant :-)

Create a test case using class A and class B like in your example and remove all package names and anything else that might give away client information and there shouldn't be a problem.

class A: <?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping auto-import="false" >
<class name="A"
table="A"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
>

<id
name="idInternal"
column="idInternal"
type="long"
unsaved-value="-1"
>
<generator class="sequence">
<param name="sequence">A_sequence</param></generator>
</id>
<some properties here>
<list
name="BInternal"
table="A_B"
lazy="false"
inverse="false"
cascade="all-delete-orphan"
where="B_index is not null"
>

<key
column="A_id"
>

</key>

<index
column="B_index"
/>

<one-to-many
class="B"
/>
</list>
</class>
</hibernate-mapping>

class B:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping
auto-import="false"
>
<class
name="B"
table="B"
dynamic-update="false"
dynamic-insert="false"
select-before-update="false"
>

<id
name="idInternal"
column="idInternal"
type="long"
unsaved-value="-1"
>
<generator class="sequence">
<param name="sequence">B_sequence</param> </generator>

</id>
<some properties here>
</class>
</hibernate-mapping>

Ok why is the childs id not generated?
What i see in my object is that the idInternal is 0 for each child (generated id).
But apparently it doesn't set it automatically upon insertion into the database?

someone a hint?


thanks

if i check the sql statements, it says directly select nextval ('A_sequence')
and then afterwards i get the NonUniqueObjectException.
shouldn't it also specify this: select nextval ('B_sequence') select nextval ('B_sequence')
as i try to insert one A class containing 2 new B classes

thanks