Connection pooling and connection parameters

The SQL Anywhere .NET Data Provider supports connection pooling. The documentation says: "...it checks the pool for an existing connection that uses the same connection parameters you have specified"
What means in this case same connection parameters, will the CON= parameter count too? If the application requests a new connection with a different CON parameter, but the rest is the same, will the pooled connection be reused and if so will the connection name change?
What about the APP parameter, it contains information about the executing thread will this be seen as different connection parameters, if just the calling thread is a different one?

connection-pooling connection connection-parameter

asked 25 Jun '10, 10:55

Martin
9.0k●130●169●257
accept rate: 14%

flat view

3 Answers:

active answers oldest answers newest answers popular answers

3	I have confirmed with the Provider team that the connection string must match exactly in order for a pooled connection to get used. As a result, the con parameter counts. permanent link answered 09 Jul '10, 13:17 Karim Khamis 5.7k●5●38●70 accept rate: 40% flat view

Regarding the APP parameter Ian McHardy provided this usefull information:

The generated portion of the AppInfo string is ignored when determining if two connection strings are the same for connection pooling. If a user specified AppInfo parameter is specified, that is included in the comparison

permanent link

answered 15 Nov '11, 11:37

Martin
9.0k●130●169●257
accept rate: 14%

flat view

0	IMHO I think that CON parameter counts too. permanent link answered 25 Jun '10, 11:56 Zote 1.7k●36●40●51 accept rate: 43% flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

connection ×159
connection-parameter ×44
connection-pooling ×16

question asked: 25 Jun '10, 10:55

question was seen: 3,948 times

last updated: 15 Nov '11, 11:37

SAP SQL Anywhere

Connection pooling and connection parameters

Follow this question

Related questions