( http://www.google.com/search?q=jaybird+sql+dialect+3&ie=UTF-8&oe=UTF-8 )
;-)


Am 15.07.2004 13:50 Uhr schrieb "Burghard W.V. Britzke" unter
<bubi@...-berlin.de>:

> 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]