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
Oracle Database: 220.127.116.11
Oracle Client: 18.104.22.168
Operating system: W2016
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:
s_conn = create soapconnection
li_ret = s_conn.createinstance (u_soap, "nc_progenamws_interface")
ld_ = u_soap.of_dll ()