ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-7654) Geospatial queries does not work for JDBC/ODBC
Date Sat, 10 Mar 2018 19:43:00 GMT

    [ 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)

Mime
View raw message