hibernate bug in select ?

[jay vas]

Hi guys :


I have the following mapping file (autogenerated in hibernate). If I
uncomment the text inside the <!-- --> a select all NmrPulseStateNuclei winds up causing a "Invalid value for getLong() - '"1H8"' " error.

Now, the data in the table is as follows (sample for 1st row).

N_pulse_SN_ID=1
N_pulse_SN_State=1
N_pulse_SN_Nucleus=""1H8""
N_pulse_SN_Phase=""
N_pulse_SN_Incremented=0
N_pulse_SN_Convolution=""

So it looks like hibernate is selecting the WRONG column on accident ?
I.E. it is trying to map n_pulse_sn_nucleus into n_pulse_sn_id...
why would this be ?

I am shocked that autogenerated hibernate code is not even doing type safe queries ?

 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jun 25, 2008 6:43:54 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="dao.NmrPulseStateNuclei" table="nmr_pulse_state_nuclei" catalog="structure">
        <id name="NPulseSnId" type="java.lang.Long">
            <column name="N_pulse_SN_ID" />
            <generator class="identity" />
        </id>
        <!-- this is being selected as the id for some reason ??? 
        <many-to-one name="nmrPulseNucleus" class="dao.NmrPulseNucleus" fetch="select">
            <column name="N_pulse_SN_Nucleus" not-null="true" />
        </many-to-one>
         -->
         
        <many-to-one name="nmrPulseStates" class="dao.NmrPulseStates" fetch="select">
            <column name="N_pulse_SN_State" not-null="true" />
        </many-to-one>
        <property name="NPulseSnPhase" type="string">
            <column name="N_pulse_SN_Phase" />
        </property>
        <property name="NPulseSnIncremented" type="boolean">
            <column name="N_pulse_SN_Incremented" not-null="true" />
        </property>
        <property name="NPulseSnConvolution" type="string">
            <column name="N_pulse_SN_Convolution" />
        </property>
        <set name="coupledNucleis" inverse="true">
            <key>
                <column name="N_pulse_CN_State_Nucleus" not-null="true" />
            </key>
            <one-to-many class="dao.CoupledNuclei" />
        </set>
        <set name="nmrPulseDecoupledNucleis" inverse="true">
            <key>
                <column name="N_pulse_DN_State_Nucleus" not-null="true" />
            </key>
            <one-to-many class="dao.NmrPulseDecoupledNuclei" />
        </set>
    </class>
</hibernate-mapping>
 

[Edvins Reisons]

Jay,

Most of the time, it turns out that the bug is ours and not Hibernate's .
Try looking into the class definitions, especially the types of ID fields.