hibernate and trim()

jeffyang10004 · **Joined:** Mon May 10, 2010 3:58 pm **Posts:** 2

Hi, I am facing a problem. I have table containing one CHAR(8) column which is part of the key.
When I call merge() on a persisted entity, hibernate will insert instead of update the row. The entity contains the trimmed string while DB has white space padding.
Any work around for this issue? Thanks a lot!

iometrine · **Joined:** Fri Aug 24, 2007 9:47 am **Posts:** 21

are you sure its hibernate who do it, i think it's your SGBD.
Are you working in DB2, oracle or something else ?

ivirani · **Posted:** Tue May 11, 2010 6:05 pm

Try calling saveOrUpdate() on it and see if that makes a difference