Subject DATE with Jaybird
Author reinhardumi
Why can't I create a table with a DATE field? (See sample code)
How can I change the SQL dialect?
I am using "Firebird-1.5.0.4201_RC8-Win32" and
"FirebirdSQL-
1.5.0BetaJDK_1.4".

Sample code:

try {
Class.forName("org.firebirdsql.jdbc.FBDriver");

Connection conn = DriverManager.getConnection (
"jdbc:firebirdsql:localhost/3050:C:/db/TEST.gdb",
"SYSDBA",
"masterkey");

Statement comm = conn.createStatement();

comm.executeUpdate("CREATE TABLE table3(field DATE)");

} catch (Exception e) {
System.err.println(e.toString());
}

Exception:

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

Sorry about my English and thanks.
Reinhard