Hi all,
I have a problem where hibernate is automatically setting the foreign key value to null after the objects are used. It is quite bizarre. As far as I know in my code I do not set them to null at any point or delete them.
I have a Search and a SearchItem object. They are used to display search criteria on a jsp page. I go and get the objects and use them the first time. Everything is fine. But, when I try to use them again the SearchItem objects no longer exist because somehow their foreign key values have been set to null.
They are still in the database. The rows do not get deleted. But their foreign key which links them to Search is null
Things to note: I create a sessionfactory and place it in JNDI. Then, whenever I need a session I use that sessionFactory with .openSession(). I never close() the session out because I want to take advantage of the laziness. (I think this is the correct way of going about doing things but may be wrong)
Any help greatly appreciated.
Hibernate version:
Whichever version comes with JBoss 4.0.2. I think its hibernate 2.1 but may be wrong.
Mapping documents:
SEARCH OBJECT
<class name="com.camp.common.search.Search" table="tblSearch">
<id name="searchID" type="integer">
<column name="id_search" sql-type="integer" not-null="true"/>
<generator class="sequence">
<param name="sequence">tblsearch_id_search_seq</param>
</generator>
</id>
<property name="searchName">
<column name="name" sql-type="char(128)" not-null="true"/>
</property>
<property name="searchDisplayName">
<column name="display_name" sql-type="char(128)" not-null="true"/>
</property>
<set name="searchItems" sort="com.camp.common.search.SearchItemComparator" >
<key column="fk_id_search"/>
<one-to-many class="com.camp.common.search.SearchItem"/>
</set>
</class>
SEARCHITEM OBJECT
<class name="com.camp.common.search.SearchItem" table="tblSearchItem">
<id name="searchID" unsaved-value="null">
<column name="id_search_item" sql-type="integer" not-null="true"/>
<generator class="sequence">
<param name="sequence">tblsearchitem_id_search_item_seq</param>
</generator>
</id>
<property name="objectClass" type="string">
<column name="object_class" sql-type="char(64)" not-null="true"/>
</property>
<property name="objectSetField" type="string">
<column name="object_Set_field" sql-type="char(128)" not-null="true"/>
</property>
<property name="objectField" type="string">
<column name="object_field" sql-type="char(128)" not-null="true"/>
</property>
<property name="userObjectFieldName" type="string">
<column name="user_object_field_name" sql-type="char(64)" not-null="true"/>
</property>
<property name="displayName" type="string">
<column name="display_name" sql-type="char(64)" not-null="true"/>
</property>
<property name="type" type="string">
<column name="type" sql-type="char(64)" not-null="true"/>
</property>
<property name="viewType" type="string">
<column name="view_type" sql-type="char(64)" not-null="true"/>
</property>
<property name="position" type="integer">
<column name="position" sql-type="integer" not-null="true"/>
</property>
<many-to-one name="search" class="com.camp.common.search.Search" column="fk_id_search" not-null="true"/>
</class>
Code between sessionFactory.openSession() and session.close():
Context ctx = new InitialContext();
sessionFactory = ((SessionFactory) ctx.lookup("java:/CAMP/HibernateFactory")).openSession();
session.setFlushMode(FlushMode.ALWAYS);
session.setCacheMode(CacheMode.REFRESH);
Session sess = sessionFactory.openSession();
Criteria crit = sess.createCriteria("com.camp.common.search.Search");
entities = crit.list();
log.info("Finished getting entities");
Note that I never call session.close() because I want to keep it open all the time
Name and version of the database you are using:
Postgres 8.0
The generated SQL (show_sql=true):
This is the SQL that SHOULDN'T happen but does automatically
"update tblSearchItem set fk_id_search=null where fk_id_search=?"
Debug level Hibernate log excerpt:
Login
FAQ
Search
