Hi I am using a session bean to create CMP EJBs. I am using "Standard CMP 2.x EntityBean with CI in Commit Option C" with cache-invalidation so that I can maintain their state in a cluster. The backend is a sql server database. With asynchronous calls to the session bean to create EJBs, the database quickly deadlocks. I assume this is because sql server is quick to promote to page locking. Even if I strip this down to the bare bones of a home.create(testID) I get database deadlocking if the session bean is invoked from asyncronous threads.
I am thinking that I might need to force all the database calls to go through a single thread. In a cluster that could be to use an HASingleton to single thread all these types of writable calls. Although this does seem to limit the scalablilty of the cluster. Does anyone have any advice on this? Has anyone used sql server succesfully in a CMP environment? Thanks Glyn View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3883528#3883528 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3883528 ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
