Re: How to handle failed COMMIT

2022-07-19 Thread Håvar Nøvik
> Correct, the client did not get confirmation of commit success so it must > operate as if it failed. I mean that’s the point, the client can’t operate as if it failed. It must operate as the state is unknown. But maybe that’s the correct application behaviour, just that I haven’t thought this

Re: How to handle failed COMMIT

2022-07-19 Thread David G. Johnston
On Tuesday, July 19, 2022, Håvar Nøvik wrote: > > Correct, the client did not get confirmation of commit success so it > must operate as if it failed. > > I mean that’s the point, the client can’t operate as if it failed. It must > operate as the state is unknown. But maybe that’s the correct app

Re: How to handle failed COMMIT

2022-07-19 Thread David G. Johnston
On Monday, July 18, 2022, Håvar Nøvik wrote: > > try >execute transactional sql > catch (commit failed) >if (data is not stored) > // regard data as not stored Correct, the client did not get confirmation of commit success so it must operate as if it failed. David J.