You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Igor Sapego (JIRA)" <ji...@apache.org> on 2016/11/23 16:43:58 UTC

[jira] [Comment Edited] (IGNITE-4288) ODBC: Fix ODBC and DML interoperability.

    [ https://issues.apache.org/jira/browse/IGNITE-4288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15690662#comment-15690662 ] 

Igor Sapego edited comment on IGNITE-4288 at 11/23/16 4:43 PM:
---------------------------------------------------------------

Getting the following exception:
{noformat}
18:49:00][TestInsertSelect] [23-Nov-2016 15:49:00][ERROR][odbc-#1060%NodeMain%][OdbcRequestHandler] Failed to execute SQL query [reqId=69, req=OdbcQueryExecuteRequest [cacheName=cache, sqlQry=INSERT INTO TestType(_key, strField) VALUES(?, ?), args=[1, String#0]]]
[18:49:00][TestInsertSelect] java.lang.NullPointerException
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcUtils.addQuotationMarksIfNeeded(OdbcUtils.java:31)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcColumnMeta.<init>(OdbcColumnMeta.java:57)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.convertMetadata(OdbcRequestHandler.java:507)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:214)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:109)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:124)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:33)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:270)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:107)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:95)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
[18:49:00][TestInsertSelect] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[18:49:00][TestInsertSelect] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[18:49:00][TestInsertSelect] 	at java.lang.Thread.run(Thread.java:745)
{noformat}


was (Author: isapego):
Getting the following exception:
{noformat}
[18:49:00][TestInsertSelect] [23-Nov-2016 15:49:00][WARN ][odbc-#1060%NodeMain%][IgniteH2Indexing] Binary object's type does not have identity resolver explicitly set, therefore BinaryArrayIdentityResolver is used to generate hash codes for its instances, and therefore hash code of this binary object will most likely not match that of its non serialized form. For finer control over identity of this type, please update your BinaryConfiguration accordingly. [typeId=-1145816372, typeName=TestType]
[18:49:00][TestInsertSelect] [23-Nov-2016 15:49:00][ERROR][odbc-#1060%NodeMain%][OdbcRequestHandler] Failed to execute SQL query [reqId=69, req=OdbcQueryExecuteRequest [cacheName=cache, sqlQry=INSERT INTO TestType(_key, strField) VALUES(?, ?), args=[1, String#0]]]
[18:49:00][TestInsertSelect] java.lang.NullPointerException
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcUtils.addQuotationMarksIfNeeded(OdbcUtils.java:31)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcColumnMeta.<init>(OdbcColumnMeta.java:57)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.convertMetadata(OdbcRequestHandler.java:507)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.executeQuery(OdbcRequestHandler.java:214)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcRequestHandler.handle(OdbcRequestHandler.java:109)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:124)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.processors.odbc.OdbcNioListener.onMessage(OdbcNioListener.java:33)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:270)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:107)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:95)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
[18:49:00][TestInsertSelect] 	at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
[18:49:00][TestInsertSelect] 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[18:49:00][TestInsertSelect] 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[18:49:00][TestInsertSelect] 	at java.lang.Thread.run(Thread.java:745)
{noformat}

> ODBC: Fix ODBC and DML interoperability.
> ----------------------------------------
>
>                 Key: IGNITE-4288
>                 URL: https://issues.apache.org/jira/browse/IGNITE-4288
>             Project: Ignite
>          Issue Type: Bug
>          Components: odbc
>    Affects Versions: 1.7
>            Reporter: Igor Sapego
>            Assignee: Igor Sapego
>             Fix For: 1.8
>
>
> Need to fix ODBC-DML interoperability issues on ignite-1.8 branch.
> Failing tests list:
> * odbc-tests/QueriesTestSuite/TestInsertDeleteSelect 	
> * odbc-tests/QueriesTestSuite/TestInsertMergeSelect 	
> * odbc-tests/QueriesTestSuite/TestInsertSelect 	
> * odbc-tests/QueriesTestSuite/TestInsertUpdateSelect 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)