Manual/Programatical OpenJMS DB manipulation
"Hemant Gaur" <[email protected]> 18 Apr 2007 05:16:17 -0000
| Newsgroups | gmane.comp.java.openjms.user |
|---|---|
| Message-ID | <[email protected]> |
Hi, OpenJMS latest release version (0.7.6.1). Actuallty I want to create a script/java, which can clean up the data base which do not have the expiration time in the messages, for the messages older than say 1 week. I plan to do this using JDBC (reading the JMS config file)and hence generic to many databases. The need for this feature arises because a.) Non-subscribed topic messages are not cleared in DB. b.) Keep the DB size in control without making any change in the existing JMS implementaion. c.) Scalability issues with the various light-weight databases and OpenJMS. In OpenJMS last release version (0.7.6.1), after stopping the JMS server. 1.) Is it safe to delete the messages from the messages table which have no corresponding entry in the message_handles ? 2.) Can also the related messages set determined my message_id's can be deleted from the both tables. Say delete the entries for particular message in both the tables. Thanks in anticipation for any inputs provided. Regards, -hemant ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ openjms-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openjms-user