Subject | Re: AW: [ib-support] JBDC to Firebird - Commit error in threads |
---|---|
Author | Helen Borrie |
Post date | 2002-04-23T13:49:21Z |
At 03:09 PM 23-04-02 +0200, you wrote:
either a single connection to one database, or across connections to
multiple *different* databases. In the case of multiple different database
connections spanned by a single transaction, we have a thing called
"two-phase commit" to ensure that a commit takes effect across all
connections or gets rolled back across all connections.
In a single thread you need: a connection---a transaction---a bunch of
statements posted as pending----a commit or rollback to complete the
job. I've conducted some pernicious experiments (not with a Java client)
to convince myself that you really can't do it any other way.
the word "bug" in it indicates that you might be running with a debug build
and indeed have encountered a known bug (whatever bug code 10019 might
be). Maybe it's just yelling at you because of a memory access violation,
rather than crashing spectacularly.
Helen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________
>Thanks Paul.Why? I doubt that this is possible. A transaction has to work through
>
>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
either a single connection to one database, or across connections to
multiple *different* databases. In the case of multiple different database
connections spanned by a single transaction, we have a thing called
"two-phase commit" to ensure that a commit takes effect across all
connections or gets rolled back across all connections.
In a single thread you need: a connection---a transaction---a bunch of
statements posted as pending----a commit or rollback to complete the
job. I've conducted some pernicious experiments (not with a Java client)
to convince myself that you really can't do it any other way.
>with the same database connection i used before. Have you any idea what theBecause I don't know any better, I'd say any error message coming back with
>error message of the jdbc client means ?
the word "bug" in it indicates that you might be running with a debug build
and indeed have encountered a known bug (whatever bug code 10019 might
be). Maybe it's just yelling at you because of a memory access violation,
rather than crashing spectacularly.
Helen
All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________