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

[Mark Little (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-297?page=all ]

Mark Little updated JBESB-297:
------------------------------

        Fix Version/s: 5.0
                           (was: 4.0)
    Affects Version/s: 4.0
                           (was: 5.0)

> 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: Esteban Schifman
>            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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira