I have written a servlet which connects to oracle server and executes a query which runs for more than 4 min. Actually there are 9 queries and each might take 4 min to complete ... They all run in a separate thread. When it was running i suddenly get ORA-08176: consistent read failure; rollback data not available.All the 9 queries are select statement.
Can some one explain why the error and how to solve it through java.