Hi Fred,
Thanks for your quick response.
On Thursday 23 May 2002 16:32, fredt wrote:
> 1. It seems the column type in your table is not BIT which we use for
> BOOLEAN. The following statements all work in our DB Manager and have been
> tested via JDBC as well (upper case use of TRUE and FALSE is also
> supported)
>
> create table t(b bit);
> insert into t(b) values(true);
> insert into t(b) values('true');
> insert into t(b) values(1);
> insert into t(b) values(false);
> insert into t(b) values('false');
> insert into t(b) values(0);
Thanks, spot on.
I have added a toString() method to jdbcPreparedStatement:
public String toString() {
return build();
}
I have now run into what looks like a deeper problem,
which I have seen in other DBs vis you can't ORDER BY fields that aren't in
your selection.
eg
SELECT "name" FROM "people" ORDER BY "dateofbirth";
will fail as dateofbirth isn't in the returned values list.
Also the error message doesn't show the quotes in the ORDER BY clause.
Is this something you are likely to be able to fix soon or should I have a go
and submit a patch?
cheers
Tim P
org.melati.poem.ExecutingSQLPoemException: Executing SQL ...
SELECT "id" FROM "tableinfo" ORDER BY displayorder, name
Error reported by jdbc driver
Column not found: S0022 Column not found: DISPLAYORDER in statement [SELECT
"id" FROM "tableinfo" ORDER BY displayorder, name]
---
java.sql.SQLException: Column not found: S0022 Column not found: DISPLAYORDER
in statement [SELECT "id" FROM "tableinfo" ORDER BY displayorder, name]
at org.hsqldb.Trace.getError(Unknown Source)
at org.hsqldb.jdbcResultSet.(Unknown Source)
at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
at org.hsqldb.jdbcConnection.execute(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
at org.melati.poem.Table.selectionResultSet(Table.java:931)
at org.melati.poem.Table.troidSelection(Table.java:949)
at org.melati.poem.Database.getDisplayTables(Database.java:681)
at java.lang.reflect.Method.invoke(Native Method)
_______________________________________________________________
Don't miss the 2002 Sprint PCS Application Developer's Conference
August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
