Problem

I have 3 tables.

Userversion is a intermediate table with this:
- id
- idinstancia
- id version
- etc.

Instancia
- id
- etc

and Solinstancia
- id
- etc

the id from Instancia and Solinstancia is the foreign key in userversion (the idinstancia field). So I need make a join between this 3 tables. Somebody know how make this?


PD: I'm sorry for my very bad inglish



Hibernate version:

- Hibernate 3.2.6


Mapping documents:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="cl.vsoft.liferay.domain.Userversion" table="vsc_userversion">
<id name="id" column="id_">
<generator class="native" />
</id>
<property name="idusuario" column="idusuario" insert="false" update="false"/>
<property name="idinstanciados" column="idinstancia" insert="false" update="false" />
<property name="idinstancia" column="idinstancia" insert="false" update="false" />
<property name="idversion" column="idversion" insert="false" update="false"/>
<property name="idproceso" column="idproceso" />


<many-to-one
name="Usuario"
column="idusuario"
unique="true"
class="cl.vsoft.liferay.domain.UsuarioPostulacion"
fetch="join"
foreign-key = "idusuario"
/>

<many-to-one
name="Versiones"
column="idversion"
unique="true"
class="cl.vsoft.liferay.domain.Version"
fetch="join"
foreign-key = "idversion"
/>

<many-to-one
name="Instancia"
column="idinstancia"
unique="true"
class="cl.vsoft.liferay.domain.Instancia"
fetch="join"
foreign-key = "idinstancia"
/>




<many-to-one
name="Solinstancia"
column="idinstancia"
unique="true"
class="cl.vsoft.liferay.domain.Solinstancia"
fetch="join"
foreign-key = "idinstanciados"
/>

</class>
</hibernate-mapping>


Full stack trace of any exception that occurs:

org.hibernate.MappingException: Repeated column in mapping for entity: cl.vsoft.liferay.domain.Userversion column: idinstancia (should be mapped with insert="false" update="false")


Name and version of the database you are using:

- mysql