Updated to Firebird 2.5. Problem still exsists. Tried a lot of options but still no succes. Also searched a lot on the internet but still no solution.

If I try directly with JDBC to update a char(1) column I still get the error:

at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 68
N

Also use Hibernate. Hibernate is able to update this column. What is wrong with simple JDBC code or configuration.

--- In firebird-support@yahoogroups.com, "bertink2001" <bertink@...> wrote:
>
> 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?
>