confirming that referential integrity is not possible.

[vincenttran]

The DBA asked me to put referential integrity onto the JBossMQ tables.

From what I have learned it is not possible because:

JBossMQ inserts/updates/etc to the database Asynchronously.
It would involve knowing the implementation of JBossMQ, and the order it puts data into the tables/etc.

I'm trying to build a strong case. I wish I had a JBoss lawyer :)

[vincenttran]

Second reason is that it adds overhead and decreases performance.

[genman]

Adding ref. integrity might not hurt performance that much and might work okay actually.

You can find the SQL statements in the source code to org.jboss.mq.pm.jdbc2.PersistenceManager .

[genman]

Er, the SQL statements are in the .xml file, the order and use are in the class file.