[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Optimistic locking with Hibernate and JCache

[kresho]

Hibernate 3.1, Jboss 4.0.3SP1

I'm trying to get optimistic locking to work, but with no luck.

I'm using Jboss cache 1.4. Configuration of cache and session factory:
<server>
  |     <mbean code="org.jboss.cache.TreeCache" name="jboss.har:service=HarSecondLevelCache">
  |     	<attribute name="CacheMode">LOCAL</attribute>
  |     	<attribute name="TransactionManagerLookupClass">org.jboss.cache.JBossTransactionManagerLookup</attribute>
  | 		<attribute name="NodeLockingScheme">OPTIMISTIC</attribute>
  | 		<attribute name="EvictionPolicyConfig">
  | 			<config>
  | 				<attribute name="wakeUpIntervalSeconds">5</attribute> 
  | 				<!--  Cache wide default --> 
  | 				<region name="/_default_">
  | 					<attribute name="maxNodes">50000</attribute> 
  | 					<attribute name="timeToLiveSeconds">1000</attribute> 
  | 					<!-- Maximum time an object is kept in cache regardless of idle time -->
  | 					<attribute name="maxAgeSeconds">600</attribute>
  | 				</region>
  | 			</config>
  | 		</attribute>
  | 	</mbean>
  | 	<mbean code="org.jboss.hibernate.jmx.Hibernate" name="jboss.har:service=Chip_HB_LOCAL">
  | 		<attribute name="DatasourceName">java:/jdbc/ChipDS_LOCAL</attribute>
  | 		<attribute name="Dialect">org.hibernate.dialect.PostgreSQLDialect</attribute>
  | 		<attribute name="SessionFactoryName">java:/hibernate/ChipHB_LOCAL</attribute>
  | 		<attribute name="CacheProviderClass">org.jboss.hibernate.cache.DeployedTreeCacheProvider</attribute>
  | 		<attribute name="DeployedTreeCacheObjectName">jboss.har:service=HarSecondLevelCache</attribute>
  |   		<attribute name="ReflectionOptimizationEnabled">false</attribute>
  | 		<attribute name="MaxFetchDepth">1</attribute>
  | 		<attribute name="ScanForMappingsEnabled">true</attribute>
  | 		<attribute name="StatGenerationEnabled">true</attribute>
  | 		<attribute name="ShowSqlEnabled">false</attribute>
  | 		<!--attribute name="Hbm2ddlAuto">update</attribute-->
  | 	</mbean>
  | </server>
  | 

Here is my class that I expect to be optimistically locked:
/*
  |  * $Id$
  |  */
  | package hr.chipoteka.erp.data;
  | 
  | import java.util.Date;
  | 
  | /**
  |  * @hibernate.class lazy = "false" dynamic-update = "true"
  |  */
  | public abstract class Analitika extends DataObject {
  | ...
  | 
  | 	/**
  | 	 * @hibernate.version type = "timestamp"
  | 	 */
  | 	public Date getTs() {
  | 		return ts;
  | 	}
  | 
  | 	public void setTs(Date ts) {
  | 		this.ts = ts;
  | 	}
  | }

and one subclass:

package hr.chipoteka.erp.data.artikl;
  | 
  | import hr.chipoteka.erp.data.Analitika;
  | import hr.chipoteka.erp.data.SlimDataObject;
  | import hr.chipoteka.erp.data.osoba.PoslovniPartner;
  | import hr.chipoteka.erp.data.osoba.adresa.Drzava;
  | 
  | import java.util.*;
  | 
  | /**
  |  * @hibernate.union-subclass lazy = "false" dynamic-update = "true"
  |  */
  | public class Artikl extends Analitika implements SlimDataObject {
  | ...
  | }

Generated hbm.xml looks like this:
?xml version="1.0" encoding="UTF-8"?>
  | 
  | <!DOCTYPE hibernate-mapping PUBLIC
  |     "-//Hibernate/Hibernate Mapping DTD 3.0//EN" 
  |     "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
  | 
  | <hibernate-mapping
  | 
  | >
  | 
  |     <class
  |             name="hr.chipoteka.erp.data.Analitika"
  |             lazy="false"
  |             dynamic-update="true"
  |     >
  | 
  | ...
  | 
  |         <version
  |             name="ts"
  |             column="ts"
  |             type="timestamp"
  |         />
  | 
  | ...
  | 
  |     <union-subclass
  |         name="hr.chipoteka.erp.data.artikl.Artikl"
  |             dynamic-update="true"
  |             lazy="false"
  |     >
  | 
  | ...
  | 
  |     </union-subclass>
  | ...
  |    </class>    
  | 
  | </hibernate-mapping>
  | 

I use hibernate within stateless session beans.

When running some HQL queries, I stop jboss at a breakpoint and check locks in the database (postgres):


select pg_class.relname,pg_locks.locktype, page, tuple, transaction, pid, mode, granted from pg_class,pg_locks where pg_class.relfilenode=pg_locks.relation and pid = 31761 order by relname;
  |     relname    | locktype | page | tuple | transaction |  pid  |      mode       | granted
  | ---------------+----------+------+-------+-------------+-------+-----------------+---------
  |  artikl        | relation |      |       |     5378326 | 31761 | AccessShareLock | t
  | (1 rows)
  | 

What am I doing wrong?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3981510#3981510

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3981510