Subject | unsuccessful metadata update |
---|---|
Author | luisfelipehurtado |
Post date | 2003-09-03T19:54:06Z |
Hi everyone!
I have a Java method that reads a SQL plain file and sends the
sentences to Firebird.... at moment only CREATE TABLE is supported...
I'm getting the following error:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. unsuccessful
metadata update
object TMETA_TIPOS is in use
when the method sends the following sentence:
CREATE TABLE Ttipos (
tip_id SMALLINT NOT NULL,
tip_nombre VARCHAR(50) NOT NULL,
mtip_id SMALLINT NOT NULL,
FOREIGN KEY (mtip_id) REFERENCES Tmeta_tipos(mtip_id),
PRIMARY KEY (tip_id)
);
Before that sentence the following two sentences has been executed in
a correct way...
CREATE TABLE Tvarsys (
var_nombre VARCHAR(50) NOT NULL,
var_valor VARCHAR(200) NOT NULL,
PRIMARY KEY (var_nombre)
);
CREATE TABLE Tmeta_tipos (
mtip_id SMALLINT NOT NULL,
mtip_nombre VARCHAR(20) NOT NULL,
PRIMARY KEY (mtip_id)
);
What happens?
Thanks! And sorry about my poor english...
I have a Java method that reads a SQL plain file and sends the
sentences to Firebird.... at moment only CREATE TABLE is supported...
I'm getting the following error:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. unsuccessful
metadata update
object TMETA_TIPOS is in use
when the method sends the following sentence:
CREATE TABLE Ttipos (
tip_id SMALLINT NOT NULL,
tip_nombre VARCHAR(50) NOT NULL,
mtip_id SMALLINT NOT NULL,
FOREIGN KEY (mtip_id) REFERENCES Tmeta_tipos(mtip_id),
PRIMARY KEY (tip_id)
);
Before that sentence the following two sentences has been executed in
a correct way...
CREATE TABLE Tvarsys (
var_nombre VARCHAR(50) NOT NULL,
var_valor VARCHAR(200) NOT NULL,
PRIMARY KEY (var_nombre)
);
CREATE TABLE Tmeta_tipos (
mtip_id SMALLINT NOT NULL,
mtip_nombre VARCHAR(20) NOT NULL,
PRIMARY KEY (mtip_id)
);
What happens?
Thanks! And sorry about my poor english...