From: Jozsa K. <dy...@on...> - 2002-09-18 14:12:57
|
Mmm right. And what do you suggest as the new naming convention for the generated foreign key? Clearly it's an oracle problem, but i couldn't even suggest a decent workaround.. dyn On Wed, Sep 18, 2002 at 11:00:51PM +1000, Gavin King wrote: > Hmmmm I suppose we could add a feature like that .... would have to be an > attibute on the many-to-one, key and one-to-one elements. I won't be able to > do it for version 1.1 but perhaps you or someone else wants to have a look > at adding this for 1.2. Shouldn't be terribly hard. > > ----- Original Message ----- > From: "Jozsa Kristof" <dy...@on...> > To: <hib...@li...> > Sent: Wednesday, September 18, 2002 9:56 PM > Subject: [Hibernate] Oracle UTF8, long classnames and generated constraint > names > > > > 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 > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: AMD - Your access to the experts > > on Hammer Technology! Open Source & Linux Developers, register now > > for the AMD Developer Symposium. Code: EX8664 > > http://www.developwithamd.com/developerlab > > _______________________________________________ > > hibernate-devel mailing list > > hib...@li... > > https://lists.sourceforge.net/lists/listinfo/hibernate-devel > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: AMD - Your access to the experts > on Hammer Technology! Open Source & Linux Developers, register now > for the AMD Developer Symposium. Code: EX8664 > http://www.developwithamd.com/developerlab > _______________________________________________ > hibernate-devel mailing list > hib...@li... > https://lists.sourceforge.net/lists/listinfo/hibernate-devel -- .Digital.Yearning.for.Networked.Assassination.and.Xenocide |