Further to this:

Running the query the first time gives the error as mentioned before...
java.sql.SQLException: Error during autocommit:
javax.resource.ResourceException: couldn't commit local transaction:
javax.transaction.xa.XAException: unsuccessful metadata update
object CARD_QUERY is in use
at
org.firebirdsql.jdbc.FBConnection.checkEndTransaction(FBConnection.java:
921)
at
org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate(FBPreparedStateme
nt.java:137)

Running the query a second time gives the following error:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. unsuccessful
metadata update
STORE RDB$RELATION_CONSTRAINTS failed
deadlock
attempt to store duplicate value (visible to active transactions) in
unique index "RDB$INDEX_12"
at
org.firebirdsql.jdbc.FBPreparedStatement.internalExecute(FBPreparedState
ment.java:458)
at
org.firebirdsql.jdbc.FBPreparedStatement.executeUpdate(FBPreparedStateme
nt.java:130)

Regards,
Rashid.

> Hello Blas,
>> If I understand you well, you try this SQL command immediately after
>> database restart and before any other DDL command, and with

CARD_QUERY table

>> created before the restart, and you got the same error.

> Short reply: YES
> We have tried it with Firebird and Interbase with the same result -

same error.

> It works with Interclient (either database) and it works from

IBConsole.