I am using JDBC to connect to my database. I am using connections with autocommit turned off, so I can use transactions.
Questions:
1) When does a transaction start? As soon as I do the first insert/update on the connection or as soon as I set autocommit off?
2) After doing a commit, when does the next transaction start?
The reason I ask these questions is because I have an issue doing DB Vacuum, where free rows are not being reused because there is still an active transaction that was started before the rows were deleted, and I am trying to determine what could be causing the problem.
TIA
Chris White