An update about my night tests:

tonight i had this:

GDS Exception. deadlock
Error Code: 335544336
SQL State: null

executing a stored procedure that updates a single row.
reexecuting, from ibexpert, the same procedure with same parameters
without restarting anything, was succesful...

in my java app the workflow is approximately this:

accept a tcp connection
log in the database the request made (insert a row)
insert a row in another table after some processing (not db processing)
update the inserted row after some processing (not db processing)
say goodbye
close the tcp connection

yesterday i had errors making the "log" insert.
tonight i had errors making the update.
i forget to mention that i made query in autocommit mode.

any clue?

ciao
--
Seti@Home Java Applets
http://maruko.cjb.net/