Spatial Types Platform
For those interested in Spatial types, we'd like to know if Windows only support would work. It would be some extra work to ensure that they are work across all platforms, which is why we are asking. Also, do you use JPOX spatial types in your applications? Thanks.
--Tres London [SQL Server]
This post is provided 'as is' and confers no express or implied warranties or rights.
Comments
Anonymous
April 30, 2009
PingBack from http://asp-net-hosting.simplynetdev.com/spatial-types-platform/Anonymous
June 14, 2009
I've developed the open source Hibernate Spatial extension to Hibernate. This extension enables hibernate persistence for spatial types. Currently it works with MySQL, postgis and Oracle Spatial. I'd like to add MS Sqlserver to this list. Windows-only support will definitely not work for me. I'd be happy to implement conversion to and from Java geometry objects if only I could understand the binary layout of the geometry objects. Is there any document or spec that provides this information?Anonymous
June 14, 2009
Thank you for your interest. Let us see what can we do to help you.Anonymous
June 14, 2009
The comment has been removedAnonymous
June 17, 2009
We have provided the reqested information to Karel. By the way Tim, are you interested in Euclidean geometry or you are interested in three dimensional geometry too?Anonymous
January 28, 2010
Has there been any word on this effort by Hibernate Spatial or otherwise? My company is in need for a Java solution to access spatial data from MSSQL 2008. Thanks, SteveAnonymous
January 31, 2010
For those that are interested, I found out that Hibernate Spatial will be coming out with the SQL 2008 provider in about 2 weeks (currently in truck).Anonymous
February 02, 2010
Can you clarify this statement please? Who is doing the Hibernate Spatial?Anonymous
February 02, 2010
The hibernate spatial project is located at http://www.hibernatespatial.org/ just building the software now to see how well this works. I will post a status once I have tried it out. Thanks, MarkAnonymous
April 06, 2010
Hibernate Spatial now supports Microsoft SQL Server 2008. With this you can use Hibernate to store/retrieve Geometries in SQL Server, and use spatial filters and other OGC functions. If you don't use Hibernate, you can still profit from this library. The Geometry encoder/decoder classes can be used outside of Hibernate. Check the javadoc at http://www.hibernatespatial.org/hibernate-spatial-sqlserver/apidocs/index.htmlAnonymous
February 11, 2014
What is the base way to update/insert spatial data in sql server using an java application without using Hibernate and using directly com.microsoft.sqlserver.jdbc.SQLServerDriverAnonymous
February 11, 2014
We solved this problem by serializing the data to its native format and sending it over the wire. The format is described here: msdn.microsoft.com/.../ee320529.aspxAnonymous
February 12, 2014
@Sebastien Chan-Tin: Thank you for reply. Is there and example code?