Not able retrive the data from the ORACLE database.

2 things you need to check:
how many rows of data present in the table you are making a query? is it possible to test it by adding condition so that it returns limited rows and see? by the way is it a remote database?

have you tried quering to different tables and see if it takes same result?

Thanks for taking out time to reply to the post.

I have tried with other tables also and it is having the same behavior i.e only the table column headers are retrieved but no data when we do a select with condition.

When i do the simple select once or twice all the data got retrieved but there after it never retrieved any data.On making the select without condition it gets in infinite loop.There are more than 10000 rows in this table.

As suggested by you i tried with another table and for the other table on making a select statement call i am able to retrieve the data.But with the condition only table headers get fetched but no data.

This is a remote database.

Thanks,
Aman

Are you logging in with the same credentials you provided for the JDBC connection? I'd double check the user permissions.

Thanks,
Michael Giller
SmartBear Software

Hi Michael,

Yes, I am using the same user credentials that i have given in the jdbc connection and when i try to retrieve the records using conditional statement with TOAD i get the records but when i try to fetch the records from the table with the same query in soap UI i only get the table column headers and no data.


Thanks,
David

It sounds like a locking issue, i.e. something is probably updating that database table, or maybe locking it for reading. You should check your transaction isolation settings - you might be using SERIALIZABLE rather than READ_COMMITTED.

Here's a link that may be interesting to you: http://www.oracle.com/technetwork/issue ... 82389.html

Hope this helps!

Manne