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
