[jboss-user] [JBoss Messaging] - Re: Messaging bridge question

[chip_schoch]

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