[esb-issues] [JBoss JIRA] Assigned: (JBESB-297) Need for an SQL gateway that does not require altering 'legacy' data in any way

Need for an SQL gateway that does not require altering 'legacy' data in any way ------------------------------------------------------------------------------- Key: JBESB-297 URL: http://jira.jboss.com/jira/browse/JBESB-297 Project: JBoss ESB Issue Type: Feature Request Security Level: Public(Everyone can see) Components: Rosetta Affects Versions: 4.0 Reporter: Esteban Schifman Assigned To: Mark Little Priority: Minor Fix For: 5.0 Original Estimate: 4 days Remaining Estimate: 4 days Kurt has made a very valid point a couple of days ago regarding sql gateways. Current SQL gateway requires an 'ad hoc' column in the watched table as an access indicator to avoid concurrency problems and repeated processing of the same event Many legacy applications do not allow tampering with their data model, not even to have your own stored procedures in place, We should try and find a way to have a version of the SqlTableListener that can work without the need to alter in any way (updating, deleting, adding stored procedures, etc.) the legacy database This alternative would also allow to watch legacy 'views' (instead of simply db tables), thus broadening the scope of use of sql gateways. Configuration will be somewhat more complex than our current sql gateway, but I think it's really worthwhile.