I would like to use JBoss ESB to transfer data from one 3rd Party App to another whenever Data is Changed in the SQL Tables of the first Application.
I do have hibernate mappings and configurations to both Data Layers from a previous development project, as well as access to the SQL Tables.
From what I read the Hibernate Listener is only capable of detecting changes to the data that has been initialized by hibernate (not applicable in case of these 2 Applications).
So I took a look at the SQL Provider and SQL Listener, hoping I could configure polling a time-stamp based custom SQL Query.
The SQL Provider however requires a Status Column and a single message column.
I can not extend the Tables in my 3rd Party Apps so I can not provide a writeable status Column. Also I was hoping to get the whole Row in a Message for further transformation and not just one column.
My guess is, I am missing the point or am just trying to use stuff in a way it is not designed for.
Anyone have some suggestion, what a best practice approach to my problem is?
Is there a part of documentation (that I have missed so far) that describes the purpose of each Listener Type, not just the syntax of its configuration?
Kolja, I'm not sure what database you are using - are views available? I think you have pointed out some of the limitations of the SQL gateway, but there may be ways to work around them.