Thanks for helping me out on the forums all the time. This time I have a web service using Devtest 9.1, it uses the Read Rows From a JDBC Table function under Data Sets to read from a MySQL database where I proceed to make a custom response. The service works fine for many individual transactions when deployed.
However, when I tried to run a small load test, basically a couple hundred transactions per second. After maybe 5000 or so transactions the service stops and I see this error in the Inspection view:
Trapped Exception: The driver was unable to create a connection due to an inability to establish the client portion of a socket. This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable.
Does this feature use a connection pool? It doesn't give me a checkbox like the other SQL features (For example "SQL Database Execution"). Is this something that I have to adjust on the operating system? We are hosting the service and VSEs in a Windows Server 2012 environment. Is this something that is to be adjusted on the DevTest Side or maybe the MySQL side?
Thanks as always for the help!
Are you running this on Linux?
If so what it your ulimit?
You may need to increase the number of open file handlers for the system.
I am running this on Windows 2012 Server R2.
What JDBC Driver are you using to connect to MySQL?
We're using this driver class: com.mysql.jdbc.Driver
I am not 100% sure, but this might be a configuration on your MySQL side, see the link below:
java - Connection Exception fetching large data from mysql - Stack Overflow
Thanks! It actually worked. We increased the connection pool on the MySQL side and it worked.