I can avoid that error if I change the geometry dependencies to this:
<dependency>
<groupId>com.vividsolutions</groupId>
<artifactId>jts</artifactId>
<version>1.13</version>
</dependency>
import com.vividsolutions.jts.geom.Geometry;
import com.vividsolutions.jts.io.WKTReader;
Then the the above exception is not thrown when creating the cache in client
mode, but then I get the following error when the query is executed:
[22:07:44,469][SEVERE][query-#9354][GridMapQueryExecutor] Failed to execute
local query.
class org.apache.ignite.IgniteCheckedException: Failed to execute SQL query.
Data conversion error converting "com.vividsolutions.jts.geom.Point
[idHash=1139007856, hash=-2050907330,
factory=com.vividsolutions.jts.geom.GeometryFactory [idHash=1194750971,
hash=1836134263, precisionModel=com.vividsolutions.jts.geom.PrecisionModel
[idHash=976951851, hash=-579810316, scale=0.0,
modelType=com.vividsolutions.jts.geom.PrecisionModel$Type
[idHash=1594250412, hash=679225126, name=FLOATING]],
coordinateSequenceFactory=com.vividsolutions.jts.geom.impl.CoordinateArraySequenceFactory
[idHash=1122645044, hash=1], SRID=0], envelope=null, userData=null,
coordinates=com.vividsolutions.jts.geom.impl.CoordinateArraySequence
[idHash=909590073, hash=-1372201509,
coordinates=[com.vividsolutions.jts.geom.Coordinate [idHash=1421840534,
hash=-1616930514, x=2351.0, y=720.0, z=NaN], dimension=3], SRID=0]"; SQL
statement:
SELECT
"SpatialQueryExample".__Z0._KEY __C0_0,
"SpatialQueryExample".__Z0._VAL __C0_1
FROM "SpatialQueryExample".MAPPOINT __Z0
WHERE INTERSECTS(__Z0.COORDS, ?1) [22018-197]
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1434)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1495)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:930)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:705)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:240)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:200)
at
org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2349)
at
org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1569)
at
org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1197)
at
org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:127)
at
org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1093)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting
"com.vividsolutions.jts.geom.Point [idHash=1139007856, hash=-2050907330,
factory=com.vividsolutions.jts.geom.GeometryFactory [idHash=1194750971,
hash=1836134263, precisionModel=com.vividsolutions.jts.geom.PrecisionModel
[idHash=976951851, hash=-579810316, scale=0.0,
modelType=com.vividsolutions.jts.geom.PrecisionModel$Type
[idHash=1594250412, hash=679225126, name=FLOATING]],
coordinateSequenceFactory=com.vividsolutions.jts.geom.impl.CoordinateArraySequenceFactory
[idHash=1122645044, hash=1], SRID=0], envelope=null, userData=null,
coordinates=com.vividsolutions.jts.geom.impl.CoordinateArraySequence
[idHash=909590073, hash=-1372201509,
coordinates=[com.vividsolutions.jts.geom.Coordinate [idHash=1421840534,
hash=-1616930514, x=2351.0, y=720.0, z=NaN], dimension=3], SRID=0]"; SQL
statement:
SELECT
"SpatialQueryExample".__Z0._KEY __C0_0,
"SpatialQueryExample".__Z0._VAL __C0_1
FROM "SpatialQueryExample".MAPPOINT __Z0
WHERE INTERSECTS(__Z0.COORDS, ?1) [22018-197]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.value.Value.convertTo(Value.java:1029)
at org.h2.value.Value.convertTo(Value.java:617)
at org.h2.value.Value.convertTo(Value.java:592)
at org.h2.expression.Comparison.compareNotNull(Comparison.java:323)
at org.h2.expression.Comparison.getValue(Comparison.java:274)
at org.h2.expression.Expression.getBooleanValue(Expression.java:178)
at org.h2.command.dml.Select.isConditionMet(Select.java:312)
at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455)
at org.h2.result.LazyResult.hasNext(LazyResult.java:79)
at org.h2.result.LazyResult.next(LazyResult.java:59)
at org.h2.command.dml.Select.queryFlat(Select.java:527)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:633)
at org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114)
at org.h2.command.dml.Query.query(Query.java:352)
at org.h2.command.dml.Query.query(Query.java:333)
at org.h2.command.CommandContainer.query(CommandContainer.java:114)
at org.h2.command.Command.executeQuery(Command.java:202)
at
org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114)
at
org.apache.ignite.internal.processors.query.h2.PreparedStatementExImpl.executeQuery(PreparedStatementExImpl.java:67)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1427)
... 13 more
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
