We're getting unique constraint violations with JMS messaging and Oracle (9 & 10 we've tried both). This isn't happening often, and we're not sure what exactly is making JBoss re-use the same primary key. There is only one instance of JMS accessing the database. We're using JBoss Messaging 1.0.1.CR2.
Here's the sql that JBoss uses to put a message into the database: INSERT INTO JMS_MESSAGE (MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES, DESTINATION_ID, REPLYTO_ID, JMSPROPERTIES) VALUES (466672, 'Y', 0, 1153260324109, '4', '', '[EMAIL PROTECTED]', 1, '5', '', '', '', 0, '', '') Then about an hour later, another message with the same primary key was sent to the database: INSERT INTO JMS_MESSAGE (MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES, DESTINATION_ID, REPLYTO_ID, JMSPROPERTIES) VALUES (466672, 'Y', 0, 1153264744496, '4', '', '[EMAIL PROTECTED]', 1, '5', '', '', '', 2, '', '') I've searched the forums, someone else is getting the same error but not sure what DB they are using, and there weren't any ideas there. http://www.jboss.org/index.html?module=bb&op=viewtopic&t=85368&view=previous If anyone has any ideas of what would cause this I would appreciate the input. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3960557#3960557 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3960557 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
