[EJB/JBoss] - EJB 3 CMP Transaction
by ttza
I am using CMP EJB3 on Jboss 4.2, my tables are getting locked while CMP process is getting executed. If I use BMP then there is no such locking.
My database server is SQL Server 2005 and I have the following settings in the persistance.xml file
<persistence>
| <persistence-unit name="foo">
| <jta-data-source>java:/fooDS</jta-data-source><properties>
| <property name="hibernate.hbm2ddl.auto" value="none" />
| <property name="hibernate.ejb.cfgfile" value="/hibernate.cfg.xml" />
| <property name="hibernate.connection.isolation" value="2" />
| </properties>
| </persistence-unit>
| </persistence>
As above mention i did have isolation set up to Read_commited but still iam unable to do any query on the table if they are used in CMP process.
Just for information we recently migrated our transaction from hibernate to EJB3 and in the process we upgraded jboss from 4.0 - 4.2 Is there any setting that we missed at our end .Please advise,
Our whole application seems to be falling apart because of this locking issues.
Best Regards,
Trapti
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4231507#4231507
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4231507
17 years, 2 months
[Clustering/JBoss] - Re: Session replication with sticky session
by sureshrk19
Hi Sushant,
The problem I'm facing is;
when I enable sticky session (in workers. properties) then session replication doesn;t work as expected.
i.e., when I shutdown "node1" (all the requests are going to this node till now0 then, the next request from browser (thru apache/mod_jk) fos to "node2" but, the code which tries to read session data was set by "node1" is null.
eg: I stored username/pwd (on login) in session (thru node1) but, when I try to retrieve the same data from node2.... returns null.
My understanding is: when we enable session stickiness; the session data might be cached at "node1" (may be for better perf.).. and the same is tied to "node1" forever. I'm not sure on this.. I may be wrong. I'm stuck at this point now.
session stickiness works fine for me.
Also, when I disable session stickiness, session replication works fine i.e., the requests are going to random nodes with full session data.
Thanks,
Suresh
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4231503#4231503
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4231503
17 years, 2 months