{"action":"created","issue":{"url":"https://api.github.com/repos/postgis/postgis-java/issues/39","repository_url":"https://api.github.com/repos/postgis/postgis-java","labels_url":"https://api.github.com/repos/postgis/postgis-java/issues/39/labels{/name}","comments_url":"https://api.github.com/repos/postgis/postgis-java/issues/39/comments","events_url":"https://api.github.com/repos/postgis/postgis-java/issues/39/events","html_url":"https://github.com/postgis/postgis-java/issues/39","id":132355407,"number":39,"title":"PostGIS JDBC Driver extension inconsistencies","user":{"login":"asifnaeem","id":4920151,"avatar_url":"https://avatars.githubusercontent.com/u/4920151?v=3","gravatar_id":"","url":"https://api.github.com/users/asifnaeem","html_url":"https://github.com/asifnaeem","followers_url":"https://api.github.com/users/asifnaeem/followers","following_url":"https://api.github.com/users/asifnaeem/following{/other_user}","gists_url":"https://api.github.com/users/asifnaeem/gists{/gist_id}","starred_url":"https://api.github.com/users/asifnaeem/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/asifnaeem/subscriptions","organizations_url":"https://api.github.com/users/asifnaeem/orgs","repos_url":"https://api.github.com/users/asifnaeem/repos","events_url":"https://api.github.com/users/asifnaeem/events{/privacy}","received_events_url":"https://api.github.com/users/asifnaeem/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-02-09T08:02:28Z","updated_at":"2016-02-10T08:57:31Z","closed_at":null,"body":"While using postgis-2.1.8.tar.gz PostGIS JDBC extension with PG9.5 following anomalies are observed i.e.\r\n\r\n1. Version.getFullVersion() method returning wrong version i.e.\r\n> PostGIS JDBC V2.0.0\r\n    It seems that related version information require to be updated i.e.\r\n      java/jdbc/src/org/postgis/version.properties\r\n>       REL_MAJOR_VERSION=2\r\n>       REL_MINOR_VERSION=0\r\n>       REL_MICRO_VERSION=0\r\n\r\n2. Test case java/jdbc/src/examples/TestParser.java fail with two type of errors i.e.\r\n\r\nA). There are # of failure because of \"can not mix dimensionality in a geometry\", It seems a test case bug.\r\n\r\n>     2016-02-05 11:19:54 PKT ERROR:  can not mix dimensionality in a geometry\r\n>     2016-02-05 11:19:54 PKT HINT:  \"...IONM(POINT(10 10 20),POINT(20 20 20))\" <-- parse error at position 52 within geometry\r\n>     2016-02-05 11:19:54 PKT STATEMENT:  SELECT geometry_in('GEOMETRYCOLLECTIONM(POINT(10 10 20),POINT(20 20 20))')\r\n\r\n             Test case output snippet i.e.\r\n\r\n> Testing on connection 0: postgres\r\n> --- Server side error: org.postgresql.util.PSQLException: ERROR: can not mix dimensionality in a geometry\r\n>   Hint: \"...ONM(POINT(10 10 20),POINT(20 20 20))\" <-- parse error at position 53 within geometry\r\n> SQLout  :  GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> Eq SQLout: yes\r\n> Prepared:  GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> Eq Prep: yes\r\n> --- Server side error: org.postgresql.util.PSQLException: ERROR: can not mix dimensionality in a geometry\r\n>   Hint: \"...ONM(POINT(10 10 20),POINT(20 20 20))\" <-- parse error at position 53 within geometry\r\n> --- Server side error: org.postgresql.util.PSQLException: ERROR: can not mix dimensionality in a geometry\r\n>   Hint: \"...ONM(POINT(10 10 20),POINT(20 20 20))\" <-- parse error at position 53 within geometry\r\n> hexNWKT:   GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> equal    : yes\r\n> hexXWKT:   GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> equal    : yes\r\n> NWKT:      GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> equal    : yes\r\n> XWKT:      GEOMETRYCOLLECTIONM(POINTM(10 10 20),POINTM(20 20 20))\r\n> equal    : yes\r\n\r\n\r\nYou can observe that test case is using POINT instead of POINTM for some cases that is troubling PostGIS.\r\n\r\n B). Second set of errors are failing with following errors i.e.\r\n\r\n> 2016-02-05 11:19:55 PKT ERROR:  parse error - invalid geometry\r\n> 2016-02-05 11:19:55 PKT HINT:  \"GEOMETRYCOLLECTION(EMPTY\" <-- parse error at position 24 within geometry\r\n> 2016-02-05 11:19:55 PKT STATEMENT:  SELECT geometry_in('GEOMETRYCOLLECTION(EMPTY)')\r\n\r\nIt looks like a bug to me that result in query like \"SELECT geometry_in('GEOMETRYCOLLECTION(EMPTY)')\" instead of \"SELECT geometry_in('GEOMETRYCOLLECTION EMPTY')\" i.e. new representation.\r\n\r\nI have also reported this issue on https://trac.osgeo.org/postgis/ticket/3453.\r\n"},"comment":{"url":"https://api.github.com/repos/postgis/postgis-java/issues/comments/182259761","html_url":"https://github.com/postgis/postgis-java/issues/39#issuecomment-182259761","issue_url":"https://api.github.com/repos/postgis/postgis-java/issues/39","id":182259761,"user":{"login":"phillipross","id":9845938,"avatar_url":"https://avatars.githubusercontent.com/u/9845938?v=3","gravatar_id":"","url":"https://api.github.com/users/phillipross","html_url":"https://github.com/phillipross","followers_url":"https://api.github.com/users/phillipross/followers","following_url":"https://api.github.com/users/phillipross/following{/other_user}","gists_url":"https://api.github.com/users/phillipross/gists{/gist_id}","starred_url":"https://api.github.com/users/phillipross/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/phillipross/subscriptions","organizations_url":"https://api.github.com/users/phillipross/orgs","repos_url":"https://api.github.com/users/phillipross/repos","events_url":"https://api.github.com/users/phillipross/events{/privacy}","received_events_url":"https://api.github.com/users/phillipross/received_events","type":"User","site_admin":false},"created_at":"2016-02-10T08:57:31Z","updated_at":"2016-02-10T08:57:31Z","body":"If you are using a release that is bundled with debian, this could be a debian packaging issue.\r\n\r\nWould you be able to try to download and use one of the releases from github or maven central?\r\n\r\nIf you want to build from source, you can download from [github](https://github.com/postgis/postgis-java/archive/v2.2.0.tar.gz).\r\nIf you just want a jar to include in your classpath, download from [maven central](http://search.maven.org/remotecontent?filepath=net/postgis/postgis-jdbc/2.2.0/postgis-jdbc-2.2.0.jar)\r\n\r\nIf these work for you, we'll have to work with the maintainer of the debian package to narrow down the problem."}}