Actually… Do you create the cache with `CREATE TABLE`? How do you create objects to pass to the data streamer?
Most likely, you’re using some .Net type for the timestamp which doesn’t map correctly to the java.sql.Timestamp. And Ignite will expect the java.sql.Timestamp when you create it as a `CREATE TABLE …. RECORD_VALID_FROM TIMESTAMP`. Not sure if it is an issue and what is the correct usage and behavior, but the easiest workaround I can think of is to use plain Long values for timestamps. Stan From: Stanislav Lukyanov Sent: 15 октября 2018 г. 17:17 To: [email protected] Subject: RE: .net Datetime loads without error but table empty A guess: the value is being saved, but due to an issue with name or type matching in the QueryEntity SQL engine doesn’t return it. Look for the problem in the cache config (queryEntities property), pay attention to the names, etc. Stan From: wt Sent: 15 октября 2018 г. 12:47 To: [email protected] Subject: .net Datetime loads without error but table empty Running into an issue where i have an underlying sql server with a DateTime field. That is loaded into a class that has DateTime field in .net. I set the class field to its value like this from the data reader value = dataReader.GetDateTime(ordinal); the load code uses GetDataStreamer and completes without any exceptions raised by ignite or my code. When the table is queried no records are loaded. here is the table meta from ignite rest. The column in question is RECORD_VALID_FROM { "tablename": "ESG_Focus", "fields": [ { "name": "COMPANYID", "datatype": "java.lang.Integer" }, { "name": "ESG_FOCUS_ITEM", "datatype": "java.lang.String" }, { "name": "ESG_FOCUS_VALUE", "datatype": "java.lang.String" }, { "name": "ID", "datatype": "java.util.UUID" }, { "name": "RECORD_VALID_FROM", "datatype": "java.sql.Timestamp" } ], "indexinfo": [] } server version is 2.6 -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
