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 <[email protected]> Sent: četrtek, 16. julij 2020 05:52 To: JMeter Users List <[email protected]> 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 <[email protected]> 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: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
