Thank you for the code sample. I can get this to run, but I cannot get it to
work when connecting to a remote cluster. That is when I receive the
IgniteCheckedException. I have added the following jars to the remote nodes
/libs folder:
ignite-geospatial-2.7.2.jar
jts-1.13.jar
Here's the stacktrace:
EVERE: 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=963768574, hash=-229554403,
coordinates=com.vividsolutions.jts.geom.impl.CoordinateArraySequence
[idHash=596905862, hash=374600413, dimension=3,
coordinates=[com.vividsolutions.jts.geom.Coordinate [idHash=1712666248,
hash=-1405598900, x=8873.0, y=3969.0, z=NaN]], envelope=null,
factory=com.vividsolutions.jts.geom.GeometryFactory [idHash=1163404461,
hash=1836134263, precisionModel=com.vividsolutions.jts.geom.PrecisionModel
[idHash=1931008760, hash=-579810316,
modelType=com.vividsolutions.jts.geom.PrecisionModel$Type
[idHash=1894978338, hash=679225126, name=FLOATING], scale=0.0],
coordinateSequenceFactory=com.vividsolutions.jts.geom.impl.CoordinateArraySequenceFactory
[idHash=1058921154, hash=1], SRID=0], SRID=0, userData=null]"; SQL
statement:
SELECT
SPATIAL_CACHE1.__Z0._KEY __C0_0,
SPATIAL_CACHE1.__Z0._VAL __C0_1
FROM SPATIAL_CACHE1.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.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:170)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:168)
at
org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:3405)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1642)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:876)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$8.iterator(IgniteH2Indexing.java:1809)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$9.iterator(IgniteH2Indexing.java:1877)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:114)
at
com.viasat.atg.em.msgeo.memoir.streamers.SpatialQueryExample.main(SpatialQueryExample.java:68)
Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting
"com.vividsolutions.jts.geom.Point [idHash=963768574, hash=-229554403,
coordinates=com.vividsolutions.jts.geom.impl.CoordinateArraySequence
[idHash=596905862, hash=374600413, dimension=3,
coordinates=[com.vividsolutions.jts.geom.Coordinate [idHash=1712666248,
hash=-1405598900, x=8873.0, y=3969.0, z=NaN]], envelope=null,
factory=com.vividsolutions.jts.geom.GeometryFactory [idHash=1163404461,
hash=1836134263, precisionModel=com.vividsolutions.jts.geom.PrecisionModel
[idHash=1931008760, hash=-579810316,
modelType=com.vividsolutions.jts.geom.PrecisionModel$Type
[idHash=1894978338, hash=679225126, name=FLOATING], scale=0.0],
coordinateSequenceFactory=com.vividsolutions.jts.geom.impl.CoordinateArraySequenceFactory
[idHash=1058921154, hash=1], SRID=0], SRID=0, userData=null]"; SQL
statement:
SELECT
SPATIAL_CACHE1.__Z0._KEY __C0_0,
SPATIAL_CACHE1.__Z0._VAL __C0_1
FROM SPATIAL_CACHE1.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)
... 16 more
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
