Subject Re: Autocommit Problems with Jaybird
Author Roman Rokytskyy
> I'm sorry for the confusion, I don't think I was clear. If I
> explicitly turn off autocommit and perform a manual commit, it works
> fine. On the same connection, if I then turn autocommit back on, it
> works fine until I restart and then close the connection again.

What does "restart" mean? Can you post the code?

> At
> that point, I have to turn off autocommit, commit again, and turn it
> back on to make autocommit work.

Turning autocommit on/off commits current transaction according to the
specification.

> My problem is that autocommit doesn't work out of the gate, and I'd
> like it too. It I did everything manually, I wouldn't have any
> problems, I'd just rather avoid it. I think my problem is somewhere
> within the JDBC driver, since the database has been working fine
> otherwise.

Please, post some code, preferably a standalone working test case. If
you consider your code to be not for publishing, you can send it to me
privately together with some NDA.

Thanks!
Roman