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/
