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 >
