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:


Can any one pl let me know how to handle with temporary tables thro hibernate.

Regards

Seshadri

In what situation? Normally the matter doesn't crop up: temporary tables don't usually (and really shouldn't) survive long enough for hibernate to get involved. They should be created in a stored procedure, used in that stored procedure, then dropped in that same stored procedure. If you can explain what you're trying to do, I'll try to explain how to get hibernate to do it.

Thanks for ur speedy response.

In our situation , we have to create a temporary table , insert some records into it and use those records.

For the time being, we have implemented like this
1. Obtain Hibernate Session.
2. Thro this session, obtain the JDBC connection
3. Execute the statement using JDBC statement

Is there any other better approach. Or pl let me this approach is ok.

Regards

Seshadri

That will work, and it's probably how I'd do it (if I had to). If your temporary table always has the same name, then you can map to it as normal, but you'll have to be careful about clearing the session cache when you drop the table (if anything tries to write to a table after it's dropped, something's going to get confused).

Thank you very much.