Database Administration (MOSC)

MOSC Banner

The effect of setting 'auto-commit=true' (or similar) in jdbc drivers or the like

edited Apr 7, 2017 5:13AM in Database Administration (MOSC) 2 commentsAnswered ✓

Hi,

   Studying a raw trace file produced by setting event 10046 on shows a number of lines such as:

XCTEND rlbk=0, rd_only=0, tim=13558440385826

This, presumably, indicates the end of a transaction - i.e. a 'commit'. Now, studying a 10046-trace with WebLogic at the 'client' end, commit activity, as reflected in the trace file by lines such as that above, appears to be reasonable (i.e. not after every single SQL update/insert/delete statement, but at what appears to be transaction boundaries). However, with other 'clients', such as jdbc thin driver (with auto-commit set to 'true'), there appear to be very few of these  'XCTEND' lines in the trace. My question therefore is - if auto-commit is set to true in these drivers, does this force

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center