JDBC Sender Polling Interval

[Former Member]

Hi All,

What is the maximum limit of the poll interval to be specified in JDBC sender.

We had faced some problem when we give a 9 or 10 digit polling interval.

But when we give something near to 6 7 digits, its working fine

Any such practical situations handled by any1?

Thanks,

Greg

[Former Member]

Hi Greg Collins,

There is no such problem while specifying the poll interval.Your server may be slow to pick up the file.

Regards,

Manikandan.S

[Former Member]

No server problem.. The problem we r facing it when we specify a large polling interval, server is polling the database more than once

[MichalKrawczyk]

Hi Greg,

give a small number (minute or so) and schedule the adapter via RWB

to start it once a day or once a week

/people/shabarish.vijayakumar/blog/2006/11/26/adapter-scheduling--hail-sp-19-

this approach will have much better performance

Regards,

michal

[Former Member]

Thanks Michal

But wht would be the problem if for poll interval of 1 day, i m providing 24 * 3600 seconds??

And r u suggesting that for poll interval of a day or week i should not be dependent upon polling?