1. Roland Smith
  2. PowerBuilder
  3. Wednesday, 17 April 2024 18:31 PM UTC

SQL Anywhere 17 / PowerBuilder 2022

SAP online documentation for SA17 seems to have been deleted from their website. I did find SA12 documentation for a setting ConnectionPool.

I'm wondering if anyone has used this from PowerBuilder and have recommendations on using it.

The application I'm working on always uses the same userid/password but connects and disconnects on each request.

 

 

Roland Smith Accepted Answer Pending Moderation
  1. Wednesday, 17 April 2024 19:44 PM UTC
  2. PowerBuilder
  3. # 1

 

I got the following from the PDF that Mark linked to. It appears that the default is YES so I only need to use it when I want a different Timeout or MaxCached.

 

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

 

Comment
  1. Roland Smith
  2. Wednesday, 17 April 2024 19:48 PM UTC
I do wonder how SA defines an application. How does it know that a connection is coming from the same application as a previous one?
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 17 April 2024 19:24 PM UTC
  2. PowerBuilder
  3. # 2

Hi Roland;

  For both PowerBuilder and PowerServer, Connection pooling to any "pooling aware DB driver" is controlled outside of PB / PS via the ODBC layer within the DSN itself via the ODBC Administrator utility. For example:

HTH

Regards .., Chris

Comment
There are no comments made yet.
Mark Goldsmith Accepted Answer Pending Moderation
  1. Wednesday, 17 April 2024 19:12 PM UTC
  2. PowerBuilder
  3. # 3

Hi Roland,

I can't add any insight for connection pooling with SQL Anywhere from PowerBuilder but is this the doc you were looking for: https://help.sap.com/doc/68c565f3ab4f480ea42a59fa2ebd444e/17.0.01/en-US/SQL-Anywhere-Server-Database-Administration-en.pdf

HTH...regards,

Mark

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.