Hello! Can you please show your cache configuration and the exact SQL statement used?
What happens here is that Ignite expects some composite value type as opposed to bare integer. Not so clear why yet. Regards, -- Ilya Kasnacheev пн, 28 янв. 2019 г. в 14:12, Som Som <2av10...@gmail.com>: > > hi, i'v got a roblem reading the cache throgh the odbc. > > cahche was created in .net, key type is string, value type is int. > > error text: > > SQL Error [50000]: javax.cache.CacheException: Failed to execute map query > on remote node [nodeId=c3ef8d97-09d0-432d-a0a2-7fd73e8413bc, errMsg=Failed > to execute SQL query. General error: "class > org.apache.ignite.IgniteCheckedException: Unexpected binary object class > [type=class java.lang.Integer]"; SQL statement: > > SELECT > > __Z0.CLASSCODE __C0_0, > > __Z0.PRIORITY __C0_1 > > FROM PUBLIC."QUIK.CLASSCODEPRIORITY" __Z0 [50000-197]] > > javax.cache.CacheException: Failed to execute map query on remote node > [nodeId=c3ef8d97-09d0-432d-a0a2-7fd73e8413bc, errMsg=Failed to execute SQL > query. General error: "class org.apache.ignite.IgniteCheckedException: > Unexpected binary object class [type=class java.lang.Integer]"; SQL > statement: > > SELECT > > __Z0.CLASSCODE __C0_0, > > __Z0.PRIORITY __C0_1 > > FROM PUBLIC."QUIK.CLASSCODEPRIORITY" __Z0 [50000-197]] > > javax.cache.CacheException: Failed to execute map query on remote node > [nodeId=c3ef8d97-09d0-432d-a0a2-7fd73e8413bc, errMsg=Failed to execute SQL > query. General error: "class org.apache.ignite.IgniteCheckedException: > Unexpected binary object class [type=class java.lang.Integer]"; SQL > statement: > > SELECT > > __Z0.CLASSCODE __C0_0, > > __Z0.PRIORITY __C0_1 > > FROM PUBLIC."QUIK.CLASSCODEPRIORITY" __Z0 [50000-197]] >
