Hello, I guess correct fix would be: dataSource.setEnableAutoCommitOnReturn(isAutocommit());
Can you try with this code ? Thank you On Tue, Dec 17, 2019 at 9:45 PM Dmitry Sherstobitov <[email protected]> wrote: > 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 >
