[htoolkit-users] testing hsql-sqlite3

[Duncan C. <dc...@ge...>]

I've been trying the test HSQL-1.7/examples/Main.hs

I've got it working for odbc, postgresql and mysql but not sqlite3.

What goes wrong is that the test program can't extract integer fields.
It's fine with varchar or string fields but not int ones.

The error reported is:
        The type of id field can't be converted to SqlText type

Note that it works ok when we try to extract an int field as a Haskell
String but not an int field as a Haskell Int (which is what the example
program tries to do).

I'll add the postgresql, mysql and odbc backends to gentoo and leave the
sqlite3 backend for the moment.

If anyone has a patch to make the sqlite3 backend work with the example
program then I'll be happy to include that into the gentoo package and
add the sqlite3 backend too.

-- 
Duncan Coutts : Gentoo Developer (Haskell herd team lead)
email         : dcoutts at gentoo dot org