Hibernate version: 3.1.3
Name and version of the database you are using: Oracle10g
Hi,
here is my mapping:
Code:
<class table="TSRFILOT" name="Ilot" lazy="false" persister="my.project.IlotPersister">
<id column="idIlot" name="idIlot" type="string">
<generator class="my.project.HibernateUuidGenerator"/>
</id>
<property column="P1" name="p1" type="integer"/>
<property column="P2" name="p2" type="string" />
<many-to-one column="idDemande" name="demande" class="DemandeAide"/>
<loader query-ref="loadIlot"/>
</class>
<sql-query name="loadIlot">
<return alias="ilot" class="Ilot" lock-mode="none" />
SELECT IDDEMANDE AS {ilot.demande},
P1 AS {ilot.p1},
UPPER(P2) AS {ilot.p2},
IDILOT AS {ilot.idIlot}
FROM TSRFILOT WHERE IDILOT=?
</sql-query>
This work fine when I perform a load.
My problem is when I try to perform a select an ilot by p1, the select query is:
Code:
select ilot0_.idIlot as idIlot4_, ilot0_.p1 as p14_, ilot0_.p2 as p24_ from TSRFILOT ilot0_ where ilot0_.p1=?
The UPPER function is an example. Actually, I am not able to perform the function on the insert or update statement.
Thanks in advance
Login
FAQ
Search