Thanks for your concern.
I was able to solve the problem.
Actually there was two diffrent pools are there.
One pool is connected to Oracle 9i and another is connection to Oracle 10g.
Reason i am not getting the data is becuase of data miss match.
In DBVisulizer when i run the query it was getting it from the database which has the data instead of right database.
This might be bug or not avaialble feature on trial version.