I've recently developed a prototype JDBC Data Set component that is analogous to the CSV Data Set except that the values come from the columns in the select or prepared select statement. It uses JDBC Connection Configuration just like the JDBC sampler, pre-processor and post-processor.
Early on I thought that keep alive and connection age could be significant parameters affecting the performance and efficiency of my component but when I looked in the source code for the JDBC Connection (src/protocol/jdbc/org/apache/jmeter/protocol/jdbc/config/DataSourceElem ent.java) I found not only that "Keep-Alive", "Max Connection Age" and "Validation Query" have set/get methods but are otherwise not used (presumably an aspirational addition to the component and its beaninfo) but also that it uses the now defunct Apache Excalibur as its actual JDBC interface: it's only a wrapper. Rather than dig into another source project, and a dead and static one at that, I decided to trust JMeter's JDBC Connection Configuration's encapsulation of Excalibur and hope that the eventually inevitable migration to something else remains equally encapsulated and won't break my component. So that's the long answer. The short answer is that you have no control over the status of a given connection and will have to tolerate the default behaviour. -----Original Message----- From: Dzmitry_Kashlach [mailto:[email protected]] Sent: 21 June 2012 15:08 To: [email protected] Subject: Re: How to connect to Database from JMeter at the start of the test and use the connection in the post processor to insert some data? When I had task that was similar to yours, I opened connection to database via JDBC Connection Configuration once per Thread Group. After that I used this connection through the whole test. While creating JMeter test-plan, I used http://community.blazemeter.com/knowledgebase/articles/65143-using-jdbc- sampler-in-jmeter-2-6 How to use JDBC Sampler in JMeter -- View this message in context: http://jmeter.512774.n5.nabble.com/How-to-connect-to-Database-from-JMete r-at-the-start-of-the-test-and-use-the-connection-in-the-post-p-tp567638 8p5713661.html Sent from the JMeter - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
