Hello,
Im not managing to have a primary key being used as a linst-index.

I have 2 POJOS A,B.
A objects have a List of B objects

<class name="org.test.A" table="A">
<id name="kip"/>
<list name="bs">
<key column="kip" not-null="true" />
<list-index column="id" />
<one-to-many class="org.test.B"/>
</list>
</class>

<class name="org.test.B" table="B">
<id name="id" column="id" type="integer">
<generator class="identity"/>
</id>
<property name="kip" insert="false" update="false"/>
</class>

hibernate tools is creating all tables just as i espected.
The problem is that i am not being able to have the primary key of B as a list-index. (i have tryed giving other name to the index and it works well, but creating a new column :P )
How can i do this?
TIA
marefado

Hibernate version: 3.1

Are you taking some kind or error or is your list being populated teh wrong way, not beeing populated at all?????

Hello,
Thank you for your help, the error is:

Initial SessionFactory creation failed.org.hibernate.MappingException: Repeated column in mapping for entity: org.test.B column: id (should be mapped with insert="false" update="false")

I didn´t manage to fit "insert="false" update="false" " in mapping A or B (DTD is not allowing me and rightfully it seems... if i ignore it the tables are not created)
TIA
marefado

OK i took a closer look so you have kip as a foreign-key in B?
if só you should not map it as a property but Many-to-one with
update= false and insert= false if i am not mistaking

take a look at :
[url=http://www.hibernate.org/hib_docs/v3/reference/en/html/associations.html#assoc-bidirectional-m21]
one-to-many/many-to-one[/url]


Good luck

Hello, tx for all your help.
I edited the mapping for B as you suggested, i think you were suggeting of something like this(was it?):

<class name="org.test.B" table="B">
<id name="id" column="id" type="integer">
<generator class="identity"/>
</id>
<many-to-one name="kip" column="kip" insert="false" update="false"/>
</class>

Now the error is during hibernate mapping:

org.hibernate.MappingException: An association from the table B refers to an unmapped class: java.lang.String

any clues on this?
Tx a lot
marefado

You forgot the class attribute in the many-to-one
It should be like this:


Hope it works...

Ok,
i changed as you sugested (but referenced class A, i think it was what you intended to type)

Ended up with:

<class name="org.test.A" table="A">
<id name="kip"/>
<list name="bs">
<key column="kip" not-null="true" />
<list-index column="id" />
<one-to-many class="org.test.B"/>
</list>
</class>

<class name="org.test.B" table="B">
<id name="id" column="id" type="integer">
<generator class="identity"/>
</id>
<many-to-one class="org.test.A" name="kip" column="kip" insert="false" update="false"/>
</class>

and the error:
ifailed.org.hibernate.MappingException: Repeated column in mapping for entity: org.test.B column: id (should be mapped with insert="false" update="false")

ahhhh hes back! (cant fit update=false,insert=false anywere) :(

Here are the java classes if anyone tries to replicate

public class A{
protected String kip;
protected java.util.List<B> bs;

public A()
{
this.bs = new ArrayList();
}

public A(String kip)
{
this.kip=kip;
}

public String getKip() {
return kip;
}

public void setKip(String kip) {
this.kip = kip;
}

public java.util.List<B> getBs() {
return bs;
}

public void setBs(java.util.List<B> bs) {
this.bs = bs;
}
}


public class B {

public int id;
private String kip;

public B()
{

}

public B(String kip)
{
this.kip = kip;
}

public int getId() {
return id;
}

public void setId(int id) {
this.id = id;
}

public String getKip() {
return kip;
}

public void setKip(String kip) {
this.kip = kip;
}

}


tx!
marefado

Ok finally I found the problem...:)

You can forget my last post and from the mapping in Class B
you make the Many-to-one



And in the code from your class B change the type of the property
kip from String to A



Had to see the code for that one...:)

That will do the trick..... worked for me anyway[/code]

Hello and tx for the quick help ;) !

Unfortunately i cant change my java code. As i see it hibernate should give me the flexibility and not the other way around...

Nevertheless, i tried to change my test objects as suggested and i still receive the same error:

Repeated column in mapping for entity: org.test.B column: id (should be mapped with insert="false" update="false")

Bottomline:
- I am still unable to have a id of a class as a list-index because i cant fit a insert="false" update="false" on the id tag
:(

Tx for your all help!!
joao

Ok last try , I tried it your way and that worked for me as well
here is the mapping:





My configuration file:




and the Java code:





I tried it, the Sessionfactory started witout any problem I was able to insert new A´s B´s and get the collection with a Criteria

Very Well, perfect!
it works now,
Intrigued with the cause of the problem i started coding from your mappings towards my own's...

I found that the responsible for the problem was a not-null="true" on the definition of the list Key(or so it seems):

<class name="org.test.A" table="A">
<id name="kip"/>
<list name="bs">
<key column="kip" not-null="true" />
<list-index column="id" />
<one-to-many class="org.test.B"/>
</list>
</class>

can someone explain the reason for this behaviour?

Many tx for all your help!!!