NHibernateSpatial Forum Rss Feed

New Post: Is there an Oracle implementation?

Greif — Mon, 15 Jun 2009 00:37:43 GMT

Any update on this? I am willing to assist with creating an Oracle dialect as well

New Post: MySQL Provider

rstuven — Wed, 08 Oct 2008 16:25:35 GMT

Ben,$0$0$0$0Check out the latest release of NH.Spatial:$0$0http://www.nhforge.org/media/p/83.aspx$0$0$0$0$0$0Ricardo.$0

New Post: MySQL Provider

santoshamb — Sun, 05 Oct 2008 06:18:26 GMT

dodecaphonic,

How is it going wit the MySQL provider? My host has MySQL and I really want to use NHibernate.Spatial!

Ben

New Post: NH.Spatial Postgis possible bug?

rstuven — Fri, 26 Sep 2008 18:48:15 GMT

$0I think what you want to query is "City contains a point", so you sould use Contains instead of Within (ie. SpatialExpression.Contains(A,B) = "A contains B")$0

New Post: NH.Spatial Postgis possible bug?

demol — Fri, 26 Sep 2008 14:47:29 GMT

Hello guys...
I´m trying to execute a "within" postgis function using NH.Spatial ...
The SQL that I need to get is something like that :

select nomemunicipio from tblcity m where within
( '0101000020C31000000000000000C049C06666666666E633C0', m.the_geom)

So, I created my City class/xml, with geom like that:
<property name="Geometry" column="the_geom">
<type
name="NHibernate.Spatial.Type.GeometryType,NHibernate.Spatial">
<param name="subtype">MULTIPOLYGON</param>
<param name="srid">4291</param>
</type>
</property>

That works great to load, insert ...

So, I execute that:

public IList FindByPoint(IPoint __point)
{
IList results = Session.CreateCriteria(typeof(City))
.Add(SpatialExpression.Within("Geometry", __point))
.List();
return results;
}
And I always got a empty result...
The SQL generated was :

SELECT ... FROM tblCity this_ WHERE
ST_Within(this_.the_geom, :p0); :p0 =
'0101000020C31000000000000000C049C06666666666E633C0'

It seems the ST_Within attributes was inverted... The geometry (p0)
needs to be the fisrt in function...
Is that corrected?

Ps,: I´m using trunk build...

Thanks

New Post: New NHibernate support?

D_Guidi — Sat, 20 Sep 2008 08:33:56 GMT

WOW :-0

New Post: New NHibernate support?

rstuven — Fri, 19 Sep 2008 18:46:59 GMT

Sorry for not mentioning it in the project homepage here at Codeplex in a timely manner: NH Spatial is moving to NH Contrib project. NH Spatial aims to support NH 2.0 SP1 and NH 1.2 support has already been dropped.

New Post: New NHibernate support?

demol — Thu, 18 Sep 2008 14:21:53 GMT

Hello guys...I´d like to known if you plan to realease support to the new NHibernate version ...
If yes, when?

Thnx

New Post: NHibernate Compatibility

rstuven — Thu, 31 Jul 2008 20:19:03 GMT

Currently, NHibernate 1.2 and an alpha (and patched) version of NHibernate 2.

New Post: NHibernate Compatibility

kvalcanti — Thu, 17 Jul 2008 14:22:43 GMT

Which version of NHibernate are you compatible with?
I´ve noticed a change from NHibernate.Expression to NHibernate.Criterion namespaces at some point in NHibernate development.

New Post: MySQL Provider

rstuven — Mon, 23 Jun 2008 10:33:37 GMT

I don't have any news of someone implementing a MySQL provider. If you want to be the first, please go ahead! :-)

Note that the code structure has changed in recent days, giving to every provider its own project. So, if you want to implement a provider, you should create two new projects: one for the provider implementation and another for the tests.

Best regards,
Ricardo Stuven.

NEW POST: MySQL Provider

