hibernate cannot read view with null column

Question

I have a view which reads from table with some null columns. I have hibernate code which reads this view. The issue is hibernate is not able to read this record due to this null value. Looking at the logs i see the following

DEBUG [http-bio-8080-exec-1][2013-05-20 23:34:16,243][NullableType.java:166] - returning null as column: address19_0_

It is able to read all the non null columns but when it comes to address which is null in this case it throws exception. Why is hibernate not able to read this?

I am generating the POJO and hbm.xml file using eclipse hibernate tool. Here is the build.xml for the hibernate tool

<taskdef name="hibernatetool" classname="org.hibernate.tool.ant.HibernateToolTask">
    <classpath>
        <fileset dir="C:\eclipse\order\WebContent\WEB-INF\lib">
            <include name="**/*.jar" />
        </fileset>
    </classpath>
</taskdef>

<target name="gen_hibernate" description="generate hibernate classes">
    <hibernatetool destdir="C:\eclipse\order\GenCode">
        <jdbcconfiguration configurationfile="hibernate.cfg.xml"
            packagename="com.order" detectmanytomany="true" />
        <hbm2hbmxml destdir="src" />
        <hbm2java jdk5="true" destdir="src" />
        <hbm2cfgxml destdir="src" />
        <hbm2doc />
    </hibernatetool>

    <copy todir="C:\eclipse\order\src\order\">
        <fileset dir="C:\eclipse\order\GenCode\src\com\order\">
            <include name="**/*.java" />
            <include name="**/*.hbm.xml" />
        </fileset>
    </copy>
    <copy file="C:\eclipse\order\GenCode\src\hibernate.cfg.xml" todir="C:\eclipse\order\src\" />
</target>

And here is my generated hbm.xml for the view, it is generating with composite id

<?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 May 20, 2013 11:26:25 PM by Hibernate Tools 3.2.0.CR1 -->
<hibernate-mapping>
    <class name="com.order.VOrderdetail" table="v_orderdetail" catalog="order">
        <composite-id name="id" class="com.order.VOrderdetailId">
            <key-property name="orderId" type="int">
                <column name="orderId" />
            </key-property>
            <key-property name="userId" type="int">
                <column name="userId" />
            </key-property>
            <key-property name="createDate" type="date">
                <column name="createDate" length="0" />
            </key-property>
            <key-property name="description" type="string">
                <column name="description" length="65535" />
            </key-property>
            <key-property name="addressLine1" type="string">
                <column name="addressLine1" length="100" />
            </key-property>
            <key-property name="addressLine2" type="string">
                <column name="addressLine2" length="100" />
            </key-property>
            <key-property name="city" type="string">
                <column name="city" length="100" />
            </key-property>
            <key-property name="state" type="string">
                <column name="state" length="10" />
            </key-property>
            <key-property name="zipCode" type="string">
                <column name="zipCode" length="10" />
            </key-property>
        </composite-id>
    </class>
</hibernate-mapping>

How are you mapping? Annotations? If so, provide the class. XML file? If so, paste it also (but paste the mapping class as well). — acdcjunior
– acdcjunior, Commented May 21, 2013 at 4:32

Mikko Maunu · Accepted Answer · 2013-05-21 18:52:25Z

2

Properties that are mapped to columns containing null values should not be used as a part of composite id. There is rejected ticket HHH-1109 about this use case.

answered May 21, 2013 at 18:52

Mikko Maunu

42.3k11 gold badges143 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1241438 Over a year ago

Agree. But this is how hbm2hbmxml is generating the hbm.xml. Is there a way to force hbm2hbmxml to generate it without composite key?

Collectives™ on Stack Overflow

hibernate cannot read view with null column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related