You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When doing a query, using ST_SRID(), the result is always 0. Since Hibernate Spatial uses this method in its test queries (see below an example query), the GeoDB dialect cannot be made compatible.
A possible solution would be to always store geometries as EWKB, but this probably break the current support for WKB/WKT methods.
Hibernate Spatial query (from test suite):
select geomentity0_.id as col_0_0_, ST_Within(geomentity0_.geom, ST_GeomFromText(?, 4326)) as col_1_0_ from GEOMTEST geomentity0_ where ST_Within(geomentity0_.geom, ST_GeomFromText(?, 4326))=1 and ST_SRID(geomentity0_.geom)=4326
The text was updated successfully, but these errors were encountered:
How is the data/geometry being inserted into the table? Any chance you could provide a quick test case to reproduce the issue? With that we should be able to quickly fix. And if you want to whip up a patch even better :)
Let me get back to you next week with a test. I'm willing to supply a
patch, but before I do so, I'd like to discuss the impact with you (I
don't plan to destroy the existing codebase ;-)
How is the data/geometry being inserted into the table? Any chance you could provide a quick test case to reproduce the issue? With that we should be able to quickly fix. And if you want to whip up a patch even better :)
Thinking more about this issue... by default new geometries should be written in EWKB. The only case in which they are not is when an older version of JTS is being used. I had to patch JTS mid 1.12 in order to support writing of the SRID.
Can you confirm which version is being used in the hibernate spatial case? Thanks.
When doing a query, using ST_SRID(), the result is always 0. Since Hibernate Spatial uses this method in its test queries (see below an example query), the GeoDB dialect cannot be made compatible.
A possible solution would be to always store geometries as EWKB, but this probably break the current support for WKB/WKT methods.
Hibernate Spatial query (from test suite):
select geomentity0_.id as col_0_0_, ST_Within(geomentity0_.geom, ST_GeomFromText(?, 4326)) as col_1_0_ from GEOMTEST geomentity0_ where ST_Within(geomentity0_.geom, ST_GeomFromText(?, 4326))=1 and ST_SRID(geomentity0_.geom)=4326
The text was updated successfully, but these errors were encountered: