Created by: Janine Graves on 03-10-2007 10:33:41 PM Suppose I'm using the DB element and the app server's been configured to have a maximum of, say, 20 connections to the DB. What happens to that 21st concurrent request to use the DB?
Will the app server queue up this request until one of the DB connections is freed?
--If so, then how long will the application wait for a connection before an error is thrown?
--If not, then what event/error does the application experience, and is it immediate?
Subject: RE: max db connections in use Replied by: null on 05-10-2007 03:56:46 PM Hi Janine,
The application server queues up this jdbc connection request until one of the database pooled-connections is freed. Generally, the maximum time of the voice application wait for a jdbc connection before an error is thrown is 30 seconds.
Regards,
Hong
Subject: RE: max db connections in use Replied by: Vance Vagell on 05-10-2007 04:19:25 PM Hi Janine,
To add to Hong's response, another thing to keep in mind is the voice browser's fetchtimeout setting.
If it takes longer than the value specified in that setting for a pool connection to become available to the voice application, the browser will throw an error.badfetch. From the voice browser's perspective it is waiting for a VoiceXML page that takes too long in these scenarios (i.e., it doesn't even know about the connection pool, it just wants a VoiceXML page).
You can change this VoiceXML property as needed in your voice app's properties, or on a per-element basis. However, if this value is increased it's generally a good idea to also set fetchaudio so that the caller hears something while waiting instead of dead air.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
