topic updating db table of other database in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/updating-db-table-of-other-database/m-p/275835#M228965 <HTML><HEAD></HEAD><BODY><SPAN>Hi, first of all i apologize if this has been asked before</SPAN><BR /><SPAN>(i did think so, but could not find any matching topics)</SPAN><BR /><BR /><SPAN>I would like Alfresco to update a 3rd party database based on folder actions (add a node, update a node, delete a node etc).</SPAN><BR /><SPAN>what do i have to do for this?</SPAN><BR /><BR /><SPAN>i assume i need to write some code to encapsulate my sql statement</SPAN><BR /><SPAN>and then attach this code to a folder watch attribute?</SPAN><BR /><BR /><SPAN>or am i waay off with this approach ?</SPAN><BR /><BR /><BR /><BR /><SPAN>thanks,</SPAN><BR /><SPAN>Joe</SPAN></BODY></HTML> Fri, 10 Aug 2012 08:22:38 GMT jrady 2012-08-10T08:22:38Z updating db table of other database https://connect.hyland.com/t5/alfresco-archive/updating-db-table-of-other-database/m-p/275835#M228965 Hi, first of all i apologize if this has been asked before(i did think so, but could not find any matching topics)I would like Alfresco to update a 3rd party database based on folder actions (add a node, update a node, delete a node etc).what do i have to do for this?i assume i need to write some co Fri, 10 Aug 2012 08:22:38 GMT https://connect.hyland.com/t5/alfresco-archive/updating-db-table-of-other-database/m-p/275835#M228965 jrady 2012-08-10T08:22:38Z Re: updating db table of other database https://connect.hyland.com/t5/alfresco-archive/updating-db-table-of-other-database/m-p/275836#M228966 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>basically, that is how you would do it. I'd use a policy or action (or both in cooperation) to react to changes in my content model and then trigger the update. For the SQL layer, you could use the MyBatis framework already included in Alfresco and create your own DAOs to talk to your 3rd party database.</SPAN><BR /><BR /><SPAN>Please keep in mind that while access to a 3rd party database is quite simple, transaction handling across both databases (Alfresco and 3rd party) is totally different story and fully up to you, e.g. you would have to put in place the necessary mechanisms to handle rollbacks and commits correctly yourself, if you want to have transactional consistency / atomicity across both systems.</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Fri, 10 Aug 2012 14:29:13 GMT https://connect.hyland.com/t5/alfresco-archive/updating-db-table-of-other-database/m-p/275836#M228966 afaust 2012-08-10T14:29:13Z