Hibernate Community • View topic - Problem of query.list()

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Problem of query.list()

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

avseq

Post subject: Problem of query.list()

Posted: Tue Sep 19, 2006 8:35 pm

Newbie

Joined: Tue Aug 29, 2006 2:54 am
Posts: 16

I have a table named Car. It has no primary key , so in Car.hbm.xml , all columns composite PK.And all columns accept null value.
So I have two class , Car.java and CarId.java.
When I execute the following snippet.It return list size is 2 , this is correct result, but all elements in list are null.Can someone tell me how to solve this problem?

Code:

        Session session = sessionFactory.openSession(); 
       String Hql = "from Car where id.CarName = 'ABC'";
       Query query = session.createQuery(Hql);
       return query.list();

Last edited by avseq on Wed Sep 20, 2006 2:53 am, edited 1 time in total.

Top

sudhir0104

Post subject:

Posted: Wed Sep 20, 2006 2:09 am

Regular

Joined: Mon May 08, 2006 6:00 am
Posts: 53
Location: India

Could you please post the content of HBM file? Also not sure how you are browsing the data. It shall be done in following fashion

List lst = query.list();
Iterator itr = lst.iterator();
while(itr.hasNext()){

Car car = (Car) itr.next();
CarID = car.getID(); ===> This line shall give you all content

}

Let me know, if I made any mistake in above code

Sudhir

Top

avseq

Post subject:

Posted: Wed Sep 20, 2006 2:49 am

Newbie

Joined: Tue Aug 29, 2006 2:54 am
Posts: 16

Thanks for your reply,the Car.hbm.xml file listed below.

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
    <class name="com.test.Car" table="Car" schema="Owner">
        <composite-id name="id" class="com.test.CarId">
            <key-property name="carName" type="java.lang.String">
                <column name="CARNAME" length="64" />
            </key-property>
            <key-property name="carType" type="java.lang.String">
                <column name="CARTYPE" length="64" />
            </key-property>
        </composite-id>
    </class>
</hibernate-mapping>

Code:

List lst = query.list();
Iterator itr = lst.iterator();
while(itr.hasNext()){

Car car = (Car) itr.next();
CarID = car.getID(); // This will cause NullPointException , because all
                               // elements in list is null
} 

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum