Welcome Guest Search | Active Topics | Members | Log In | Register

SQL Connection Timeout Options · View
robo
Posted: Monday, November 07, 2011 5:31:51 PM
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.
robo
Posted: Thursday, November 10, 2011 12:32:31 PM
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.
Cyril
Posted: Thursday, November 10, 2011 1:34:19 PM
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 >
robo
Posted: Tuesday, December 20, 2011 7:30:08 PM
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?
Cyril
Posted: Wednesday, December 21, 2011 2:01:24 PM
Rank: Administration
Groups: Administration , Member

Joined: 9/10/2009
Posts: 320
Points: 778
Location: US
robo wrote:
Thanks Cyril. That helps. Any option to set command timeout as well?


http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.commandtimeout.aspx
robo
Posted: Wednesday, December 28, 2011 11:16:07 PM
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.
Cyril
Posted: Tuesday, January 03, 2012 4:16:52 PM
Rank: Administration
Groups: Administration , Member

Joined: 9/10/2009
Posts: 320
Points: 778
Location: US
yes, you should
Users browsing this topic
Guest


Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Main Forum RSS : RSS

YAFVision Theme Created by Jaben Cargman (Tiny Gecko)
Powered by Yet Another Forum.net version 1.9.1.8 (NET v4.0) - 3/29/2008
Copyright © 2003-2008 Yet Another Forum.net. All rights reserved.
This page was generated in 0.131 seconds.