ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mikhail Cherkasov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7654) Geospatial queries does not work for JDBC/ODBC
Date Thu, 08 Feb 2018 19:58:00 GMT
Mikhail Cherkasov created IGNITE-7654:
-----------------------------------------

             Summary: 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
             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}
 

table creation works fine, 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}
 
{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