dodecaphonic — Wed, 04 Jun 2008 14:21:39 GMT

Hello, everyone. I'm about to start implementing a MySQL provider for NHibernate.Spatial, and I was wondering if there was anyone already working on that. It's my wish to help if there is, so if anyone is already on the task, please let me know.

NEW POST: Is there an Oracle implementation?

rstuven — Fri, 23 May 2008 20:03:09 GMT

Great! Regarding your questions:

1. I would prefer to keep the code compatible with C# 2.0, but there is no problem if you create solution and project files for VS2008.

2. So far, there is limited support for NH 1.2 and experimental support for NH 2. Run the unit tests to get a picture of the progress of each version. To get NH2 version up and running, I had to create a patch to support parameters in HQL functions (submitted to NHibernate but not applied yet). As I said above, you will find a good reference implementation of an Oracle provider in the Java analogue of this project.

Please, don't hesitate to make more questions. Have fun!

NEW POST: Is there an Oracle implementation?

rnbell — Thu, 22 May 2008 20:20:44 GMT

NEW POST: Is there an Oracle implementation?

rnbell — Thu, 22 May 2008 20:20:18 GMT

I'm interested on working on an implementation of Oracle Spatial in NHibernate.Spatial.

Couple of quick questions to help things along:

1. Is there a port of this for VS2008, or would you like me to keep it in VS2005
2. Is there anything that will help me understand what you've been doing so far besides going through the code (which I've already started doing). It looks like the major complexity of the project has been mapped out by you guys and someone just needs to fill in the Oracle Spatial end of it.

NEW POST: IsWithin() and other table-valued functions being implemented

rstuven — Mon, 31 Mar 2008 05:38:47 GMT

I think you meant ST.IsWithinDistanceQuery because there is no ST.IsWithinQuery... but definitvely you pose a very good question.

Yes, NHibernate does not support table-valued functions, but that is not a problem in this case (see GetSpatialFilterString method implementation in MsSqlSpatialDialect.cs). Then an interface to ST.IsWithinDistanceQuery is possible and I think it could be added in future versions.

NEW POST: Is there an Oracle implementation?

rstuven — Mon, 31 Mar 2008 03:21:37 GMT

No, there's no support for Oracle and I have no plans to implement it in the near future. But if you or anyone wants to contribute an implementation, there is a good starting point in the Hibernate Spatial project. Though (N)Hibernate Spatial projects are not ports one of each other, they share a similar structure since both are based on the same ports (Hibernate/NHibernate and JTS/NTS) .

NEW POST: Is there an Oracle implementation?

frick — Wed, 12 Mar 2008 14:24:28 GMT

Does anybody know if there is an Oracle implementation of NHibernate.Spatial? Is one planned?

Cheers

NEW POST: IsWithin() and other table-valued functions being implemented

dpollock — Thu, 06 Mar 2008 02:15:58 GMT

I started using this for a project that ties into mssqlspatial. I noticed that the functions that were based on table-valued functions in sql 2005 weren't implemented. I'd like to work on this particularly the IsWithin() function.

I was wandering if you had a plan or path for this. Looking at it, I'm not sure yet how to integrate calls to ST.IsWithinQuery or ST.EqExactQuery. I see that i can register them and i know that we can map and call table-valued functions via nhibernate (see http://www.ayende.com/Blog/archive/2006/10/01/7235.aspx for info). But how do we go about getting to smoothly integerate into the current nhibernate.spatial library?

NEW POST: Katmai / SQL Server 2008

rstuven — Thu, 17 Jan 2008 00:07:02 GMT

Yes. I'm working on that. But, if we compare the current Katmai support to PostGIS and MsSqlSpatial support, it's very incomplete yet (no agreggate and transform projections, no ability to create new spatial reference definitions, some internal WKT issues) and many tests don't pass. Besides, Katmai ground is still shaky, so I think I will wait to the next CTP to commit these changes

Best regards,
Ricardo Stuven.