Hello! It seems to me that MSSQL driver lacks any explicit support for java.time.Instant so that's on MSSQL end. You could use blob cache store instead.
Regards, -- Ilya Kasnacheev чт, 6 сент. 2018 г. в 18:48, michal23849 <michal23...@gmail.com>: > Hi, > > I have a Class with Instant data type: > > private Instant indexCreated; > > > Then I map it to VARCHAR in PojoStore: > > <bean > class="org.apache.ignite.cache.store.jdbc.JdbcTypeField"> > <property > name="databaseFieldType" > > <util:constant > static-field="java.sql.Types.VARCHAR"/> > </property> > <property > name="databaseFieldName" value="indexCreated" /> > <property > name="javaFieldType" value="java.time.Instant" /> > <property > name="javaFieldName" value="indexCreated" /> > </bean> > > And then I am getting the error from SQLServer JDBC driver: > 2018-09-03T11:48:36,737 ERROR o.a.i.i.p.c.s.GridCacheWriteBehindStore > [flusher-0-#46] Unable to update underlying store: CacheJdbcPojoStore [] > javax.cache.CacheException: Failed to set statement parameter name: > indexCreated > at > > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.fillParameter(CacheAbstractJdbcStore.java:1391) > ~[ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.fillValueParameters(CacheAbstractJdbcStore.java:1443) > ~[ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.writeAll(CacheAbstractJdbcStore.java:1102) > ~[ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.internal.processors.cache.store.GridCacheWriteBehindStore.updateStore(GridCacheWriteBehindStore.java:816) > [ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.internal.processors.cache.store.GridCacheWriteBehindStore.applyBatch(GridCacheWriteBehindStore.java:726) > [ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.internal.processors.cache.store.GridCacheWriteBehindStore.access$2400(GridCacheWriteBehindStore.java:76) > [ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.internal.processors.cache.store.GridCacheWriteBehindStore$Flusher.flushCacheCoalescing(GridCacheWriteBehindStore.java:1147) > [ignite-core-2.6.0.jar:2.6.0] > at > > org.apache.ignite.internal.processors.cache.store.GridCacheWriteBehindStore$Flusher.body(GridCacheWriteBehindStore.java:1018) > [ignite-core-2.6.0.jar:2.6.0] > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > [ignite-core-2.6.0.jar:2.6.0] > at java.lang.Thread.run(Thread.java:745) [?:1.8.0_112] > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion > from UNKNOWN to UNKNOWN is unsupported. > at > > com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:228) > ~[mssql-jdbc-6.4.0.jre8.jar:?] > at > > com.microsoft.sqlserver.jdbc.DataTypes.throwConversionError(DataTypes.java:1647) > ~[mssql-jdbc-6.4.0.jre8.jar:?] > at > > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:1868) > ~[mssql-jdbc-6.4.0.jre8.jar:?] > at > > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObjectNoType(SQLServerPreparedStatement.java:1695) > ~[mssql-jdbc-6.4.0.jre8.jar:?] > at > > com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.setObject(SQLServerPreparedStatement.java:1704) > ~[mssql-jdbc-6.4.0.jre8.jar:?] > at > > org.apache.ignite.cache.store.jdbc.CacheAbstractJdbcStore.fillParameter(CacheAbstractJdbcStore.java:1385) > ~[ignite-core-2.6.0.jar:2.6.0] > ... 9 more > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
