Re: GNADE insert problem

[Stephen Leake <stephen_leake@acm.org>]

Jano <nono@celes.unizar.es> writes:

> Hello, I'm using GNADE and esql to insert some records in a database. 

You should also try the gnade mailing list
gnade-develop@lists.sourceforge.net.

> Line 79 in package Aenea.Db : *** Exception in query ****
> 
> SQL State : 42000 SQL Code :-1
> ---------------
> [17:32:38.42] [E] Database insertion failed: Exception name: 
> GNU.DB.SQLCLI.INVALID_CURSOR_STATE
> Message: [Proc=SQLCloseCursor][Server=hyperion][State=24000][Microsoft]
> [Controlador ODBC Microsoft Access]Estado del cursor no válido
> Call stack traceback locations:
> 0x438ee3 0x439bf6 0x439ef1 0x43b7cd 0x48c8ef 0x6ba969 0x6d5962
> 
> As you can see, it seems as if some cursor were left open and tried to 
> be reused. I've found just an example of insertion and I can see 
> anything special there.
> 
> I don't know if I'm doing something wrong or it is the fault of MSAccess 
> or esql. 

This is definitely an esql problem.

I suggest you abandon esql, and use the gnu-db-sqli package directly
instead. It's more robust, and really not that hard.

I've used gnu-db-sql to access MySQL via ODBC quite successfully. The
code generated by esql I've looked at has definite problems.

-- 
-- Stephe