SqlTablePoller released? Is there examples?

[brown078]

Hello all,
I am currently using the gpListener on a directory to send out EDI messages. We have a need to go to a database format instead of file based. I was looking around in polling tables and saw a few test scripts here and there.
Is this type of listener still in testing, if not are there any examples on its usage?

Thanks
Damon

[tfennelly]

Hi Damon.

The SqlTablePoller should work for you. Depending on the version of the ESB you are using, you may need to implement the actionClass by extending org.jboss.soa.esb.actions.AbstractSqlRowAction.

Are you using JBossESB 4.0 Beta1 from a download, or are you using the latest codebase from Subversion? The Action/Listener model has changed slightly since Beta1 so if you can tell us which you are using...

[brown078]

Thanks for the reply,
Im currently using the Beta 1 version. Do you have any examples of its usage?

Thanks!
Damon

[tfennelly]

"brown078" wrote:
Thanks for the reply,
Do you have any examples of its usage?

We're a little short on clean examples in some areas at the moment - sorry about that. However, there is a QA test (using JUnit) that runs the SqlTablePoller. It should be of use to you...

http://anonsvn.labs.jboss.com/labs/jbossesb/tags/JBESB_4_0_Beta1/qa/junit/src/org/jboss/soa/esb/listeners/SQLTablePollerTest.java