Hello,

I have all my data in a Collection (List) or I can also have them as ScrollableResults. I want to copy the data present in the List into a table in the Database (SQL Server 2000). I am using Myeclipse, Struts and Hibernate.

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 anyone please help me with this?



Thanks

If the data is already saved in the DB (in other modelled tables, the ones from which you got your results), you can use the new "insert into ... select ..." HQL syntax, new to Hibernate 3.1.

If you're using anything older than 3.1, or you're constained to using an in-memory list, then you'll have to insert each item in the normal way (create an object and save it). Judicious use of Session.flush() and jdbc.batch_size can help improve performance a little, but using JDBC directly will be better for this sort of operation.

Thanks for the reply tenwit. I am using Hibernate 3.0 that is integrated with myeclipse IDE. I cannot save the data directly for the following reasons:

1. We are using a Rules Engine to determine the results and not a select statement. This is a research project, it has to be that way.

2. Also, in the result table I will have one more column thats a key that will be appended with the previous columns.

This is the reason why I was saving the data into a collection and then was trying to insert the data into the new table. Please suggest.

Thanks.