Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I'm looking for tips on using ConnectionPool with SA17 and PowerBuilder.

My app is connecting/disconnecting frequently using the same userid/password. I can't use a long term connection due to how it is structured.

asked 17 Apr, 15:06

topwiz's gravatar image

topwiz
31128
accept rate: 0%


ConnectionPool

Controls the behavior of client connection pooling.

{ ConnectionPool | CPOOL }={ NO | YES [ ( [ Timeout=timeout-sec; ] [ MaxCached=max-cachedconn ] ) ] }

timeout-sec = Idle timeout in seconds before the connection is dropped. max-cachedconn= The maximum number of cached connections from each application.

Default:

ConnectionPool YES Timeout=60 MaxCached=5

Example:

;ConnectionPool=YES (Timeout=60; MaxCached=5);

permanent link

answered 17 Apr, 15:44

topwiz's gravatar image

topwiz
31128
accept rate: 0%

Hm, have you answered your own question, or is this just an addition to your question?

(18 Apr, 02:59) Volker Barth
Your answer
toggle preview

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

Question tags:

×39
×16

question asked: 17 Apr, 15:06

question was seen: 166 times

last updated: 18 Apr, 02:59