Re: .net entity based configuration / datetime field error

2018-09-04 Thread Som Som
thank you Pavel. It helped. I added "IgniteConfiguration.BinaryConfiguration.Serializer = new BinaryReflectiveSerializer { ForceTimestamp = true }" into config and removed attribute and it works correctly. вт, 4 сент. 2018 г., 9:35 Pavel Tupitsyn : > Hi Som, > > The issue here is that Ignite

Re: .net entity based configuration / datetime field error

2018-09-04 Thread Pavel Tupitsyn
Hi Som, The issue here is that Ignite writes DateTime in an internal format when [QuerySqlField] attribute is not present, to handle non-UTC values [1]. This internal format is not SQL-compatible. There are multiple options to enforce TIMESTAMP format: * Implement IBinarizable * Implement

Re: .net entity based configuration / datetime field error

2018-09-03 Thread Som Som
I’m connecting to the server node via DBeaver (connection settings\ jdbc url - jdbc:ignite:thin://xxx.xx.xx.xx/). I can query DateTime field if I use Attributes Based Configuration and I get an error mentioned below in case of using QueryEntity Based Configuration. How to configure a cache with

Re: .net entity based configuration / datetime field error

2018-09-03 Thread Igor Sapego
Which exactly ODBC driver are you talking about? Best Regards, Igor On Mon, Sep 3, 2018 at 4:48 PM wt wrote: > not sure if it helps but the odbc driver doesnt play nice with date fields > and deals with them in binary format > > class org.apache.ignite.binary.BinaryInvalidTypeException > >

Re: .net entity based configuration / datetime field error

2018-09-03 Thread wt
not sure if it helps but the odbc driver doesnt play nice with date fields and deals with them in binary format class org.apache.ignite.binary.BinaryInvalidTypeException your error looks to be related - have you tried the jdbc driver as a test? -- Sent from:

.net entity based configuration / datetime field error

2018-09-03 Thread Som Som
Hello. if I use Attributes Based Configuration I can put enitity into the cache via key value api and than read rhis entity through the dbeaver(select * from testentity) *Code:* namespace Example { public class TestEntity { [QuerySqlField] public string ValueString