[
https://issues.apache.org/jira/browse/IGNITE-5663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16073896#comment-16073896
]
ASF GitHub Bot commented on IGNITE-5663:
----------------------------------------
GitHub user isapego opened a pull request:
https://github.com/apache/ignite/pull/2237
IGNITE-5663: ODBC: Closing cursor do not reset prepared statement anymore
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-5663
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/2237.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #2237
----
commit 0c6c7d98a887a13aca07a2adca2d1b13f9ad69c8
Author: Igor Sapego <[email protected]>
Date: 2017-07-04T16:01:21Z
IGNITE-5663: Fixed an issue.
commit a429648bcbae5b9faabc6d8ec7882763601486ea
Author: Igor Sapego <[email protected]>
Date: 2017-07-04T16:33:41Z
IGNITE-5663: Added test
----
> ODBC: Few consecutive inserts lead to exception
> -----------------------------------------------
>
> Key: IGNITE-5663
> URL: https://issues.apache.org/jira/browse/IGNITE-5663
> Project: Ignite
> Issue Type: Bug
> Components: odbc
> Affects Versions: 2.0
> Reporter: Evgenii Zhuravlev
> Assignee: Igor Sapego
> Labels: important, odbc
> Fix For: 2.1
>
>
> Exception: ('HY010', '[HY010] Query is not prepared. (0) (SQLExecDirectW)')
> Reproducer in python:
> {code:java}
> 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)
> {code}
> Also, the same behavior with executemany.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
