Lots and Lots of I/O

scottklakken · **Joined:** Mon Apr 25, 2005 3:55 pm **Posts:** 2

Upon executing the following query, according to the debug log, hibernate is doing something I don't want it to do: performing insert/delete i/o. I'm not sure what the purpose of this is, but is there anyway to stop this behavior?

Thanks

Code:

select e.ID_STAR_ELEMENT as ID_STAR_1_0_, e.APPROVED_STATUS as APPROVED2_0_, e.IS_ACTIVE as IS_ACTIVE0_, e.NAME as NAME0_, e.DESCRIPTION as DESCRIPT5_0_, e.DISPOSITION as DISPOSIT6_0_, e.FK_ELEMENT_TYPE as FK_ELEME7_0_, e.FK_STAR_PROJECT_PHASE as FK_STAR_8_0_, e.FK_ELEMENT_OWNER as FK_ELEME9_0_, e.FK_ELEMENT_APPROVER as FK_ELEM10_0_, s.ID_STAR_SEARCH as ID_STAR_1_1_, s.FK_ENTITY as FK_ENTITY1_, s.ENTITY_TYPE as ENTITY_T3_1_, s.SEARCH_VALUE as SEARCH_V4_1_
from star_element e
inner join jbp_users on (fk_element_owner = jbp_users.jbp_uid)
inner join star_search s on (s.fk_entity   = e.id_star_element
                                  and s.entity_type = ?)
where upper(s.search_value) like upper(?)
and  upper(e.is_active)   like upper(?)
and (upper(e.approved_status) >= ? or jbp_users.jbp_uname = ?)


...

17:14,375 DEBUG SQL:230 - delete from star_element_type_attribute_set where FK_STAR_ELEMENT_TYPE=?
17:14,484 DEBUG SQL:230 - delete from star_element_attribute_value_set where FK_STAR_ELEMENT=?
17:14,484 DEBUG SQL:230 - delete from star_element_attribute_value_set where FK_STAR_ELEMENT=?
17:14,484 DEBUG SQL:230 - delete from star_element_attribute_value_set where FK_STAR_ELEMENT=?
17:14,484 DEBUG SQL:230 - delete from star_element_attribute_value_set where FK_STAR_ELEMENT=?
17:14,718 DEBUG SQL:230 - delete from star_project_attribute_value_set where FK_STAR_PROJECT=?
17:14,765 DEBUG SQL:230 - delete from star_project_type_attribute_set where FK_STAR_PROJECT_TYPE=?
17:14,812 DEBUG SQL:230 - delete from star_element_attribute_value_set where FK_STAR_ELEMENT=?
17:14,859 DEBUG SQL:230 - delete from star_project_attribute_value_set where FK_STAR_PROJECT=?
17:14,921 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:14,921 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:14,921 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:14,937 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,140 DEBUG SQL:230 - insert into star_element_type_attribute_set (FK_STAR_ELEMENT_TYPE, FK_STAR_ATTRIBUTE_SET) values (?, ?)
17:15,187 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,203 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,203 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,359 DEBUG SQL:230 - insert into star_project_type_attribute_set (FK_STAR_PROJECT_TYPE, FK_STAR_ATTRIBUTE_SET) values (?, ?)
17:15,359 DEBUG SQL:230 - insert into star_project_type_attribute_set (FK_STAR_PROJECT_TYPE, FK_STAR_ATTRIBUTE_SET) values (?, ?)
17:15,359 DEBUG SQL:230 - insert into star_project_type_attribute_set (FK_STAR_PROJECT_TYPE, FK_STAR_ATTRIBUTE_SET) values (?, ?)
17:15,515 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,515 DEBUG SQL:230 - insert into star_element_attribute_value_set (FK_STAR_ELEMENT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,625 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,625 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)
17:15,625 DEBUG SQL:230 - insert into star_project_attribute_value_set (FK_STAR_PROJECT, FK_STAR_ATTRIBUTE_VALUE_SET) values (?, ?)

max · **Posted:** Wed May 25, 2005 6:34 pm

dont execute delete and save's before doing the query then ;)

(a more serious answer is to read up on how hibernate works with respect to when it flushes to the database and the different FlushMode's it has)