[hibernate-issues] Unable to get the correct ids from the hibernate query results

[chand sekhar]

hi,
    Here I am facing a problem while retriving the data from the hibernate POJO, once after making query.
    Folloing is the code

DataBase Table.

V_SEARCH_CUSTOMER
CUSTOMER_ID   CUSTOMER_NAME    VENDOR_ID
1                           TestCustomer                    1
1                           TestCustomer                    2
1                           TestCustomer                    3


Java Code :

Using Hibernate when I search for 'CUSTOMER_NAME '   with 'TestCustomer' it's returning three rows but it's not giving the correct VENDOR_IDs. I am getting the result as follows

CUSTOMER_ID   CUSTOMER_NAME    VENDOR_ID
1                           TestCustomer                    1
1                           TestCustomer                    1
1                           TestCustomer                    1


When I run the sql qury generated by the Hibernate in the DbVissualizer it's giving the exact results.
I am facing the problem when I iterate though the query results.

Can any body help to get the correct vendor IDs

Thanks,
Chandu


       
____________________________________________________________________________________Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20070521/570f7a0b/attachment.html