Turn off JMS persistense

[bul]

"bul" wrote:
I use JBoss 3.2.3 + MySQL 4.0.17
I want to turn off JMS persistence. I don't want JMS_MESSAGES and JMS_TRANSACTIONS tables in a database.
I searched through 'Messaging, JMS & JBossMQ' topics. I found the answer that DeliveryMode.NON_PERSISTENT should be added as queueSender.send() parameter.
I tried this (see the code).
<
QueueConnectionFactory connectionFactory = getConnectionFactory();
Queue queue = getQueue();
connection = connectionFactory.createQueueConnection();
session = connection.createQueueSession(false, Session.AUTO_ACKNOWLEDGE);
QueueSender queueSender = session.createSender(queue);
ObjectMessage message = session.createObjectMessage();
message.setObject(obj);
queueSender.send(queue,
message,
DeliveryMode.NON_PERSISTENT,
Message.DEFAULT_PRIORITY,
Message.DEFAULT_TIME_TO_LIVE);
>

BUT(!) MySql logs CONTAIN many sql queries to JMS_MESSAGES and JMS_TRANSACTIONS tables (see log part)
<
8 Query INSERT INTO JMS_TRANSACTIONS (TXID) values(3)
8 Query commit
8 Query DELETE FROM JMS_MESSAGES WHERE TXID=3 AND TXOP='D'
8 Query DELETE FROM JMS_TRANSACTIONS WHERE TXID = 3
8 Query commit
>

How could I TURN OFF JMS persistence in JBoss 3.2.x ?

[hosierdm]

"hosierdm" wrote:
I don't think that you can turn it off. I wanted to do the same thing, and I was told by JBoss that there is no concept of a NULL persistence manager. I don't know why it still goes to the database even if you set your message to not be persisted.

-David

[genman]

"genman" wrote:

There was a persistence manager that didn't do anything. It was checked into the 3_2 branch but for some reason never tagged and released as any distribution.

http://cvs.sourceforge.net/viewcvs.py/jboss/jbossmq/src/main/org/jboss/mq/pm/none/Attic/PersistenceManager.java

What I would do would be to D/L this class, modify it (if you want to), compile it, and configure to use it in the appropriate service.xml file.

[adrian.brock]

The null persistence manager referred to by genman lets you turn off persistence
(and caching if you like).
It is only in jboss-3.2.4 (as yet unreleased)
You can get it from a source snapshot or cvs

Regards,
Adrian