Subject | problem adding date column through JDBC |
---|---|
Author | aman |
Post date | 2004-07-15T11:30:03Z |
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]
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]