1. ATK Gimmy Susan
  2. PowerBuilder
  3. Tuesday, 30 October 2018 20:20 PM UTC

Hi Guru

The maximum connection pool limit in the connection of a webservices does not work. 

If I recall the code more than once, the number of connections increases infinitely even if I set the limit to 10.

Any idea to solve the problem?

Thanks in advance for the answers

Gimmy

 

 

 


Ecosystem:
Oracle Database: 11.2.0.3
Oracle Client: 12.2.0.1
IIS: 10.0.14393.0
Operating system: W2016
Powerbuilder: 2017r3


The web service is as follows:

We are in the presence of a solo user object.
In the constructor event it connects with oracle
In the destructive event it does the disconnect with oracle
In a method it does a select on the oracle DB.
DBParm: DBParm = "CommitOnDisconnect = 'No', PBCatalogOwner = 'pgmr', DelimitIdentifier = 'No', Pooling = 'Session Pooling', CSMax = 10, SessionHomogeneous = 'Yes'"

 

 

The client program has a command button with this code:
nc_progenamws_interface u_soap
soapconnection s_conn
long li_ret
double l_

s_conn = create soapconnection

li_ret = s_conn.createinstance (u_soap, "nc_progenamws_interface")

ld_ = u_soap.of_dll ()
destroy (s_conn)

 

Accepted Answer
ATK Gimmy Susan Accepted Answer Pending Moderation
  1. Thursday, 27 December 2018 09:07 AM UTC
  2. PowerBuilder
  3. # Permalink

I resolve the case in this way:

 

Oracle® server connection pool:

SQL> EXECUTE DBMS_CONNECTION_POOL.START_POOL();

 

Oracle® client connection pool (dbparm setting):

Pooling=’Connection Pooling’,CSMax=10 

 

 

N.B.

Response delay
The ws query is slow due to attempts to resolve the NetBios OCI record from the IIS server.
The implemented work-around was to enable local record resolution by setting the file in the lmhosts file
following record:
127.0.0.1 OCI

 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 30 October 2018 21:31 PM UTC
  2. PowerBuilder
  3. # 1

Hi Gimmy;

  I am a bit confused as you were first talking about a Web Service connection cache - yet, you show a DB Connection cache instead in your example code.

  The Web Service connection cache is controlled via its "Cache" setting

conn.UseConnectionCache (boolean cache)

Also, try now to destroy your SOAP Connection each time. Leave it instantiated. You only need to Destroy it when the APP no longer needs it (ie: closing).

HTH

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 31 October 2018 04:02 AM UTC
Got it!



Then the key is to use ADO.Net connectivity within your PB Web Service(s) to pool DB connections within the IIS realm.
  1. Helpful
  1. ATK Gimmy Susan
  2. Wednesday, 31 October 2018 05:59 AM UTC
Thanks Chris.



Are there any particular settings for connecting or for oracle to get to my goal?

(Examples? documentation? tips and trick? )
  1. Helpful
  1. Chris Pollach @Appeon
  2. Wednesday, 31 October 2018 13:10 PM UTC
Not that I am aware of for Oracle. However, I am not an Oracle guru either. Hopefully, someone else will jump in here on this thread who has some "hands on" Oracle experience in this area with some more words of wisdom on ADO.net connections. In the mean time, some Googling around might be prudent.
  1. Helpful
There are no comments made yet.
ATK Gimmy Susan Accepted Answer Pending Moderation
  1. Monday, 5 November 2018 22:02 PM UTC
  2. PowerBuilder
  3. # 2

Come on GURU,

No one can help me ?

please

 

Comment
There are no comments made yet.
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 November 2018 03:11 AM UTC
  2. PowerBuilder
  3. # 3

I really think you should be using the new C# Web service feature of PB 2019. From what I remember the old Sybase .NET stuff didn’t support connection pooling of the .NET framework.

Comment
  1. ATK Gimmy Susan
  2. Thursday, 8 November 2018 05:04 AM UTC
I remember the promise you made to me at the 'Appeon Elevate 2018' during dinner.

Remember that I have to be able to consume it from Java.

Remember that I must be able to create a connection pool with Oracle.



I wait for the new solution like water in the desert.



Gimmy
  1. Helpful
  1. Armeen Mazda @Appeon
  2. Friday, 9 November 2018 00:56 AM UTC
Try new C# Web API and then let’s see.
  1. Helpful
  1. ATK Gimmy Susan
  2. Friday, 9 November 2018 06:58 AM UTC
:)
  1. Helpful
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.