Could not format discriminator value to SQL string ?????

jnsunkersett · **Posted:** Tue Apr 20, 2004 6:07 pm

Hi,

My Hydrated class has an attribute of a custom type

I have declared it as a Hibernate discriminator.

But I find the discriminator has to be set as 'String'
I want as integer but with that when Hibernate initializes it gives error
Could not format discriminator value to SQL string

Any clues ?

My Hibernate mapping (partial) is as

Code:

<hibernate-mapping>
   <class name="equicom.offline.transmission_profile.TransmissionProfile" table="TRANSMISSION_PROFILE" dynamic-update="false" dynamic-insert="false">
      <id name="profileID" column="PROFILE_ID" type="integer">
         <generator class="native"></generator>
      </id>

      <discriminator column="PURPOSE" type="integer" />

      <property name="description" type="string" update="true" insert="true" column="DESCRIPTION" not-null="false" unique="false" />

      <property name="purpose" type="equicom.offline.transmission_profile.TransmissionPurpose" update="false" insert="false" column="PURPOSE" />

I am using Hibernate 2.1, with Oracle

michael · **Posted:** Tue Apr 20, 2004 7:31 pm

Specify discriminator-value for your class and all its mapped subclasses.

zorkerman · **Joined:** Thu Nov 17, 2005 1:29 pm **Posts:** 12

michael wrote:

Specify discriminator-value for your class and all its mapped subclasses.

Why is it necessary for the base class to set a discriminator if it will never be applied?

lorban · **Posted:** Wed Nov 30, 2005 3:34 pm

It is a limitation of Hibernate 2.x that has been addressed in 3.x.

See http://www.hibernate.org/hib_docs/v3/re ... criminator