comp.lang.ada
 help / color / mirror / Atom feed
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: Problem in GNATColl when using prepared queries: GNATCOLL.SQL.POSTGRES.GNADE.POSTGRESQL_ERROR is raised
Date: Fri, 25 Feb 2011 17:05:50 +0100
Date: 2011-02-25T17:05:51+01:00	[thread overview]
Message-ID: <1on2yzc25jxpr.1offs3nb41fqk$.dlg@40tude.net> (raw)
In-Reply-To: 4d67ce9c$0$23765$14726298@news.sunsite.dk

On Fri, 25 Feb 2011 16:45:32 +0100, Thomas L�cke wrote:

> If I do this:
[...]

I don't understand your code, in particular where the statement prepared is
actually executed? Where the cursor gets closed? DBMS does not appreciate
cursors left unclosed. Does GNATColl maintain cursor states internally? Why
fetch is not called within a loop? You prepare the statement, but do not
bind parameters, Ludovic mentioned this. I can only stress that you will
never get it working with literal values. I've been there. It isn't worth
to try.

... and why don't you use GNADE ODBC?

[ At least ODBC has tracing mode, which sometimes with some drivers indeed
traces. So that you could see the actual statement. ]

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de



  reply	other threads:[~2011-02-25 16:05 UTC|newest]

Thread overview: 16+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-02-25 15:45 Problem in GNATColl when using prepared queries: GNATCOLL.SQL.POSTGRES.GNADE.POSTGRESQL_ERROR is raised Thomas Løcke
2011-02-25 16:05 ` Dmitry A. Kazakov [this message]
2011-02-25 18:24   ` Thomas Løcke
2011-02-25 20:08     ` Dmitry A. Kazakov
2011-02-25 21:50       ` Thomas Løcke
2011-02-26 19:33         ` Dmitry A. Kazakov
2011-02-27 14:53           ` Thomas Løcke
2011-02-27 15:36             ` Dmitry A. Kazakov
2011-02-27 15:49               ` Thomas Løcke
2011-02-27 20:15                 ` Dmitry A. Kazakov
2011-02-27 21:53                   ` Thomas Løcke
2011-02-28 13:49             ` Emmanuel Briot
2011-03-01  8:34               ` Thomas Løcke
2011-03-01 10:28                 ` Emmanuel Briot
2011-03-01 20:33                   ` Thomas Løcke
2011-03-01 20:54                     ` Dmitry A. Kazakov

replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox