Question Re: hdbcli>2.5 cannot bind parameters by name (Python) in Technology Q&A

hdbcli>2.5 cannot bind parameters by name (Python)

michael_hadorn7 — Wed, 16 Dec 2020 09:51:20 GMT

Hi there

Since the hdbcli>=2.5 it's not possible to bind parameters by name.

In version hdbcli==2.4.202 it's still working.

With unnamed params it's working (using of ?).

I'm using conda with python 3.8 on windows.

I tested the behaviour with:

2.5.111
2.6.64

Minimal example:

from hdbcli import dbapi

conn = dbapi.connect(...)
cursor = conn.cursor()

sql = 'SELECT count(*) FROM sys.tables where table_name like :xx'
params = {
    'xx': '%'
}

cursor.execute(sql, params)
for row in cursor:
    print(row)

Error message:

SystemError: d:\bld\python-split_1602094606092\work\objects\dictobject.c:2469: bad argument to internal function

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "S:/cdwh-prefect/test.py", line 12, in <module>
    cursor.execute(sql, params)
SystemError: <built-in method parsenamedquery of pyhdbcli.Cursor object at 0x0000026BB89892F0> returned a result with an error set<br>

Re: hdbcli>2.5 cannot bind parameters by name (Python)

Kai_Mueller — Mon, 18 Jan 2021 09:50:52 GMT

Hi,

I quickly verified our issue and it's reproducible. However, colleagues already reported the issue and it's expected to be fixed in the upcoming 2.7 version of the SAP HANA clients. It's planned to be release end of January.

Best regards, Kai

Re: hdbcli>2.5 cannot bind parameters by name (Python)

michael_hadorn7 — Mon, 18 Jan 2021 15:16:17 GMT

Thanks for your answer.

Where was this information posted already? (I searched a lot for this error)

Do i looked on the wrong place?

Regards

Michael