sql - Importing Jmeter testResults XML data into mysql -


i have done tests in jmeter produces xml report in following format

 <testresults version="1.2">   <httpsample t="28786" lt="27285" ts="1304028697536" s="true" lb="/" rc="200" rm="ok" tn="ultimate thread group 1-2" dt="text" by="344754" hn="macbook-pro.local"/>  </testresults>` 

i created table in mysql called testresult columns t, lt, ts, s, lb...and on.

i wondering how can import content of each attributes mysql?

thanks.

you can either dump xml data in db grantk show in link or have map xml value db field need in java, python or perl.

note can output result in xml or csv

more here : http://jmeter.apache.org/usermanual/listeners.html

and here : http://jmeter-tips.blogspot.com/2010/02/tip-8-how-to-save-test-results.html


Comments