At 08:13 PM 15/09/2004 +0000, you wrote:

>Hi,
>
>I'm executing a simple
>DROP TABLE MYTABLE
>
>and I'm getting a response of
>
>GDS Exception. 335544569. Dynamic SQL Error
>SQL error code = -607
>No message for code 336068783 found.
>null
>org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569.
>Dynamic SQL Error
>SQL error code = -607
>No message for code 336068783 found.
>null
> at
>org.firebirdsql.jdbc.AbstractStatement.execute(AbstractStatement.java:510)
> at
>org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStateme
>nt.java:183)
>
>
>Now the error message is very informative. Anyone have a way of
>determining what the problem is here ?

A SQLCODE of -607 is usually a generic "unsuccessful metadata update"
exception, which would be a normal occurrence if you tried to drop a table
that was in use.

The mystery is how you got to see a GDSCODE that the system doesn't
recognise as a valid one for passing back to clients. This kind of
mismatch can occur where you have the wrong firebird.msg sitting on the
server or, at last resort, on the client.

Probably a good place to start would be in the firebird-java list, to find
out if there is a driver bug that is generating a GDSCODE that either
doesn't exist or should not have been surfaced in the error status vector
(array). The Java driver does its own thing with the ESV.

./heLen