Subject | Re: Autocommit Problems with Jaybird |
---|---|
Author | ccknyrject |
Post date | 2003-11-20T19:27:08Z |
Hi Roman,
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. At
that point, I have to turn off autocommit, commit again, and turn it
back on to make autocommit work.
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.
Thanks,
Mike
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. At
that point, I have to turn off autocommit, commit again, and turn it
back on to make autocommit work.
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.
Thanks,
Mike