Announcement and Discussions related to the Microsoft JDBC driver for SQL Server
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.
PingBack from http://asp-net-hosting.simplynetdev.com/spatial-types-platform/
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?
Thank you for your interest. Let us see what can we do to help you.
This is a hot topic for us too - we've already moved some part of our mapping data for our applications onto sql server but we need the hibernate spatial stuff to do a full job, so we'd be really pleased if this was sorted.
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?
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.
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).
Can you clarify this statement please? Who is doing the Hibernate Spatial?
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.
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.html
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.SQLServerDriver
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.aspx
Thank you for reply. Is there and example code?