|
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 |