[jboss-user] [JBossMQ] - Re: JMS Persistence Manager Exception

Hi Adrian, I ran into the same situation where I have load balancer environment and both instances are trying to create entry into JMS_MESSAGES table with the same primary key. The exception that I am getting is : org.jboss.mq.SpyJMSException: Could not store message: 4276 msg=4275 hard NOT_STORED PERSISTENT queue=QUEUE.DLQ priority=4 lateClone=false hashCode=10168191; - nested throwable: (com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4275-QUEUE.DLQ' for key 'PRIMARY') | Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '4275-QUEUE.DLQ' for key 'PRIMARY' | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) I am using JBoss 4.2.3 and MySql to store JMS messages. I could not understand about creating multiple persistence managers. I am also wondering as this is a thread of 5 years old, you might have come across a better solution. Please let me know. Thanks, Subhash View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4226686#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...