Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.0.4

I have this problem. I have 2 identical tables on a database. One of them contains historical information from the other.

I need to query the historcal table so i create anothe hbm and only change the table name.

The problem is that because im using the same domain object hibernate tell me that this object is already imported

Any idea ??

Thanks
Ignacio

I thinks i can do this with entity-name ... but i cant find any good tutorial on how to use it ...

table box1:
idBox number pk
attribute1 varchar(10)
attribute2 varchar(10)

table box2:
idBox number pk
attribute1 varchar(10)
attribute2 varchar(10)

Pojo Box
private int idBox;
private String attribute1;
private String attribute2;

getters and setters... hashCode, equals methods overwritten...

<hibernate-mapping package="domain" auto-import="false">
<class name="Box" table="box1" entity-name="RealBox">
<id column="idBox" name="idBox" type="int">
<generator class="native" />
</id>
<property column="attribute1" name="attribute1" type="string"/>
<property column="attribute1" name="attribute2" type="string"/>
</class>
</hibernate-mapping>


<hibernate-mapping package="domain" auto-import="false">
<class name="Box" table="box2" entity-name="BackupBox">
<id column="idBox" name="idBox" type="int">
<generator class="native" />
</id>
<property column="attribute1" name="attribute1" type="string"/>
<property column="attribute1" name="attribute2" type="string"/>
</class>
</hibernate-mapping>

and then, in your hql secctions, you can differ every one of them, for example "from RealBox as box" and "from BackupBox as box".

hope it works...

no, it does not work

The following exception was logged org.hibernate.MappingException: duplicate import: CajaLinea

Caja.hbm.xml

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

<hibernate-mapping package="cr.go.ice.vep.domain" auto-import="false">
<class name="Caja" table="CAJA" entity-name="CajaLinea">
<id column="IDCAJA" name="idCaja" type="long" unsaved-value="0">
<generator class="sequence">
<param name="sequence">IDCAJA_SQ</param>
</generator>
</id>
<property column="FECHAAPERTURA" name="fechaApertura" not-null="true" type="timestamp" />
<property column="FECHACIERRE" name="fechaCierre" not-null="false" type="timestamp" />
<property name="nroNotas" insert="false" update="false" formula="(select obtenerNroNotasXCaja(idCaja) from DUAL)" type="long" />
<property name="nroPagos" insert="false" update="false" formula="(select obtenerNroPagosXCaja(idCaja) from DUAL)" type="long" />
<property name="monto" insert="false" update="false" formula="(select obtenerTotalPagosXCaja(idCaja) from DUAL)" type="double" />
<property name="comision" insert="false" update="false" formula="(select obtenerTotalComisionXCaja(idCaja) from DUAL)" type="double" />
<property name="retencionIVA" insert="false" update="false" formula="(select obtenerTotalRetencionIVAXCaja(idCaja) from DUAL)" type="double" />
<property column="ESTADO" name="estado" not-null="true" type="integer" />

<many-to-one class="Recaudador" name="recaudador" not-null="true">
<column name="IDRECAUDADOR" />
</many-to-one>
<set inverse="true" name="notas" cascade="save-update">
<key column="IDCAJA" />
<one-to-many class="Nota" />
</set>
</class>
</hibernate-mapping>

CajaHistorico.hbm.xml

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

<hibernate-mapping package="cr.go.ice.vep.domain" auto-import="false">
<class name="Caja" table="CAJA_HISTORICO" entity-name="CajaHistorico">
<id column="IDCAJA" name="idCaja" type="long" unsaved-value="0">
<generator class="assigned" />
</id>
<property column="FECHAAPERTURA" name="fechaApertura" not-null="true" type="timestamp" />
<property column="FECHACIERRE" name="fechaCierre" not-null="false" type="timestamp" />
<property name="nroNotas" insert="false" update="false" formula="(select obtenerNroNotasXCaja(idCaja) from DUAL)" type="long" />
<property name="nroPagos" insert="false" update="false" formula="(select obtenerNroPagosXCaja(idCaja) from DUAL)" type="long" />
<property name="monto" insert="false" update="false" formula="(select obtenerTotalPagosXCaja(idCaja) from DUAL)" type="double" />
<property name="comision" insert="false" update="false" formula="(select obtenerTotalComisionXCaja(idCaja) from DUAL)" type="double" />
<property name="retencionIVA" insert="false" update="false" formula="(select obtenerTotalRetencionIVAXCaja(idCaja) from DUAL)" type="double" />
<property column="ESTADO" name="estado" not-null="true" type="integer" />

<many-to-one class="Recaudador" name="recaudador" not-null="true">
<column name="IDRECAUDADOR" />
</many-to-one>
<set inverse="true" name="notas" cascade="save-update">
<key column="IDCAJA" />
<one-to-many class="Nota" />
</set>
</class>
</hibernate-mapping>

If you are doing read-only queries, you can just map the read-write one, then do SQL native queries into those objects (alias each column).

http://www.hibernate.org/hib_docs/v3/re ... -nativesql

(see second query)

Chris