1. ATK Gimmy Susan
  2. PowerBuilder
  3. Tuesday, 30 October 2018

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
0
Votes
Undo

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.
  1. Thursday, 27 December 2018
  2. PowerBuilder
  3. # Permalink
Armeen Mazda Accepted Answer Pending Moderation
0
Votes
Undo

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
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. ATK Gimmy Susan
  2. Thursday, 8 November 2018
Try new C# Web API and then let’s see.
  1. Armeen Mazda
  2. Friday, 9 November 2018
:)
  1. ATK Gimmy Susan
  2. Friday, 9 November 2018
There are no comments made yet.
  1. Thursday, 8 November 2018
  2. PowerBuilder
  3. # 1
ATK Gimmy Susan Accepted Answer Pending Moderation
0
Votes
Undo

Come on GURU,

No one can help me ?

please

 

Comment
There are no comments made yet.
  1. Monday, 5 November 2018
  2. PowerBuilder
  3. # 2
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Chris Pollach
  2. Wednesday, 31 October 2018
Thanks Chris.



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

(Examples? documentation? tips and trick? )
  1. ATK Gimmy Susan
  2. Wednesday, 31 October 2018
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. Chris Pollach
  2. Wednesday, 31 October 2018
There are no comments made yet.
  1. Tuesday, 30 October 2018
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.