Subject AW: [ib-support] JBDC to Firebird - Commit error in threads
Author Thomas Fischer
Thanks Paul.

I try to explain my problem clearer. I make 5 'insert statements' in my main
application.
In a thread of my application i wait until the 5 'insert statements' are
send to the database (jdbc).. then i make a commit
with the same database connection i used before. Have you any idea what the
error message of the jdbc client means ?

Thanks

Thomas

-----Urspr√ľngliche Nachricht-----
Von: paul@... [mailto:paul@...]
Gesendet: Dienstag, 23. April 2002 14:53
An: ib-support@yahoogroups.com
Betreff: Re: [ib-support] JBDC to Firebird - Commit error in threads


On Tue, 23 Apr 2002 11:30:04 +0200, Thomas Fischer wrote:
> Hi.
>
>
> I have an exception during inserting several data lines (several
> insert statements) into a database with a single 'commit' statement
> in a parallel process (thread).
> On JDBC Client to an Oracle 9i server it's working fine. Does
> anyone know a hint ?
> May be there is a jdbc version which worked with a 'commit' in a
> thread ?
>
>

Your explanation is not too clear, but it sounds as if you are running
multiple threads. If you do so then you must ensure that each thread has its
own database connection. You cannot share a single connection across several
threads.

Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/