I am trying CR2 but after the first time I start the server, whenever I restart I get a duplicate key exception on JBM_DUAL. It looks like it is executing the insert on startup and the insert is :
INSERT_DUAL=INSERT INTO JBM_DUAL VALUES (1) The table creation: CREATE_DUAL=CREATE TABLE JBM_DUAL (DUAL_DUMMY INTEGER, PRIMARY KEY (DUAL_DUMMY)) I don't know what the objective of this is so I really don't know how INSERT_MESSAGE_CONDITIONAL=INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, TYPE) SELECT ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?) would work. This is from the sybase-persistenc.xml file. I anticipate being enlightened. Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4080135#4080135 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4080135 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
