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