ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Evgenii Zhuravlev <e.zhuravlev...@gmail.com>
Subject Re: Error while passing arraylist as argument to INSERT data into Ignite cache using pyodbc
Date Tue, 23 May 2017 14:36:26 GMT
Hi,
It's could be a problem with encoding, did you try to use utf8?

2017-05-23 7:58 GMT+03:00 rishi007bansod <rishi007bansod@gmail.com>:

> If instead of id_list i.e. list of ids, if I pass single parameter(not
> list)
> as argument as follows,
>
> *cursor = connection.cursor()
> select_string= "INSERT INTO Person (_key, id,  firstName, lastName, salary)
> VALUES (322, ? , 'abcd', 'dhsagd', 1000)"
>
> cursor.execute(select_string, 'test')
> *
> I am still getting following error,
>
> *Traceback (most recent call last):
>   File "pythonOdbclist.py", line 13, in <module>
>     cursor.execute(select_string, id_list)
> pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 1
> parameters were supplied', 'HY000')*
>
> I think either Ignite or pyodbc is unable to identify paramere marker *"?"*
> that I have provided
>
> Thanks.
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Error-while-passing-arraylist-as-
> argument-to-INSERT-data-into-Ignite-cache-using-pyodbc-tp13049p13079.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>

Mime
View raw message