Hi!

I just found out some problem with cached metadata (?) in driver.
Next simple code:

import org.apache.log4j.*;
import java.sql.*;

public class Test {
static Logger logger = Logger.getLogger(Test.class);
public static void main(String[] args) {
BasicConfigurator.configure();
try {
Class.forName ("org.firebirdsql.jdbc.FBDriver");
Connection con = DriverManager.getConnection
("jdbc:firebirdsql:localhost/3050:c:/Projects/Bap/Bap.gdb","SYSDBA","m
asterkey");
Statement st = con.createStatement();
st.executeUpdate("CREATE TABLE t1(id INTEGER NOT NULL PRIMARY
KEY)");
st.executeUpdate("CREATE TABLE t2(pkref INTEGER REFERENCES t1
(id))");
} catch (Exception e) {
logger.error("Abnormal termination", e);
}
}
}

fails with this exception:

0 [main] ERROR Test - Abnormal termination
org.firebirdsql.jdbc.FBSQLException: Resource Exception. unsuccessful
metadata update
object T1 is in use
Reason: unsuccessful metadata update
object T1 is in use
at org.firebirdsql.jdbc.AbstractConnection.checkEndTransaction
(AbstractConnection.java:872)
at org.firebirdsql.jdbc.AbstractConnection.checkEndTransaction
(AbstractConnection.java:856)
at org.firebirdsql.jdbc.AbstractStatement.executeUpdate
(AbstractStatement.java:205)
at Test.main(Test.java:20)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main
(AppMain.java:78)
at
org.firebirdsql.gds.GDSException: unsuccessful metadata update
object T1 is in use
at org.firebirdsql.jgds.GDS_Impl.readStatusVector
(GDS_Impl.java:1761)
at org.firebirdsql.jgds.GDS_Impl.receiveResponse
(GDS_Impl.java:1714)
at org.firebirdsql.jgds.GDS_Impl.isc_commit_transaction
(GDS_Impl.java:589)
at org.firebirdsql.jca.FBManagedConnectionFactory.commit
(FBManagedConnectionFactory.java:686)
at org.firebirdsql.jca.FBManagedConnection.internalCommit
(FBManagedConnection.java:409)
at org.firebirdsql.jca.FBLocalTransaction.internalCommit
(FBLocalTransaction.java:155)
at org.firebirdsql.jdbc.AbstractConnection.checkEndTransaction
(AbstractConnection.java:866)
at org.firebirdsql.jdbc.AbstractConnection.checkEndTransaction
(AbstractConnection.java:856)
at org.firebirdsql.jdbc.AbstractStatement.executeUpdate
(AbstractStatement.java:205)
at Test.main(Test.java:20)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke
(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke
(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.intellij.rt.execution.application.AppMain.main
(AppMain.java:78)

Additionally I've tried many cases (autocommit=off, closing
connection etc.) and found no way to create two tables one relates to
another.

The same query sequence through IBconsole works fine.