[IGNITE-5663] ODBC: Few consecutive inserts lead to exception

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0
• Fix Version/s: 2.1
• Component/s: odbc
• Labels: important odbc
• Assignee: Igor Sapego
• Reporter: Evgenii Zhuravlev
• Created: 03/Jul/17 14:44
• Updated: 05/Jul/17 14:17
• Resolved: 04/Jul/17 17:04

Description

Exception: ('HY010', '[HY010] Query is not prepared. (0) (SQLExecDirectW)')

Reproducer in python:

import pyodbc
cnxn = pyodbc.connect(DRIVER='{Apache Ignite}', ADDRESS='localhost:10800',CACHE="Person", autocommit=True)
cursor = cnxn.cursor()
select_string= "INSERT INTO Person(_key, id, firstName, lastName, salary) VALUES (?, ? , 'abcd', 'dhsagd', 1000)"
id_list = (1,1)
id_list2 = (2,2)
cursor.execute(select_string, id_list) 
cursor.execute(select_string, id_list2) 

Also, the same behavior with executemany.

Issue Links

• links to: GitHub Pull Request #2237