Hi all,

Here is my problem. I have some temporary tables which have data. I want to copy all of these data into corresponding original tables. Put in simple words, I need to copy data off some tables to some other. I am planning to achieve this task using Hibernate. Which is the best options out of the following ?

1) Execute a Stored Procedure using Hibernate to do the copying.

2) Write the script for copying in an sql file and execute the sql file from inside Hibernate.

Which has more performance and is the right way to do it ?

thanks in advance,
vinodtr

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html