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#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...