 Forum main
page
Most
active member
Login page
Register
Log out
Search page
Information Online
View our event calendar
Add general event such as an upcoming
software release or conference
View all birthdays
Public image gallery
Upload your images in your profile
Profile editing page
Subscription list page
Address book page
Member list page
View the
most active member
User groups listing
Private message page
|
|
Users viewing this topic: none
|
|
Login  | |
|
Unclosed SQL connections - 23 September 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
Hello,
My name is David and I am new to this forum. I would like to ask you about an issue I face: I am using the topxml BTUtilities adapter (sql data provider version 2.0). The receive location is executing a SP every 15 seconds but for some reason the connection stays opened. I don't know why. Is there any configuration I missed? what do you think can be the problem?
Thank you very much,
_____________________________
D.H
|
|
|
|
|
RE: Unclosed SQL connections - 25 September 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
There is nothing wrong with this. By default connection pooling is switched on for the Provider. If you want to switch this off set the Pooling option to false. This will however be more expensive opening a connection every time.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Unclosed SQL connections - 25 September 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
Hi Pieter and thank you for your response. However, I admit I didn't made myself clear enough: The problem is not that the connection stays open but that for some reasons in some cases new connections are created and the old ones are not closed. So we can find 100 opened connections to SQL. I made some checking and I saw that in general when the host stops the connections are closed but some times this is not the case. When exactly a connection is being closed? Is the situation I described familiar to you?
Thank in advance.
_____________________________
D.H
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
Do you have a Connection Lifetime Property available on the connection string?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
Yes. I tried to change it but i didn't see any difference. This is a production issue.
_____________________________
D.H
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
To what value did you change this?
Another alternative would be to totally switch off connection pooling, but this will obviously cause a performance issue.
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
I changed it twice: once to 1 minute and the second time for more than that (I don't remeber exactly). However, I actually set connection pooling to "false". Allthough this sloves the problem of connections overcreation, the problem is that the open connections are not closed, and the remote server force them to close. This causes sometimes a problem of "An existing connection was forcibly closed by the remote host" and the data is not fatched (as far as i can see this is not critical for the moment because the process runs every 30 seconds and the data is fatched at the next activation but we HAVE to solve this problem as well).
I will be glad to hear other suggetions from you.
Again, Thank you very much.
_____________________________
D.H
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
What is the version of the Adapter?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
sql data provider version 2.0
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
Pieter
Posts: 615
Score: 2
Joined: 8 March 2004
Status: offline
|
What is the Version under Add/Remove Programs?
_____________________________
Need a BizTalk Adapter? Visit http://www.topxml.com/biztalkutilities and check out the latest BizTalk Adapters.
|
|
|
|
|
RE: Unclosed SQL connections - 2 October 2007
|
|
|
davidha
Posts: 6
Score: 0
Joined: 23 September 2007
Status: offline
|
4.0.5
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version
Email TopXML