poolWaiting Time

[Former Member]

Hi All,

Anybody expalin about *poolWaiting Time* in JDBC recevier communication channel configuration under Additional parameters.

Thanks in advance

Common Guys .... Michael, Sravya , Bhavesh,..can anybody help me out

Edited by: sri_rambo on Jul 16, 2009 11:04 AM

Edited by: sri_rambo on Jul 16, 2009 11:05 AM

Edited by: sri_rambo on Jul 16, 2009 11:07 AM

Edited by: sri_rambo on Jul 16, 2009 11:09 AM

[former_member200962 · Accepted solution]

>

> Hi All,
> 
> Anybody expalin about *poolWaiting Time* in JDBC recevier communication channel configuration under Additional parameters.
> Thanks in advance
> 
> 
> Common Guys .... Michael, Sravya , Bhavesh,..can anybody help me out
> 
> Edited by: sri_rambo on Jul 16, 2009 11:04 AM
> 
> Edited by: sri_rambo on Jul 16, 2009 11:05 AM
> 
> Edited by: sri_rambo on Jul 16, 2009 11:07 AM
> 
> Edited by: sri_rambo on Jul 16, 2009 11:09 AM

at least give us some time

Check this SAP note on JDBC:

https://service.sap.com/sap/support/notes/831162

Q28 anwers your issue

From the note:
This timeout value will define the maximum waiting time to get the connection from resource pool. If connection is not available 
within this time, we return the message to Messaging System and the message is in retry mode.

Edited by: abhishek salvi on Jul 16, 2009 2:50 PM

[Former Member · Accepted solution]

Hi Abhishek, Sorry for hurry thanks for your response, is there any chance that this option will control the process ,once timeline has reaced will the CC will stop the process

Edited by: sri_rambo on Jul 16, 2009 11:33 AM

[Former Member · Accepted solution]

Any Light guys

[former_member200962 · Accepted solution]

>

> Hi Abhishek, Sorry for hurry thanks for your response, is there any chance that this option will control the process ,once timeline has reaced will the CC will stop the process
> 
> Edited by: sri_rambo on Jul 16, 2009 11:33 AM

The message will go into retry state.....when the max retries, of the CC, has been reached the message will be termed as errored (if not wrong it will be cancelled with errors)......good option to use when you have many JDBC receive CCs accessing the same DB.....

So answer is yes this parameter will control the process and the process will be stopped once the limit is reached

Regards,

Abhishek.

[Former Member]

its PI 7.0 version Ravi.

[Former Member]

Hello,

I cant find this pool/waitingtime in standard JDBC adapter.

which version ur using?

Thanks,

Phani

[former_member200962]

this is not a standard option

IN JDBC receiver CC ---> Parameters ---> Advanced ->Check Advance Mode->make entry as poolWaitingTime --->give value in Msecs

[former_member181962]

Hi,

Which version of PI are you on?

Regards,

ravi