[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: JBoss 4.2.1 Optimistic Locking - how to turn on

2009-07-27 Thread PeterJ
There are two possibilities here. First, your database supports optimistic locking in which case you can specify that in your *-ds.xml file. Second, you are using Hibernate for persistence in which case it uses optimistic locking by default unless you can set the optimistic-lock mapping attribut

[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: JBoss 4.2.1 Optimistic Locking - how to turn on

2009-07-27 Thread smith.ge...@gmail.com
Many thanks for the reply. I'm using mysql. So all I have to do is edit the datasource to make the cache use optimistic locking ? I probably should have said I meant in the cache ? Thanks, Gerry Smith View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4246271#424

[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: JBoss 4.2.1 Optimistic Locking - how to turn on

2009-07-27 Thread PeterJ
Which data provider are you using in MySQL? I know that InnoDB does not provide optimistic locking? Cache? Nothing like throwing in yet another term. What cache are you thinking about? Are you perhaps thinking of the caching that Hibernate does, since Hibernate is used to implement JPA? The

[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: JBoss 4.2.1 Optimistic Locking - how to turn on

2009-07-27 Thread smith.ge...@gmail.com
I was referring to JBoss cache, I think I need to do something like this: http://www.redhat.com/docs/manuals/jboss/jboss-eap-4.2/doc/cache/Tree_Cache_Guide/Configuration-Sample_XML_Based_Configuration.html Thanks again, Gerry Smith View the original post : http://www.jboss.org/index.html?modul

[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: JBoss 4.2.1 Optimistic Locking - how to turn on

2009-07-27 Thread smith.ge...@gmail.com
- or upgrade to 5.1 and use MVCC, but I had other problems upgrading the app to 5.0. (obviously I'm getting deadlocks with pessimistic locking) Gerry Smith View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4246290#4246290 Reply to the post : http://www.jboss.o