My Oracle Support Banner

[JDBC] Transaction of Select Statement via DBLINK Remains even if Autocommit=true (Doc ID 2956281.1)

Last updated on AUGUST 01, 2023

Applies to:

JDBC - Version 19.3 and later
Information in this document applies to any platform.


The user has created two DB instances in database 19c and linked them with a DBLINK.
When executing Java code that connects via DBLINK with autocommit=true and executes SQL, transaction processing does not end normally in the Select statement and remains.

You can see this behavior by looking at v$transaction after executing the select statement.
When the user executes the update statement, the transaction is successfully processed without any remaining transactions.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.