This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Hibernate Mapping For Temporary Table, How to create and use a temporary table?

 
Lakshmeepathi Ghiree Anandh
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Let me tell why I need a temporary table although I don't know how to create and use one in Oracle 10.

Following is the table and its values :






PARENT_ID is a foreign key to ID and both are in the same table.



Say sTree Object has the values of the row belonging to 'User Services (ID =1)'

sTree.getChildren() will return rows that has ID=2 and ID=3.

So far so good.

But based on some condition(where or join condition) I will limit the number of rows of the above table and say it looks like the following :




Now,the code


should return rows that has only ID=2.


In short,
1) I need the hibernate <one-to-many> mapping to act on the result set.
2) If not the result set should be inserted in a temporary table and the hibernate <one-to-many> mapping should act on that table.


If neither of them can be done,please suggest me another solution.

Thanks in advance.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I wouldn't use a temporary table for this. It is common to want to get only some rows from a table. That's what the "where" clause is for.

You could use a separate named query that does what you want. Or you could use @Where annotation with @OneToMany. An example copied from section 2.4.6 of the documentation is:
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic