Vladimir, I've created issue. Currently I can't find solution for that without changing source code :(
https://bz.apache.org/bugzilla/show_bug.cgi?id=64012 On Tue, Dec 17, 2019 at 12:27 AM Dmitry Sherstobitov <[email protected]> wrote: > About cause - it's true. I chose 3.3 version because it's first version > with this error. > It works fine on 2.13 and 3.2, 3.0. > > Doesn't work till latest version. Works well with muted > dataSource.setEnableAutoCommitOnReturn(false) > line. > > On Tue, Dec 17, 2019 at 12:19 AM Dmitry Sherstobitov <[email protected]> > wrote: > >> Sorry, >> >> Lets try this one :) >> <?xml version="1.0" encoding="UTF-8"?> >> <jmeterTestPlan version="1.2" properties="3.2" jmeter="3.3 r1808647"> >> <hashTree> >> <TestPlan guiclass="TestPlanGui" testclass="TestPlan" testname="Test >> Plan" enabled="true"> >> <stringProp name="TestPlan.comments"></stringProp> >> <boolProp name="TestPlan.functional_mode">false</boolProp> >> <boolProp name="TestPlan.serialize_threadgroups">false</boolProp> >> <elementProp name="TestPlan.user_defined_variables" elementType= >> "Arguments" guiclass="ArgumentsPanel" testclass="Arguments" testname="User >> Defined Variables" enabled="true"> >> <collectionProp name="Arguments.arguments"/> >> </elementProp> >> <stringProp name="TestPlan.user_define_classpath"> >> /PATH-TO/db-derby-10.14.2.0-bin/lib/derbyclient.jar</stringProp> >> </TestPlan> >> <hashTree> >> <JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" >> testname="autocommited" enabled="true"> >> <stringProp name="dataSource">auto</stringProp> >> <stringProp name="poolMax">0</stringProp> >> <stringProp name="timeout">10000</stringProp> >> <stringProp name="trimInterval">60000</stringProp> >> <boolProp name="autocommit">true</boolProp> >> <stringProp name="transactionIsolation">DEFAULT</stringProp> >> <boolProp name="keepAlive">true</boolProp> >> <stringProp name="connectionAge">5000</stringProp> >> <stringProp name="checkQuery"></stringProp> >> <stringProp name="dbUrl">jdbc:derby://localhost:1527/seconddb</stringProp >> > >> <stringProp name="driver">org.apache.derby.jdbc.ClientDriver</stringProp> >> <stringProp name="username"></stringProp> >> <stringProp name="password"></stringProp> >> </JDBCDataSource> >> <hashTree/> >> <JDBCDataSource guiclass="TestBeanGUI" testclass="JDBCDataSource" >> testname="non-autocommited" enabled="true"> >> <stringProp name="dataSource">noauto</stringProp> >> <stringProp name="poolMax">0</stringProp> >> <stringProp name="timeout">10000</stringProp> >> <stringProp name="trimInterval">60000</stringProp> >> <boolProp name="autocommit">false</boolProp> >> <stringProp name="transactionIsolation">DEFAULT</stringProp> >> <boolProp name="keepAlive">true</boolProp> >> <stringProp name="connectionAge">5000</stringProp> >> <stringProp name="checkQuery"></stringProp> >> <stringProp name="dbUrl">jdbc:derby://localhost:1527/seconddb</stringProp >> > >> <stringProp name="driver">org.apache.derby.jdbc.ClientDriver</stringProp> >> <stringProp name="username"></stringProp> >> <stringProp name="password"></stringProp> >> </JDBCDataSource> >> <hashTree/> >> <ThreadGroup guiclass="ThreadGroupGui" testclass="ThreadGroup" >> testname="Thread >> Group" enabled="true"> >> <stringProp name="ThreadGroup.on_sample_error">continue</stringProp> >> <elementProp name="ThreadGroup.main_controller" elementType= >> "LoopController" guiclass="LoopControlPanel" testclass="LoopController" >> testname="Loop Controller" enabled="true"> >> <boolProp name="LoopController.continue_forever">false</boolProp> >> <stringProp name="LoopController.loops">1</stringProp> >> </elementProp> >> <stringProp name="ThreadGroup.num_threads">1</stringProp> >> <stringProp name="ThreadGroup.ramp_time">1</stringProp> >> <longProp name="ThreadGroup.start_time">1576528279000</longProp> >> <longProp name="ThreadGroup.end_time">1576528279000</longProp> >> <boolProp name="ThreadGroup.scheduler">false</boolProp> >> <stringProp name="ThreadGroup.duration"></stringProp> >> <stringProp name="ThreadGroup.delay"></stringProp> >> </ThreadGroup> >> <hashTree> >> <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname= >> "auto" enabled="true"> >> <stringProp name="dataSource">auto</stringProp> >> <stringProp name="queryType">Update Statement</stringProp> >> <stringProp name="query">CREATE TABLE Persons ( >> PersonID int, >> LastName varchar(255) >> )</stringProp> >> <stringProp name="queryArguments"></stringProp> >> <stringProp name="queryArgumentsTypes"></stringProp> >> <stringProp name="variableNames"></stringProp> >> <stringProp name="resultVariable"></stringProp> >> <stringProp name="queryTimeout"></stringProp> >> <stringProp name="resultSetHandler">Store as String</stringProp> >> </JDBCSampler> >> <hashTree/> >> <JDBCSampler guiclass="TestBeanGUI" testclass="JDBCSampler" testname= >> "noauto" enabled="true"> >> <stringProp name="dataSource">noauto</stringProp> >> <stringProp name="queryType">Update Statement</stringProp> >> <stringProp name="query">CREATE TABLE Persons2 ( >> PersonID int, >> LastName varchar(255) >> )</stringProp> >> <stringProp name="queryArguments"></stringProp> >> <stringProp name="queryArgumentsTypes"></stringProp> >> <stringProp name="variableNames"></stringProp> >> <stringProp name="resultVariable"></stringProp> >> <stringProp name="queryTimeout"></stringProp> >> <stringProp name="resultSetHandler">Store as String</stringProp> >> </JDBCSampler> >> <hashTree/> >> <ResultCollector guiclass="ViewResultsFullVisualizer" testclass= >> "ResultCollector" testname="View Results Tree" enabled="true"> >> <boolProp name="ResultCollector.error_logging">false</boolProp> >> <objProp> >> <name>saveConfig</name> >> <value class="SampleSaveConfiguration"> >> <time>true</time> >> <latency>true</latency> >> <timestamp>true</timestamp> >> <success>true</success> >> <label>true</label> >> <code>true</code> >> <message>false</message> >> <threadName>true</threadName> >> <dataType>true</dataType> >> <encoding>false</encoding> >> <assertions>false</assertions> >> <subresults>true</subresults> >> <responseData>false</responseData> >> <samplerData>false</samplerData> >> <xml>false</xml> >> <fieldNames>true</fieldNames> >> <responseHeaders>false</responseHeaders> >> <requestHeaders>false</requestHeaders> >> <responseDataOnError>false</responseDataOnError> >> <saveAssertionResultsFailureMessage>true</ >> saveAssertionResultsFailureMessage> >> <assertionsResultsToSave>0</assertionsResultsToSave> >> <bytes>true</bytes> >> <sentBytes>true</sentBytes> >> <threadCounts>true</threadCounts> >> <idleTime>true</idleTime> >> <connectTime>true</connectTime> >> </value> >> </objProp> >> <stringProp name="filename"></stringProp> >> </ResultCollector> >> <hashTree/> >> </hashTree> >> </hashTree> >> <WorkBench guiclass="WorkBenchGui" testclass="WorkBench" testname= >> "WorkBench" enabled="true"> >> <boolProp name="WorkBench.save">true</boolProp> >> </WorkBench> >> <hashTree/> >> </hashTree> >> </jmeterTestPlan> >> >> >> On Tue, Dec 17, 2019 at 12:07 AM Vladimir Sitnikov < >> [email protected]> wrote: >> >>> >Here is the example jmx file >>> >>> It looks like the attachment was cut :( >>> >>> >>> https://lists.apache.org/thread.html/651e4cd6d9bebabc1a70766d01b2030c3e72ecdcd83d1c513558f99a%40%3Cdev.jmeter.apache.org%3E >>> >>> Vladimir >>> >> >> >> -- >> ------------------ >> Best regards, >> Dmitry Sherstobitov >> > > > -- > ------------------ > Best regards, > Dmitry Sherstobitov > -- ------------------ Best regards, Dmitry Sherstobitov
