Hi I have a question regarding locking policy in jboss. I am using an oracle database. Now what I am doing is, I am updating a set of records from oracle using normal JDBC Connection (using a datasource of course), from an MDB.The update operation takes some time since there are a number of records. Meanwhile i m trying to update the same set of reocords from another thread,(which can be a java program or a normal sql plus window) but this updation wont happen unless the transaction in the MDB completes. So for this(since i know the default locking policy is Pessimistic), i made the locking policy as Optimistic, and I assume that the above scenario should work.But this does not work. Can any one explain why this is not working. I have pasted my jboss.xml below
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jboss PUBLIC "-//JBoss//DTD JBOSS 3.0//EN" "http://www.jboss.org/j2ee/dtd/jboss_3_2.dtd"> <enterprise-beans> <ejb-name>FilterBuilderService</ejb-name> <local-jndi-name>mercury-catalog-admin-1.0/ejb/com.ketera.catalog.service.FilterBuilderService</local-jndi-name> <message-driven> <ejb-name>CacheBuilderMDB</ejb-name> <destination-jndi-name>queue/CatalogQueue</destination-jndi-name> </message-driven> <container-configurations> <container-configuration> <locking-policy>org.jboss.ejb.plugins.lock.JDBCOptimisticLock</locking-policy> </container-configuration> </container-configurations> </enterprise-beans> View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3925335#3925335 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3925335 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user