Hello Riyad,
Thanks for your reply. I am not very new to Java. I have tried my hands using straight JDBC. I have been using Hibernate also for a while without any problem. Let me describe what I am trying to do. I am trying to check for a particular condition and if the condition satisfies I am trying to copy the rows from the present tables to a new result table. I need a new result table for further review.
If I try doing it with using simple JDBC and SQL its simple. Since, I will have a ResultSet to operate on and can access each data element using getString() method and we can copy this to a new table. But this is not the case with Hibernate. I tried ScrollableResults() method, but dint work for me. Can you please help me with this?