Prepare statement failure

Поиск
Список
Период
Сортировка
От Graeme Leeming
Тема Prepare statement failure
Дата
Msg-id 3B12C6FC.E93FF7E1@refractions.net
обсуждение исходный текст
Список pgsql-odbc
Hi,

ODBC seems to be having a problem with the following prepared statement:
"SELECT t3.* FROM JURISDICTION2  t3 WHERE jurisdiction_name = ?"

I am trying to use a software tool called Feature Manipulation Engine
(FME) made by Safe Software to perform ODBC queries and table relates on
a Postgres database.  So far I have been partially successful in using
FME to send and retrieve data to my Postgres V7.1.1 database using the
7.01.00.04 ODBC driver.  One type of query fails every time I run it;
FME appears to form the query as a prepared SELECT statement/SQL
cursor.  I would like to know if the ODBC driver is the problem (and if
it can be fixed) or if FME is just not communicating properly with the
driver.  Snippets from the comm log are as follows:


SQLColumns:
table='jurisdiction2',field_name='jurisdiction_id',type=23,sqltype=19992256,name='int4'

SQLColumns:
table='jurisdiction2',field_name='jurisdiction_name',type=1043,sqltype=19992256,name='varchar'

SQLColumns:
table='jurisdiction2',field_name='parent_jur_id',type=23,sqltype=19992256,name='int4'

SQLColumns:
table='jurisdiction2',field_name='jurisdiction_type_id',type=23,sqltype=19992256,name='int4'

SQLColumns:
table='jurisdiction2',field_name='jurisdiction_source',type=1043,sqltype=19992256,name='varchar'

conn=20424392, query='SELECT t3.* FROM JURISDICTION2  t3 WHERE
jurisdiction_name = ?'
ERROR from backend during send_query: 'ERROR:  parser: parse error at or
near ""'
STATEMENT ERROR: func=SC_execute, desc='', errnum=-1, errmsg='Error
while executing the query (non-fatal)'

------------------------------------------------------------
                 hdbc=20424392, stmt=21495872, result=20455344
                 manual_result=0, prepare=1, internal=0
                 bindings=0, bindings_allocated=0
                 parameters=20450544, parameters_allocated=1
                 statement_type=0, statement='SELECT t3.* FROM
JURISDICTION2  t3 WHERE jurisdiction_name = ?'
                 stmt_with_params='SELECT t3.* FROM JURISDICTION2  t3
WHERE jurisdiction_name = ?'
                 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_CUR01480040'
                 ----------------QResult Info
-------------------------------
                 fields=20455312, manual_tuples=0, backend_tuples=0,
tupleField=0, conn=0
                 fetch_count=0, fcount=0, num_fields=0, cursor='(NULL)'
                 message='(NULL)', command='(NULL)', notice='(NULL)'
                 status=6, inTuples=0
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR:
parser: parse error at or near ""'
            ------------------------------------------------------------

            henv=20450944, conn=20424392, status=1, num_stmts=16
            sock=20450768, stmts=20450688, lobj_type=-999
            ---------------- Socket Info -------------------------------

            socket=412, reverse=0, errornumber=0, errormsg='(NULL)'
            buffer_in=20430864, buffer_out=20434968
            buffer_filled_in=44, buffer_filled_out=0, buffer_read_in=44
conn=20424392, SQLDisconnect
conn=20409712, SQLDisconnect


Thanks,
     Graeme Leeming


В списке pgsql-odbc по дате отправления:

Предыдущее
От: radius
Дата:
Сообщение: Re: access question
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Prepare statement failure