Re: Row values changing back to old values randomly???

Jim Kennedy wrote:
> "DG" <info_at_no-spam-e-resitve.com> wrote in message
> news:d779e901t46_at_enews3.newsguy.com...
>
> Sounds like a rollback is being issued or the connection dies and a rollback
> is done.
>
> I would call support.
> Jim
>
>

The library commits using this function:

SQLRETURN SQLEndTran(

		SQLSMALLINT     HandleType,
		SQLHANDLE     Handle,
		SQLSMALLINT     CompletionType);

HandleType is SQL_HANDLE_DBC
CompletionType is SQL_COMMIT

Is committing using this function from ODBC lib not durable?

Can it happen that the committed data is visible in a parallel connection/session and that at the same time the data can be rolled back to the point before begin of transaction which was committed? If not, then the changes shouldn't be visible in another transaction. I though that if MVCC is used then the changed data will be visible only *after* commit.

Best regards,

David Received on Fri May 27 2005 - 23:10:32 CEST