Re: Confusion regarding autocommit

On 10-4-2019 11:09, siddharth yanamandra wrote:
> Hi
>
> We have an application which used the jdbc 8.2-504 version. We have
> recently tried to update it to 42.2.5 jre 7 version. During this update
> we faced the issue "could not commit when autocommit is enabled" error
> so we have decided to assign false to autocommit during connection
> initiation. Now many of the SQL statements we use are select statements
> and we have read from many sources that even select statements should be
> committed to clear locks on tables. Is this necessary or is it ok to
> just close the connection after the operations are done(for select
> statements only).

The point of auto-commit mode is that this happens automatically. You
should not call commit() or rollback() when using auto-commit. If you
want to explicitly call commit or rollback, then you should disable
auto-commit using setAutoCommit(false).

Mark
--
Mark Rotteveel