Make sure every transaction is inside a block like this.

Assumed: Connection conn and Statement stmt are both already
constructed and initialized.



try {

stmt.execute ("insert into table (xxx) values ('yyy')");
// and more sql issued against the database

conn.commit ();
}
catch (SQLException sqlx)
{
conn.rollback();
}

On Thu, 2005-04-07 at 15:03 +0300, Gili Buzaglo wrote:
>
> my server is written in java and I'm using jbird
> Thanks
> -gili
>
> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Thursday, April 07, 2005 3:01 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Re: Performance when deleting a lot of records, again
>
>
> > I probalbly have a transaction that remained open.
> > I'm having trubble finding it though.
> > Do you have any ideas how to approach this problem ?
> > I found all the places at the code that calls setAutoCommit and it
> > looks fine. I also worked with a db after backup/restoring and it is
> > not reproduced(next transaction= 1+snapshot transaction).
> > So its a specific transaction that I need to trace.
> > Any suggestions ?
>
> autocommit is often referred to as commit retaining. Not sure what component
> set you are using but autocommit doesn't smell right to me.
> Are you using java? or some other language?
> what component set are you using?
> Alan
>
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>