Subject problem adding date column through JDBC
Author aman
When I tried to run the following sql through a JDBC connection

ALTER TABLE mytable ADD dob DATE

I got the following error

org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -817
Metadata update statement is not allowed by the current database SQL dialect 1

at org.firebirdsql.jdbc.AbstractStatement.execute(AbstractStatement.java:503)
...

I need to add columns to my table using sql. There was no problem in adding columns of types other than DATE, like STRING, INTEGER, etc. The problem is only with the date type.

Could anybody please explain this to me and suggest any solution, or is it a bug of the JDBC driver?

Aman

[Non-text portions of this message have been removed]