Subject | DATE with Jaybird |
---|---|
Author | reinhardumi |
Post date | 2004-01-01T13:34:16Z |
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
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