*How do I specify 'the minimum connections which the pool must maintain at all times"? *
I don't think that option available in JMeter, but I would not worry about it. Min value is 0 and max is the number you give. But I guess Min value is required here. Maybe Jmeter committer can comment on this. Response message:java.sql.SQLException: Error preloading the connection pool (There is nothing in the log file jmeter.log). -- hmm this is related to dbcp2 and most likely you are trying to get a connection where there is either none or something else. Cannot comment exactly unless we understand the workload and hook it into code. And, how do I check the number of database connections made by Jmeter? And whether they are being reused? Can't see much in the jmeter.log) Well give max pool setting as 2 and run the test with 10 concurrent threads for 10 mins and enable verbose logs or maybe debug sampler. If the test runs fine without error, you know the connection pool is working,Ideally verbose logs should log some message if the connection is reused or not. https://www.blazemeter.com/blog/debugging-jdbc-sampler-results-jmeter With Regards, Kiran Badi Email:[email protected] Ph- US-(+01)6462013101 On Monday, June 14, 2021, 02:35:45 PM EDT, Deepak Goel <[email protected]> wrote: Hello Thanks for your response. *How do I specify 'the minimum connections which the pool must maintain at all times"? * Also I keep getting the following error: Response message:java.sql.SQLException: Error preloading the connection pool (There is nothing in the log file jmeter.log). *Is there a limit to the following variable "Max Number of Connections"?* And, how do I check the number of database connections made by Jmeter? And whether they are being reused? Can't see much in the jmeter.log) Thanks! Deepak "The greatness of a nation can be judged by the way its animals are treated - Mahatma Gandhi" +91 73500 12833 [email protected] Facebook: https://www.facebook.com/deicool LinkedIn: www.linkedin.com/in/deicool "Plant a Tree, Go Green" Make In India : http://www.makeinindia.com/home On Mon, Jun 14, 2021 at 11:37 PM Kiran Badi <[email protected]> wrote: > I have done quite a bit of work with JDBC. > JDBC connection configuration does have a connection pool setting and they > are good settings. If you are using this setting, then obviously it should > reuse the connection unless there is some bug somewhere. > do you think it's not reusing the connection? > > https://jmeter.apache.org/usermanual/build-db-test-plan.html > > regarding your other issue wrt SSL handshake failure in one of your > threads, I guess you need to reuse SSL session per client that does > handshake only once and I believe with HTTP client /or with transactional > systems, you can reuse context. Trusted components should not do handshakes > every now and then and wherever possible you need to reuse the context if > the client is the same. > > On Monday, June 14, 2021, 01:43:27 PM EDT, Deepak Goel < > [email protected]> wrote: > > Hello > > Has anyone done a 'Performance Test' with JDBC to a simple MySQL Server? I > tried adding a 'JDBC Connection Configuration' and 'JDBC Request'. But > can't make out which options are to be used for 'Connection Pooling'? > > Any idea how do I reuse the connections made from Jmeter to Database > (Connection Pooling)? > > Thanks! > Deepak > > > > Deepak > "The greatness of a nation can be judged by the way its animals are treated > - Mahatma Gandhi" > > +91 73500 12833 > [email protected] > > Facebook: https://www.facebook.com/deicool > LinkedIn: www.linkedin.com/in/deicool > > "Plant a Tree, Go Green" > > Make In India : http://www.makeinindia.com/home >
