Re: Sharing the JDBC Connection between all the threads
Am 17.08.21 um 21:15 schrieb Tong Sun: > On Tue, Aug 17, 2021 at 5:06 AM Felix Schumacher < > felix.schumac...@internetallee.de> wrote: > >> Do you want to share the connections over all the threads? (This is not >> the default in JMeter. Every thread/user has its own connection unless >> configured otherwise) >> > Hi, Felix > > Can you elaborate on how to share a single JDBC Connection between all the > threads pls? > > All the threads can share a single CSV input but for them to share a single > JDBC Connection I'm yet to find how. > > It'll help to send unique values in the requests from all the threads. To configure this, use "1" as "Max Number of Connections". Felix > > thanks > OpenPGP_signature Description: OpenPGP digital signature
Sharing the JDBC Connection between all the threads
On Tue, Aug 17, 2021 at 5:06 AM Felix Schumacher < felix.schumac...@internetallee.de> wrote: > > Do you want to share the connections over all the threads? (This is not > the default in JMeter. Every thread/user has its own connection unless > configured otherwise) > Hi, Felix Can you elaborate on how to share a single JDBC Connection between all the threads pls? All the threads can share a single CSV input but for them to share a single JDBC Connection I'm yet to find how. It'll help to send unique values in the requests from all the threads. thanks
Re: Help Needed in creation of JDBC connection at runtime
You could create a pre-flight Jmeter Test plan that will generate a property file with those values and use it as data on your JMeter script with the simulated scenario. This is only one way to do it, and I'm pretty sure that there are plenty more. JMeter has other components to help you achieve this goal. Best of luck. Be safe and drink water! Flavio Cysne On Thu., Jul. 23, 2020, 11:17 a.m. deepak kodigepalli, < deepak.kodigepa...@gmail.com> wrote: > Hi, > > Is there anyway where we can create a JDBC connection using JDBC Connection > Confiuration during runtime. The user name and password will be generated > with a temporary connetion and new username and password will be used to > create a new connection during runtime. > > > Thanks > Deepak >
Help Needed in creation of JDBC connection at runtime
Hi, Is there anyway where we can create a JDBC connection using JDBC Connection Confiuration during runtime. The user name and password will be generated with a temporary connetion and new username and password will be used to create a new connection during runtime. Thanks Deepak
Re: Does JDBC Connection Config component respect its scope?
There's a general note about configuration elements ( http://jmeter.apache.org/usermanual/component_reference.html#config_elements ) elements are processed at the start of the scope in which they are found, i.e. before any samplers in the same scope. There's such note in CSV Data Set Config ( http://jmeter.apache.org/usermanual/component_reference.html#CSV_Data_Set_Config ) CSV Dataset variables are defined at the start of each test iteration. As this is after configuration processing is completed, they cannot be used for some configuration items - such as JDBC Config On Mon, Nov 27, 2017 at 12:58 PM, Konstantin Kalinin < konstan...@kkalinin.pro> wrote: > Hello! > > I'm using JMeter 3.3. > I try to setup a JDBC Connection Config (JDBC CC) this way: > > Test plan > |__setUp Thread Group > |__Sampler1 (sets variables) > |__JDBC Request1 > |__JDBC CC (using vars from Sampler1) > > Seems that JDBC CC initializes when Test plan is loaded, no matter where > it is in the plan, as it can not use variables that I've set in Sampler1. > Adding some tree levels with different Controllers changes nothing. > It behaves like a User Defined Variables config element do, but there's no > note about it in a Documentation. I expect, that JDBC CC would respect it's > scope. > > Is it a bug? > > > -- > Konstantin Kalinin > +7 912 468 00 00 > > - > To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org > For additional commands, e-mail: user-h...@jmeter.apache.org > >
Does JDBC Connection Config component respect its scope?
Hello! I'm using JMeter 3.3. I try to setup a JDBC Connection Config (JDBC CC) this way: Test plan |__setUp Thread Group |__Sampler1 (sets variables) |__JDBC Request1 |__JDBC CC (using vars from Sampler1) Seems that JDBC CC initializes when Test plan is loaded, no matter where it is in the plan, as it can not use variables that I've set in Sampler1. Adding some tree levels with different Controllers changes nothing. It behaves like a User Defined Variables config element do, but there's no note about it in a Documentation. I expect, that JDBC CC would respect it's scope. Is it a bug? -- Konstantin Kalinin +7 912 468 00 00 - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
Re: JDBC Connection Config
Hey First System I have defined the Heap size as 512 - 1024 My RAM size is 512 MB (1024MB heap Size 512 MB Ram) Second System Looks like all parameters of system might be not same Deepak On 6/21/12, Dzmitry Kashlach dzmitrykashl...@gmail.com wrote: C.Vijayakumar bcvijayakumar at altechindia.com writes: Hi Sebb / Matt , Am using JMeter for Load testing our Java application . I have some doubts on using JMeter . Could you please help me to solve my doubts pls ? My Tuning Parameters are as follows set HEAP=-Xms512m -Xmx1024m set NEW=-XX:NewSize=128m -XX:MaxNewSize=128m set SURVIVOR=-XX:SurvivorRatio=8 -XX:TargetSurvivorRatio=50% set TENURING=-XX:MaxTenuringThreshold=2 set EVACUATION=-XX:MaxLiveObjectEvacuationRatio=20% set RMIGC=-Dsun.rmi.dgc.client.gcInterval=60 -Dsun.rmi.dgc.server.gcInterval=60 set PERM=-XX:PermSize=128m -XX:MaxPermSize=128m set DEBUG=-verbose:gc -XX:+PrintTenuringDistribution I have defined the Heap size as 512 - 1024 My RAM size is 512 MB . I have run my Test Plan using JDBC Connection configuration for 3964 concurrent users successfully . If I use more than 4000 Users , JMeter shows Out of Memory error . Even if i tried running the test plan by changing the Heap size as 256 - 1024 , 768 - 1536 512 - 512 , there is no improvement on my concurrent users , still am getting Out of memory error message I tried the same test plan in another system which has 1 GB RAM , But in that system, Only 2000 concurrent users have successfully completed and I got the same Out of Memory error . Could anyone / you please reveal me what I have to do to get proper results for more than 5000 Concurrent users ? Thanking you in Advance . Thanking you . With warm regards., Vijayakumar.C Hi C.Vijayakumar, Let me say, what I think about JMeter's problem with memory. 1.Do not use any Graph Listeners, they are too greedy and can waste your RAM There is some observation of this problem in article about JMeter Listeners(http://blazemeter.com/blog/greedy-listeners-memory-leeches- performance-testing) 2.If possible, do not use JMeter GUI at all, because it may be too heavy for your PC. Some advices you can find in articles, devoted to Running JMeter tests in non-GUI mode(http://blazemeter.com/blog/dear-abby-blazemeter-how-do-i-run- jmeter-non-gui-mode) and collecting load test results(http://blazemeter.com/blog/top-2-techniques-get-jmeter-test-results-non- gui-mode) - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org -- Namaskara~Nalama~Guten Tag~Bonjour -- Keigu Deepak +91-9765089593 deic...@gmail.com http://www.simtree.net Skype: thumsupdeicool Google talk: deicool Blog: http://loveandfearless.wordpress.com Facebook: http://www.facebook.com/deicool Contribute to the world, environment and more : http://www.gridrepublic.org - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
Re: jdbc connection
Just found out that jtds drivers are the best to connect to mssql db. tried that with the appropriate jars and with the following db URL and driver class. It workd perfectly fine URL: jdbc:jtds:sqlserver://db-server/db_name JDBC Driver Class : net.sourceforge.jtds.jdbc.Driver username : test password : test -Waseem -- View this message in context: http://jmeter.512774.n5.nabble.com/jdbc-connection-tp5071152p5074550.html Sent from the JMeter - User mailing list archive at Nabble.com. - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org
Re: jdbc connection
More details then. What is the exact configuration of the JDBC sampler? What errors are generated when you do it this way? - To unsubscribe, e-mail: user-unsubscr...@jmeter.apache.org For additional commands, e-mail: user-h...@jmeter.apache.org