Hi,

I m using Hibernate 3.0.
I m using fully HSQL for processing data but I need to use Native SQL for preprocess with considering the huge data need to be processed.

I tried to use session().createSQLQuery(sqlString) to perform Selecting From one table and inserting into new table in one sql statement (sqlString)
sqlString has been tested working fine under normal JDBC statement call but strange, nothing happened when using the same statement call using session.createSQLQuery. (no error as well)
Note: transaction has been committed after createSQLQuery statement using commitTransaction() method.

Thank you in advance,

Anen Wu