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.

 

 

Who is viewing this page
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.