<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><DIV>hi,</DIV>
<DIV> Here I am facing a problem while retriving the data from the hibernate POJO, once after making query.</DIV>
<DIV> Folloing is the code</DIV>
<DIV> </DIV>
<DIV>DataBase Table.</DIV>
<DIV> </DIV>
<DIV>V_SEARCH_CUSTOMER</DIV>
<DIV>CUSTOMER_ID CUSTOMER_NAME VENDOR_ID</DIV>
<DIV>1 TestCustomer 1</DIV>
<DIV>
<DIV>1 TestCustomer 2</DIV>
<DIV>
<DIV>1 TestCustomer 3</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Java Code :</DIV>
<DIV> </DIV>
<DIV>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</DIV>
<DIV> </DIV>
<DIV>
<DIV>CUSTOMER_ID CUSTOMER_NAME VENDOR_ID</DIV>
<DIV>1 TestCustomer 1</DIV>
<DIV>
<DIV>1 TestCustomer 1</DIV>
<DIV>
<DIV>1 TestCustomer 1</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>When I run the sql qury generated by the Hibernate in the DbVissualizer it's giving the exact results.</DIV>
<DIV>I am facing the problem when I iterate though the query results.</DIV>
<DIV> </DIV>
<DIV>Can any body help to get the correct vendor IDs</DIV>
<DIV> </DIV>
<DIV>Thanks,</DIV>
<DIV>Chandu</DIV></DIV></DIV></DIV></DIV></DIV></div><br>
<hr size=1>Yahoo! oneSearch: Finally, <a href="http://us.rd.yahoo.com/evt=48252/*http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC"> mobile search
that gives answers</a>, not web links.
</body></html>