Subject | Multithreading problem |
---|---|
Author | Uwe Jäger |
Post date | 2002-08-06T13:03:05Z |
Hi,
I have several threads that use the same connection (JDBC) set to
autocommit. With firebirdsql I run into troubles because the
transactions run in parallel, so the FBLocalTransaction object throws an
exception when begin() is called again before commit() or rollback().
The program runs fine with various other jdbc drivers, including
interclient. From that code I learned, that interclient uses a server
side auto commit. Is there a chance to do something similar with
firebirdsql or is there another work around? All the transactions only
execute select statements, they are really read-only.
Kind regards
Uwe
I have several threads that use the same connection (JDBC) set to
autocommit. With firebirdsql I run into troubles because the
transactions run in parallel, so the FBLocalTransaction object throws an
exception when begin() is called again before commit() or rollback().
The program runs fine with various other jdbc drivers, including
interclient. From that code I learned, that interclient uses a server
side auto commit. Is there a chance to do something similar with
firebirdsql or is there another work around? All the transactions only
execute select statements, they are really read-only.
Kind regards
Uwe