Skip site navigation (1) Skip section navigation (2)

ODBC bug?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: "Pgsql-Odbc (E-mail)" <pgsql-odbc(at)postgresql(dot)org>
Subject: ODBC bug?
Date: 2005-01-26 16:59:50
Message-ID: A3D1526C98B7C1409A687E0943EAC41001EB3C@obelix.askesis.nl (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi all,

Is there something wrong with the way the ODBC driver handles the "Parse Statement" flag when using a stored procedure? The following is the output of the psqlodbc_464.log the ODBC driver created. As can be seen, there first is an error about not being able to find a relation "getabonnementartikelheader" (the stored procedure) followed by an error about an open cursor, which I do not understand either.


conn=21052872, query='close SQL_CUR01421630'
conn=21052872, query='close SQL_CUR01432C48'
conn=21052872, query='close SQL_CUR014443D8'
conn=21052872, query='COMMIT'
conn=21204976, query='select nspname from pg_namespace n, pg_class c where c.relnamespace=n.oid and c.oid='"getabonnementartikelheader"'::regclass'
ERROR from backend during send_query: 'ERROR:  relation "getabonnementartikelheader" does not exist'
conn=21204976, query='declare SQL_CUR01432C48 cursor for SELECT * from getabonnementartikelheader(238)'
conn=21204976, query='fetch 100 in SQL_CUR01432C48'
    [ fetched 1 rows ]
STATEMENT ERROR: func=SQLExecute, desc='', errnum=3, errmsg='The cursor is open.'
                 ------------------------------------------------------------
                 hdbc=21204976, stmt=21179464, result=21087104
                 manual_result=0, prepare=1, internal=0
                 bindings=21110600, bindings_allocated=9
                 parameters=0, parameters_allocated=0
                 statement_type=0, statement='SELECT * from getabonnementartikelheader(238)'
                 stmt_with_params='declare SQL_CUR01432C48 cursor for SELECT * from getabonnementartikelheader(238)'
                 data_at_exec=-1, current_exec_param=-1, put_data=0
                 currTuple=-1, current_col=-1, lobj_fd=-1
                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
                 cursor_name='SQL_CUR01432C48'
                 ----------------QResult Info -------------------------------
                 fields=21245304, manual_tuples=0, backend_tuples=21181000, tupleField=21181000, conn=21204976
                 fetch_count=0, num_total_rows=1, num_fields=9, cursor='SQL_CUR01432C48'
                 message='(NULL)', command='FETCH', notice='(NULL)'
                 status=8, inTuples=0
CONN ERROR: func=SQLExecute, desc='', errnum=110, errmsg='(NULL)'
            ------------------------------------------------------------
            henv=21052816, conn=21204976, status=1, num_stmts=16
            sock=21089272, stmts=21102504, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=244, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=21093648, buffer_out=21215992
            buffer_filled_in=322, buffer_filled_out=0, buffer_read_in=322

Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J(dot)Kraaijeveld(at)Askesis(dot)nl
web: www.askesis.nl 

pgsql-odbc by date

Next:From: Peter EisentrautDate: 2005-01-27 15:22:42
Subject: Latest source tarballs missing
Previous:From: Merlin MoncureDate: 2005-01-26 13:26:19
Subject: Re: [HACKERS] RQ: Prepared statements used by multiple connections

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group