Hi,

when performing DDL statements, those ones which deal with the
underlying structures of the database, there must be just one connection
opened to the database.

If you don't do it, you'll receive Exceptions.

Best regards,

Juan Pedro Lopez

> 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...
>
>
> Yahoo! Groups Sponsor
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

--
Juan Pedro López Sáez
ALTIRIA TIC, S.L.L.
www.altiria.com