[Hibernate] Oracle UTF8, long classnames and generated constraint names

[Jozsa K. <dy...@on...>]

Hi,

I've met a problem using Hibernate. Can I set somewhere in the mapping file
the generated constraints' name? I ask that, cos I have some longer class
names es (eg. 15 chars), and if there's more than one constraint for the
given table to persist, only the first one can be persisted. 

I guess the problem relies in the Oracle 8i database I use, and the Oracle
session set to UTF8 by default.. afaik Oracle can use constraint names up
to 30 chars, but when using utf8, man has to divide that by either 3 or 4
(dunno exactly how long UTF8 chars Oracle uses). Therefore, only one of
those Hibernate-generated constraint names (CLASSNAMEFKx where x is the
index) can be persisted successfully, all the following ones would be
detected to be the same by the db.

I hope that all above makes some sense :)

dyn

ps. grepped through the docs for 'constraint' but couldn't find an option
for setting the name of them..
-- 
.Digital.Yearning.for.Networked.Assassination.and.Xenocide