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

[Lakshmeepathi Ghiree Anandh]

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 :

ID      NAME            PARENTID

1   User Services        NULL
2   Desktop Services      1
3   Laptop Services        1

<hibernate-mapping>
	<class name="com.tcs.servicecatalog.hibernate.pojo.ScServiceMaster"
		table="SC_SERVICE_MASTER">
		<id name="id" type="integer">
			<column name="ID" />
			<generator class="assigned" />
		</id>
		<property name="name">
			<column name="NAME" />
		</property>
		
		<property name="parentId">
			<column name="PARENT_ID" />
		</property>
				
		<set name="children" table="SC_SERVICE_MASTER" inverse="true" lazy="false" fetch="select">
            <key>
                <column name="PARENT_ID"  />
            </key>
            <one-to-many class="com.tcs.servicecatalog.hibernate.pojo.ScServiceMaster" />

        </set>

	</class>
</hibernate-mapping>

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

ScServiceMaster sTree;
for(ScServiceMaster sTreeChild : sTree.getChildren())

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 :

ID      NAME            PARENTID

1   User Services        NULL
2   Desktop Services      1

Now,the code

sTree.getChildren()

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]

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:

@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.EAGER)
    @JoinColumn(name="CUST_ID")
    @Sort(type = SortType.COMPARATOR, comparator = TicketComparator.class)
    @Where(clause="1=1")
    @OnDelete(action=OnDeleteAction.CASCADE)
    public SortedSet<Ticket> getTickets() {
        return tickets;
    }