(no subject)

classic Classic list List threaded Threaded
5 messages Options
Som Som Som Som
Reply | Threaded
Open this post in threaded view
|

(no subject)


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]]

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re:

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 <[hidden email]>:


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]]

Som Som Som Som
Reply | Threaded
Open this post in threaded view
|

Re:

.Net part:

    using (var ignite =Ignition.StartClient(Ignition.ClientConfigurationSectionName))

            {

                var queryEntity = new QueryEntity

                {

                    KeyTypeName = typeof(string).FullName,

                    KeyType = typeof(string),

                    ValueTypeName = typeof(int).FullName,

                    ValueType = typeof(int),

                    Fields = new[] { newQueryField("ClassCode"typeof(string)) { IsKeyField =true }, new QueryField("Priority"typeof(int)) { IsKeyField = false } }

                };

 

                queryEntity.TableName =IgniteCacheName.QUIK_CLASSCODE_PRIORITY;

 

                var cfg = new CacheClientConfiguration(IgniteCacheName.QUIK_CLASSCODE_PRIORITY, new[] { queryEntity })

                {

                    DataRegionName = "persistent",

                    Backups = 1,

                    SqlSchema = "PUBLIC"

                };

 

                var c = ignite.GetOrCreateCache<stringint>(cfg);

 

                c.Put("a", 1);

            }

 

Sql query part:

 

This query works ok – SELECT _Key, _Val FROM "QUIK.CLASSCODEPRIORITY"

But this one throws an error mentioned above SELECT SecCode, Prioruty FROM "QUIK.CLASSCODEPRIORITY"


пн, 28 янв. 2019 г., 14:23 Ilya Kasnacheev [hidden email]:
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 <[hidden email]>:


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]]

ilya.kasnacheev ilya.kasnacheev
Reply | Threaded
Open this post in threaded view
|

Re:

Hello!

>                     Fields = new[] { newQueryField("ClassCode"typeof(string)) { IsKeyField =true }, new QueryField("Priority"typeof(int)) { IsKeyField = false } }

Here you declare that you have a field ClassCode *in* your composite key, and Priority *in* your composite value.
But you have neither.

You should use KeyFieldName/ValueFieldName instead (if they present in .Net API).

Regards,
--
Ilya Kasnacheev


пн, 28 янв. 2019 г. в 15:33, Som Som <[hidden email]>:

.Net part:

    using (var ignite =Ignition.StartClient(Ignition.ClientConfigurationSectionName))

            {

                var queryEntity = new QueryEntity

                {

                    KeyTypeName = typeof(string).FullName,

                    KeyType = typeof(string),

                    ValueTypeName = typeof(int).FullName,

                    ValueType = typeof(int),

                    Fields = new[] { newQueryField("ClassCode"typeof(string)) { IsKeyField =true }, new QueryField("Priority"typeof(int)) { IsKeyField = false } }

                };

 

                queryEntity.TableName =IgniteCacheName.QUIK_CLASSCODE_PRIORITY;

 

                var cfg = new CacheClientConfiguration(IgniteCacheName.QUIK_CLASSCODE_PRIORITY, new[] { queryEntity })

                {

                    DataRegionName = "persistent",

                    Backups = 1,

                    SqlSchema = "PUBLIC"

                };

 

                var c = ignite.GetOrCreateCache<stringint>(cfg);

 

                c.Put("a", 1);

            }

 

Sql query part:

 

This query works ok – SELECT _Key, _Val FROM "QUIK.CLASSCODEPRIORITY"

But this one throws an error mentioned above SELECT SecCode, Prioruty FROM "QUIK.CLASSCODEPRIORITY"


пн, 28 янв. 2019 г., 14:23 Ilya Kasnacheev [hidden email]:
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 <[hidden email]>:


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]]

ptupitsyn ptupitsyn
Reply | Threaded
Open this post in threaded view
|

Re:

Ilya is right, what you need is:

var queryEntity = new QueryEntity
{
KeyType = typeof(string),
ValueType = typeof(int),
KeyFieldName = "ClassCode",
ValueFieldName = "Priority"
};
(KeyTypeName and ValueTypeName are names of equivalent Java types. Prefer KeyType and ValueType properties)

On Tue, Jan 29, 2019 at 8:34 PM Ilya Kasnacheev <[hidden email]> wrote:
Hello!

>                     Fields = new[] { newQueryField("ClassCode"typeof(string)) { IsKeyField =true }, new QueryField("Priority"typeof(int)) { IsKeyField = false } }

Here you declare that you have a field ClassCode *in* your composite key, and Priority *in* your composite value.
But you have neither.

You should use KeyFieldName/ValueFieldName instead (if they present in .Net API).

Regards,
--
Ilya Kasnacheev


пн, 28 янв. 2019 г. в 15:33, Som Som <[hidden email]>:

.Net part:

    using (var ignite =Ignition.StartClient(Ignition.ClientConfigurationSectionName))

            {

                var queryEntity = new QueryEntity

                {

                    KeyTypeName = typeof(string).FullName,

                    KeyType = typeof(string),

                    ValueTypeName = typeof(int).FullName,

                    ValueType = typeof(int),

                    Fields = new[] { newQueryField("ClassCode"typeof(string)) { IsKeyField =true }, new QueryField("Priority"typeof(int)) { IsKeyField = false } }

                };

 

                queryEntity.TableName =IgniteCacheName.QUIK_CLASSCODE_PRIORITY;

 

                var cfg = new CacheClientConfiguration(IgniteCacheName.QUIK_CLASSCODE_PRIORITY, new[] { queryEntity })

                {

                    DataRegionName = "persistent",

                    Backups = 1,

                    SqlSchema = "PUBLIC"

                };

 

                var c = ignite.GetOrCreateCache<stringint>(cfg);

 

                c.Put("a", 1);

            }

 

Sql query part:

 

This query works ok – SELECT _Key, _Val FROM "QUIK.CLASSCODEPRIORITY"

But this one throws an error mentioned above SELECT SecCode, Prioruty FROM "QUIK.CLASSCODEPRIORITY"


пн, 28 янв. 2019 г., 14:23 Ilya Kasnacheev [hidden email]:
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 <[hidden email]>:


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]]