Once complete Hibernate mappings/integration is done for OpenNMS (on of the Summer of Code projects) one should be able to hackaround with either hibernate mappings or Spring's AOP (aspects) to do some thing with the transaction management at the core to store stuff to two databases.
But we have lots of coding to cover before that. (I am quite sure storing to two databases can be done through a solution in the relams of Spring/Hibernate, but never tried it or seen any proof of concept) Regards -- Shahzada Hatim (aka geoaxis) http://hatimonline.com On Thu, Apr 10, 2008 at 07:45:07AM -0500, Les Mikesell wrote: > Steven Turner wrote: > > Hi DJG, thanks for the reply I'm only wanting to use one instance of > > OpenNMS which uses only one database but I'm wanting all the information > > from the first database to be mirrored in the second database so that every > > time the 1st database is updated in some way this information is copied > > over to the second which I can then use to extract information from using > > an external application. I don't need OpenNMS to be able to use the data > > from the 2nd database only to duplicate all insert, update and deletion > > operations on it. I looked at triggers initially but these would have to be > > written for every table explicitly defining every field in the database. I > > had thought maybe I could edit a could of the java classes so it would add > > the data to both databases but I don't know where I should be looking. > > ThanksSteven > > > > Can't the other application use the same database? It shouldn't hurt > anything to add additional tables for other data and the same keys to > tie them together. > ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Please read the OpenNMS Mailing List FAQ: http://www.opennms.org/index.php/Mailing_List_FAQ opennms-devel mailing list To *unsubscribe* or change your subscription options, see the bottom of this page: https://lists.sourceforge.net/lists/listinfo/opennms-devel
