Hi John,
let me first of all apologize, I didn't mean to criticize you, I'm sure
you had good reasons for those changes, I'm merely mean to state how
they did affect me after switching to HDBC 2.1.
Since after the rollback they no longer occurred I surmise that there is
a connection.
The error that Magicloud describes I recall only occurring when an
umlaut in the path to the database file, that may or may not be due to
the utf8-wrapping or it may just be a problem of the sqlite3.dll. No
harm in trying if it can be solved this way by just moving the database
file to one without any non-ascii characters. While I don't think that
umlauts actually cause Magiclouds problem I did notice that he signs his
emails with Chinese symbols, quite possible thus, that he has paths on
his machine with non-ascii characters.
Günther
John Goerzen schrieb:
Magicloud Magiclouds wrote:
Hi,
I am using haskelldb and haskelldb-hdbc-sqlite3. Well, I finally got
the source compiled and ran, I got this error:
App: user error (SQL error: SqlError {seState = "", seNativeError =
21, seErrorMsg = "prepare 74: SELECT subject,\n timestamp\nFROM
notes as T1\nORDER BY timestamp DESC: library routine called out of
sequence"})
Any clue what I should check? Thanks.
At the HDBC level, I would say:
I suspect that you have used a function that returns results lazily, but
haven't completely read them before calling back into the database with
something else. As an example, you should probably use quickQuery'
instead of quickQuery, unless you are fully prepared to accept the
consequences of reading data lazily from a database.
I am not very familiar with HaskellDB, and can't really comment on what
it's doing under the hood. If it is returning results to you lazily,
make sure you have completely consumed them before sending more queries
to the database.
If you can post some example code, it would likely help.
-- John
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe
