jmeter-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Philippe Mouawad <pmoua...@apache.org>
Subject Re: Hardcoded setEnableAutoCommitOnReturn=false
Date Tue, 17 Dec 2019 20:53:18 GMT
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 <sdn.xaoc@gmail.com>
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 <sdn.xaoc@gmail.com>
> 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 <sdn.xaoc@gmail.com
> >
> > 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 <
> >> sitnikov.vladimir@gmail.com> 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message