[one-to-one] with blank in the foreign key

seb_fou · **Posted:** Wed Apr 05, 2006 11:06 am

hello

i have a relation one-to-one with foreign key like this

Code:

 
<many-to-one
            name="acte"
                    class="XXX.model.Acte"
                    column="CODE_ACT"
                unique="true"
                insert="false"
                update="false"
                lazy="false"
>

The CODE_ACT is a string with length = 3 characters
the relation works well

but when i have a CODE_ACT with 1characters and two blank (length=3)
the relation is broken

How can i precise the trim in hibernate on the column

Thanks

LaLiLuna · **Posted:** Wed Apr 05, 2006 6:03 pm

Hello Seb,

I am just wondering why a String contating blancs is distinguished from another character. May be the problem is located in your application.

Could you post a simple case showing the problem.

regards Sebastian

seb_fou · **Posted:** Thu Apr 06, 2006 4:26 am

i have found the solution by putting this in the hibernate mapping file :

Quote:

formula="case when CODE_ACT is not null then trim(CODE_ACT) end"

thx