I successfully setup JMS to cache messages to Oracle, and saw that it worked by setting my memory marks artificially low. The questions is, how long do these messages stay around in the database? The messages have no time to live set, and they are not set to be durable. I thought they would be flushed on server restart, but they were not. I guess my real concern is how large is the JMS_MESSAGES table likely to get?
I am using 3.2.1 with JDK 1.4 and Oracle 9.
Do you have subscriptions to this topic. If that is the case and the messages are not delivered to the subscriber they will hang around for ever i guess.
Have a look at