Hello,

I have a table with a number of fixed CHAR fields for which I need to use a UserType (TrimmedStringUserType). This works fine, however one of these fields is the discriminator for my subclasses so I tried using this UserType in the discriminator like this:
<class name="RoutingRule" table="BR_ROUTING_RULE" abstract="true">
<id name="id" column="RULE_ID">
<generator class="identity" />
</id>
<discriminator column="RULE_TYPE_CD" type="changed.package.TrimmedStringUserType"/>
<property name="name" column="NAME" />

<subclass name="LogicRoutingRule" discriminator-value="REQ_CRIT">
<property name="logic" column="LOGIC" />
</subclass>
</class>

and I receive this exception:
Caused by: org.hibernate.MappingException: Illegal discriminator type: changed.package.TrimmedStringUserType
at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:304)
at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:226)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1300)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 110 more

So UserTypes are not allowed within discriminators, it seems. How can I trim these legacy columns for comparison with the discriminator values?
Thanks for any information or insight.

You should ask this question on the Hibernate User forum. I think though that for a user type to be used as discriminator it has to implement EnhancedUserType.

--Hardy

Thank you for your suggestion and direction to the correct forum.
I will implement the correct interface.
Cheers.