Hi, There are requirements to do additional operations when there are changes done to organization data.
One way to do this is to create triggers at database level. However there are limitations on actions users can perform using triggers. So if we implement custom inbound endpoint we can cover most of the use cases. [image: Inline image 1] There are several ways to do that. But we already know using JDBC is impossible at the moment. One way to achieve this is implementing a polling inbound to monitor the changes in the database object (such as a table in the database). If any change occurred, that inbound can invoke a sequence. But this is not a good practice. What if your database has more than ten tables? Then users have to create ten threads for each table and that would be a great mess regarding to the performance. There are also vendor specific solutions provided. [1] [2] JPA also provide this capability [3] However with this users need to create entities for there environment and using those with ESB is complex. Using Hibernate we can do the same and maintain the configuration in XML. Thoughts about this inbound are welcome? [1] http://stackoverflow.com/questions/12618915/how-to- implement-a-db-listener-in-java [2] http://www.ibm.com/support/knowledgecenter/SSSHYH_5.1.1/com.ibm. netcoolimpact.doc5.1.1/solution/imsg_db_listeners_ database_listener_overview_c.html [3] https://docs.jboss.org/hibernate/entitymanager/3.6/ reference/en/html/listeners.html [4] https://dunithd.wordpress.com/2009/10/27/create-database- triggers-like-features-using-hibernate-events/ Best Regards, Malaka Silva Senior Technical Lead M: +94 777 219 791 Tel : 94 11 214 5345 Fax :94 11 2145300 Skype : malaka.sampath.silva LinkedIn : http://www.linkedin.com/pub/malaka-silva/6/33/77 Blog : http://mrmalakasilva.blogspot.com/ WSO2, Inc. lean . enterprise . middleware https://wso2.com/signature http://www.wso2.com/about/team/malaka-silva/ <http://wso2.com/about/team/malaka-silva/> https://store.wso2.com/store/ Don't make Trees rare, we should keep them with care
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
