Hi,

Can you post either code or just a sql script you're trying to
execute? This will safe us efforts in reproducing the bug.

Thanks in advance,
Roman Rokytskyy

--- In Firebird-Java@y..., Rashid Motala <rashidm@i...> wrote:
> 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.