There is no DATE type in SQL dialect 1. Switch the driver to sql-dialect 3.


Am 15.07.2004 13:30 Uhr schrieb "aman" unter <aman.shakya@...>:

>
> 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]
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
> <http://us.ard.yahoo.com/SIG=129fcu4mq/M=295196.4901138.6071305.3001176/D=grou
> ps/S=1705006764:HM/EXP=1089977458/A=2128215/R=0/SIG=10se96mf6/*http://companio
> n.yahoo.com>
>
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> * http://groups.yahoo.com/group/Firebird-Java/
> *
> * To unsubscribe from this group, send an email to:
> * Firebird-Java-unsubscribe@yahoogroups.com
> <mailto:Firebird-Java-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> *
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>

--
_ _ _
)) _ __ ___ ))_ ___ __ __))
((_)((_( (| ((_( ((`( ((_( (| ((_(
_))
http://www.news.cornell.edu/releases/July97/guitar.ltb.html



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