Subject | Simple update statment gives error code -104 |
---|---|
Author | bertink2001 |
Post date | 2011-04-13T09:11:28Z |
Hi,
I have a table oefening with a column : FEEDBACK "BOOLEAN" NOT NULL.
CREATE DOMAIN "BOOLEAN"
AS Char(1) CHARACTER SET NONE
CHECK (VALUE IN ('Y','N'))
COLLATE NONE;
when I execute the following statement in FlameRobin
update OEFENING set feedback = 'N'
everything works fine. But if I execute this statement from a Java program like
String sql = "UPDATE OEFENING SET FEEDBACK ='N'";
try {
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
statement.close();
} catch (SQLException e) {
result = false;
e.printStackTrace();
}
I get an exception
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 68
N
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2171)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2121)
I this a know problem (Using firebird 1.5 with Jaybird 2.1.6)? Is my configuration wrong?
I have a table oefening with a column : FEEDBACK "BOOLEAN" NOT NULL.
CREATE DOMAIN "BOOLEAN"
AS Char(1) CHARACTER SET NONE
CHECK (VALUE IN ('Y','N'))
COLLATE NONE;
when I execute the following statement in FlameRobin
update OEFENING set feedback = 'N'
everything works fine. But if I execute this statement from a Java program like
String sql = "UPDATE OEFENING SET FEEDBACK ='N'";
try {
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
statement.close();
} catch (SQLException e) {
result = false;
e.printStackTrace();
}
I get an exception
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 68
N
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJavaGDSImpl.java:2171)
at org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJavaGDSImpl.java:2121)
I this a know problem (Using firebird 1.5 with Jaybird 2.1.6)? Is my configuration wrong?