I've been trying to get JDBC persistence to work for topics, and was able to get both the jdbc2 and jdbc3 pms working with mysql. The only thing is, I'm not sure if I have things configured correctly because I don't see messages or references getting deleted. My understanding was that the message table would only keep a message around until every subscriber had received it. It looks like the messages are kept in the table forever, with no way to remove them without automating some kind of script. Without removing those messages, you could easily end up with a huge table filled with messages (the system I'm working on fires a message for most common system events and can easily produce a lot of object messages).
Is the design of the pms to keep the messages around? if so, what is the justification? If not, what could I be doing wrong?
PS as a peace offering, I've got two things:
1) I have a working example for the sql attributes for mysql using the jdbc3 pm. I wasn't able to find one anywhere, so I updated the default jdbc3 config myself and made the necessary adaptations for mysql. I can post it if anyone is interested.
2) I found a bug in the jdbc3 pm that will consistently cause a npe to be thrown on system startup. In the "removeMarkedReferences" method, there is the following line:
// Delete all the non persistent references that were added by the // CacheStore interface of this PM removeMarkedReferences(c, null, "T");
if (txid == null) stmt.setNull(1, Types.INTEGER); else stmt.setLong(1, txid.longValue());
We are using JBoss 3.2.5 in production Enviorment . Oracle is used medium as persistence for JMS Messages. i have also encountered the same problem when i use JDBC 3 . even JDBC 2 entries in the tables does not get deleted after sending to message to all the clients.
What is usage of JMS_REFERENCE_LOG table. what is the solution to this problem .