RE: Can we remove the already published message to the topic

Nope. There should be, but its not been a itch
of mine. 
For persistent messages, you could write some SQL
to remove the entries from message_handles and messages.

You would need to select on the "expirytime" column,
which represents the expiration date-time of the message
in milliseconds.
E.g (off the top of my head):
	# selects all message identifiers with a particular expiry time 
	select messageid from messages where expirytime="<some expiration
time>";

      # selects all message identifiers with a particular expiry time and
      # destination
	select messageid 
      from messages m, destination d
      where m.expirytime = "<some expiration time>"
            and m.destinationid = d.destinationid
            and d.name = "<some destination name>"

	# remove all references to a particular message
	delete from message_handles where messageid = "<some messsage id">
	delete from messages where messageid = "<some messsage id">

-Tim

> -----Original Message-----
> From: openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org 
> [mailto:openjms-user-admin-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org] On Behalf 
> Of Sale Rahul
> Sent: Tuesday, 10 May 2005 1:01 AM
> To: [email protected]
> Subject: [openjms-user] Can we remove the already published 
> message to the topic
> 
> 
> Hello All,
> We have a requirement where in we want to remove the
> message, before it reaches to the expiry date. 
> e.g. Say someone publish a message M1 to topic T1 with
> expiry date as 15 May 2005, but after some time say on
> 12 May 2005, Administrator wants to delete/remove that
> message from the topic. Then what is an API which will
> allow us to do so ?
> 
> Thanks in advance.
> 
> 
> With Regs
> Rahul SAley
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Read only the mail you want - Yahoo! Mail SpamGuard. 
> http://promotions.yahoo.com/new_mail 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: NEC IT Guy Games.
> Get your fingers limbered up and give it your best shot. 4 
> great events, 4 opportunities to win big! Highest score 
> wins.NEC IT Guy Games. Play to win an NEC 61 plasma display. 
> Visit http://www.necitguy.com/?r=20 
> _______________________________________________
> openjms-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/openjms-user
> 



-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click