JDBC Sender - Select Query without Update Query

[Former Member]

In this case, how many times data will be polled within some minutes, if my polling interval is 1 day.

How many messages in sxmb_moni?

Thanks,

Greg

[Former Member · Accepted solution]

>>In this case, how many times data will be polled within some minutes, if my polling interval is 1 day.

The communication channel executes once as soon as you activate your sender communication channel. Now a single msg is sent to XI(with many as many rows as the select query fetches from the db).

After that, it waits for the polling interval(in your case 24 hrs) and then executes again.

This cycle continues. If you resart the communication channel, the cycle is disrupted and a new cycle starts.

Hope I dont add to your confusion

Regards,

Jai Shankar

[Former Member · Accepted solution]

we have selected 1 message per database connection from the advanced mode..

could it have any adverse impact?

[Former Member · Accepted solution]

>>we have selected 1 message per database connection from the advanced mode

Do you mean DIsconnect from database after processing each msg? If so, the answer is no.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Yes i meant the same..

Then what could be the reason for this behaviour

[Former Member · Accepted solution]

Only reason I could think of is restart of communication channel. This can be done in 2 ways.

1. Make some dummy change the communication channel and activate it again.

2. Use stop and start feature in RWB communication channel monitoring.

Regards,

Jai Shankar

[Former Member · Accepted solution]

can u make the 2nd point more clear

[Former Member · Accepted solution]

He mean tht. did you restart communication channel from Runtime Workbench.

RWB->Component Monitoring->Adapter Engine->communication channel monitoring.

From here you can start/stop any communication channel (XI 3.0 SP 17).

Regards,

Gourav

[Former Member · Accepted solution]

Hi Greg... if i understood your question, you are in doubt whether setting parameter "DIsconnect from database after processing each msg " will have adverse effect on your system or not?

If you set this parameter in your sender jdbc channel, database connection will be released and reestablished before every poll interval.It will definitely put extra load on your system especially during high volume scenarios.

[former_member335553]

HI

Poll Interval (secs)

Number of seconds that the adapter must wait if no files are found for processing

I suppose data would be polled once after a day since the poll interval is given as a day

[MichalKrawczyk]

Hi,

>>>>In this case, how many times data will be polled within some minutes, if my polling interval is 1 day.

it will be pulled only once a day.

not in minutes...

Regards,

michal

[Former Member]

does that mean only 1 entry in sxmb_moni for this interface?

in my case i m getting hundreds of entries in sxmb_moni..

what could be the reason??

Message was edited by:

Greg Collins