Ed,

I'm trying to see if I can rewrite the way the generator value is acquired
such that I create and end a new transaction for each request. I am thinking
that this will enable it to be more stable, at the cost of some performance.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> Behalf Of Support List
> Sent: Wednesday, November 09, 2011 8:57 AM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] Re: Generator not incrementing
>
> Ed,
>
> I'm not really sure what I can do about this problem from within IBO since
> it is obviously a problem where the server instance experiences a crash.
> Whenever you end task an embedded application the whole instance of the
> server is also crashed. Have you looked at only using a database with
> forced
> writes enabled? That should make the difference you need to be sure that
> when the server is crashed that the increment of the generator is written
> to
> disk. Seems to me it would be a good idea for the firebird development
> team
> to make it so that under all circumstances the generator is written to
> disk
> when incremented. You might want to suggest that to them.
>
> Jason
>
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
> > Behalf Of Ed Dressel
> > Sent: Tuesday, November 08, 2011 8:38 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Re: Generator not incrementing
> >
> > Jason:
> >
> > I posted this link on Aug 13th with the following comments:
> >
> > <quote>
> > www.tbinc.com/misc/GeneratorNotIncremented.zip
> >
> >
> > To reproduce the problem, run the demo app (it has it's own database) in
> > embedded mode (the 1.5.6 DLL is included). Click on the "Increment
> > Generator" button. Then click on "End Task" which calls the exception.
> Re-
> > run the demo and (at least for me) the generator is not incremented.
> >
> > I would appreciate any comments. I have thousands of users and
> > occasionally one of them has a critical failure. This creates a support
> > nightmare for me.
> > </quote>
> >
> > I spent several hours isolating the problem and creating the demo.
> >
> > Were you not able to reproduce it from that?
> >
> > Ed Dressel