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

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