|
|
Rank: Senior Midnight Coder
Groups: Member
Joined: 11/21/2009
Posts: 79
Points: 237
Location: New Zealand
|
Hi,
Is there any way to increase the default SQL Connection Timeout from 30 seconds? Perhaps an undocumented setting in the wdm.config connection setting?
Cheers,
Rob.
|
|
Rank: Senior Midnight Coder
Groups: Member
Joined: 11/21/2009
Posts: 79
Points: 237
Location: New Zealand
|
I know 30 seconds seems like a long time but we have created triggers on table inserts, etc. that require a large amount of processing - creating invoices etc. For large customers with hundreds of clients this can take longer than 30 seconds and they get a command timeout.
It appears that there is no way to set the command timeout through webORB configuration.
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 9/10/2009
Posts: 320
Points: 778
Location: US
|
robo wrote:I know 30 seconds seems like a long time but we have created triggers on table inserts, etc. that require a large amount of processing - creating invoices etc. For large customers with hundreds of clients this can take longer than 30 seconds and they get a command timeout.
It appears that there is no way to set the command timeout through webORB configuration. Hi, you can increase a timeout parameter in the you_dll_name.dll.config file located in the bin directory. For example, for the TestAssembly.dll the config file is TestAssembly.dll.config and it contains the following: Code:
< ? xml version="1.0" encoding="utf-8" ? >
< configuration >
< connectionStrings >
< add name="TestDB" connectionString="server=JOHNDOE-PC\HELPDESK;user id=testname;password=testpass;database=ProActivity;connect timeout=50;" / >
< / connectionStrings >
< / configuration >
|
|
Rank: Senior Midnight Coder
Groups: Member
Joined: 11/21/2009
Posts: 79
Points: 237
Location: New Zealand
|
Thanks Cyril. That helps. Any option to set command timeout as well?
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 9/10/2009
Posts: 320
Points: 778
Location: US
|
|
|
Rank: Senior Midnight Coder
Groups: Member
Joined: 11/21/2009
Posts: 79
Points: 237
Location: New Zealand
|
So we should manually amend the C# code created by weborb WDMF to add the command timeout and recompile the code?
Cheers,
Rob.
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 9/10/2009
Posts: 320
Points: 778
Location: US
|
yes, you should
|
|
|
Guest |
