Subject | Re: [Firebird-Java] Problem with multi-threaded update/query causing JDBC driver errors |
---|---|
Author | Roman Rokytskyy |
Post date | 2007-06-17T21:51:20Z |
> We had some multi-threaded code running where both threads were usingWhat kind of queries were executed in those threads? Only selects? Do
> the same JDBC connection; if they ran SQL code at the same time,
> errors could occur. (The threads have since been changed to have their
> own JDBC connections.)
you run in auto-commit mode? If not, how do you commit the transactions?
> Sometimes the error was a NullPointerException, or in some cases "GDSThe NullPointerException is a consequence of executing the statement
> Exception. 335544332. invalid transaction handle (expecting explicit
> transaction start)".
without active transaction. It looks that one thread has finished the
transaction exactly between checking for transaction and statement
execution in another thread...
Roman