Subject Simple update statment gives error code -104
Author bertink2001
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?