[tcunning]

Dariusz P wrote:

OK. But is there any way that Jboss ESB can listen on SQL table without that status column? I ask because if i have a SQL database that i can't modyfy. And of course i don't have in my tables column responsible for status. Then I simply can use Jboss ESB for listening on that table? Am I wright? Or I dont understand something?

How are you going to tell whether a row has been processed or not?

You've probably got a few options :

- write your own custom listener with whatever polling/update mechanism you desire

- create a view which contains the table data which you can't modify and joins it with some other table of your creation that contains the rowid and the status column, and use that

- use some other mechanism that keeps track of the SQL table data and whether it has been processed and populates a JMS queue or some other transport with that data