[ https://issues.apache.org/jira/browse/IGNITE-7654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16394311#comment-16394311 ]
ASF GitHub Bot commented on IGNITE-7654: ---------------------------------------- GitHub user ivandasch opened a pull request: https://github.com/apache/ignite/pull/3619 IGNITE-7654 Add processing for JTS Geometry Now geometry deserializes to WKT. Also, add Spatial JDBC Example You can merge this pull request into a Git repository by running: $ git pull https://github.com/ivandasch/ignite ignite-7654 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/3619.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #3619 ---- commit abb0cf03df0da97efa0701ddbaa3eb4a43b8dac0 Author: Ivan <ivandasch@...> Date: 2018-03-10T19:38:51Z IGNITE-7654 Add processing for jts Geometry in jdbc processor, now geometry deserializes to WKT. Also, add Spatial JDBC Example ---- > Geospatial queries does not work for JDBC/ODBC > ---------------------------------------------- > > Key: IGNITE-7654 > URL: https://issues.apache.org/jira/browse/IGNITE-7654 > Project: Ignite > Issue Type: Bug > Components: jdbc, odbc, sql, thin client > Affects Versions: 2.3 > Reporter: Mikhail Cherkasov > Assignee: Ivan Daschinskiy > Priority: Major > Fix For: 2.5 > > > Geospatial queries do not work for JDBC/ODBC. > I can create a table with GEOMETRY from sqlline, like this: > {code:java} > CREATE TABLE GEO_TABLE(GID INTEGER PRIMARY KEY, THE_GEOM GEOMETRY);{code} > I can add rows: > {code:java} > INSERT INTO GEO_TABLE(GID, THE_GEOM) VALUES (2, 'POINT(500 505)');{code} > but there's no way to select GEOMETRY objects: > {code:java} > SELECT THE_GEOM FROM GEO_TABLE;{code} > sqlline throws the following excpetion: > {noformat} > Error: class org.apache.ignite.binary.BinaryObjectException: Custom objects > are not supported (state=50000,code=0) > java.sql.SQLException: class org.apache.ignite.binary.BinaryObjectException: > Custom objects are not supported > at > org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:671) > at > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute0(JdbcThinStatement.java:130) > at > org.apache.ignite.internal.jdbc.thin.JdbcThinStatement.execute(JdbcThinStatement.java:299) > at sqlline.Commands.execute(Commands.java:823) > at sqlline.Commands.sql(Commands.java:733) > at sqlline.SqlLine.dispatch(SqlLine.java:795) > at sqlline.SqlLine.begin(SqlLine.java:668) > at sqlline.SqlLine.start(SqlLine.java:373) > at sqlline.SqlLine.main(SqlLine.java:265){noformat} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)