[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jmeter-user
Subject:    RE: JDBC Autcommit even if turned off?
From:       David Bala� <David.Balazic () comtrade ! com>
Date:       2020-07-16 12:47:56
Message-ID: 7c642a310fe84657a54aaa1ff72a2d17 () CORE-EXCH ! comtrade ! com
[Download RAW message or body]

It is documented here in "Database JDBC Developer's Guide" 11.2
https://docs.oracle.com/cd/E11882_01/java.112/e16548/getsta.htm#JJDBC28071

Quote:

If the auto-commit mode is disabled and you close the connection without explicitly \
committing or rolling back your last changes, then an implicit COMMIT operation is \
run.

Regards,
David Balažic

-----Original Message-----
From: Yngvi Þór Sigurjónsson <blitzkopf@gmail.com> 
Sent: četrtek, 16. julij 2020 05:52
To: JMeter Users List <user@jmeter.apache.org>
Subject: Re: JDBC Autcommit even if turned off?

CAUTION: Origin is external! The content might not be safe!


Hi!
My guess is that if/when you do a connection.close() Oracle JDBC will do an implicit \
commit. I cannot see a mention of it in the official documentation from Oracle but \
there are some articles and questions  suggesting that this is the case.

Regards
Yngvi

On Wed, Jul 15, 2020 at 6:39 PM David Balažic <David.Balazic@comtrade.com>
wrote:

> Hi!
> 
> I set a JDBC Connection Configuration and changed the "Auto Commit"
> setting from the default true to false.
> But even so, changes made by SQL statements are commited on the database.
> 
> Is this a bug?
> Is there an implicit commit somewhere?
> 
> 
> Using JMeter 5.3 , Oracle database
> 
> Lep pozdrav,
> David Balažic
> Lead Engineer
> 
> 
> 
> T:  +386 81 608 937
> A:  Letališka 29b, Ljubljana, Slovenia
> W: www.comtrade.si
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
> 
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]