I had that happen quite a bit when using IBConsole. You can test this by
simply shutting down IBConsole and restarting it. I'll bet the data is
there and IBConsole is not showing it.

Rick

----- Original Message -----

> Hi,
>
> Perhaps ensure that the transaction you are using to view the data in the
> database is re-started also after the insert was commited otherwise it may
> not be able to see the results of the insert - depending on its isolation
> level.
>
> Just a thought.
>
> Ryan
>
> -----Original Message-----
> From: Roman Rokytskyy [mailto:rrokytskyy@...]
> Sent: 15 August 2003 16:01
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Re: Strange problem: inserts failing
>
>
> > I built a class called Database wich encapsulates a JBird
> > Connection. When I call database.connect(), it is created an
> > auto-committed Connection. The method used for updates is called
> > execUpdate and is synchorinzed. So, I create an Database object,
> > call the method connect and start the threads. Each thread will then
> > call the execUpdate method.
>
> Sounds good to me.
>
> > I made a step-by-step execution and the output of executeUpdate is 1
> > just as you said. The connection is auto-committed, as I said
> > before. Do you know if an auto-committed transaction can be rolled
> > back? If yes, is there any way of discovering if it occurred and
> > why?
>
> No, you should get exception then. If server says that it was
> committed, then it was committed. Check if no exception is ignored.
>
> Roman