tag:blogger.com,1999:blog-6029629494508626591.post8588688375939552275..comments2024-03-27T07:26:29.743+00:00Comments on Pedro's Tech Mumblings: NHibernate Spatial (Part 1 - Introduction)Pedro Sousahttp://www.blogger.com/profile/17058685497255714267noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-6029629494508626591.post-62002754609050722602013-07-10T21:54:16.431+01:002013-07-10T21:54:16.431+01:00Excellent Post. Also visit http://msnetframework.c...Excellent Post. Also visit http://msnetframework.com/#mono.phpInnovapathhttps://www.blogger.com/profile/16826867108349078043noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-6717034425460553902012-09-20T03:57:06.013+01:002012-09-20T03:57:06.013+01:00Oscar, can you send me a sample project to pedro.s...Oscar, can you send me a sample project to pedro.sousa1 _at_ gmail.com?Pedro Sousahttps://www.blogger.com/profile/17058685497255714267noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-68394565989570935692012-09-20T01:00:40.821+01:002012-09-20T01:00:40.821+01:00Hi Pedro,
Thanks for explain and helped me to solv...Hi Pedro,<br />Thanks for explain and helped me to solve the implementation of NHibernate.Spatial! but I'm having issues when retrieving Spatial fields from DB,<br />i get nothing but NULLs, im sure that i followed the steps one by one but still getting the same result.<br />hope you can help me :), regards!Oscar owohttps://www.blogger.com/profile/17425366738132260163noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-43896313312745060762012-05-10T04:37:00.847+01:002012-05-10T04:37:00.847+01:00We used the ICriterion and ICriteria interfaces to...We used the ICriterion and ICriteria interfaces to create a generic query engine. The exception pops when executing the .List() method for returning the result set.AgeBladehttps://www.blogger.com/profile/03761085321324824396noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-55272422225792798232012-05-09T18:40:58.624+01:002012-05-09T18:40:58.624+01:00Probably. Did you query using HQL, LINQ or QueryOv...Probably. Did you query using HQL, LINQ or QueryOver? I'm asking this because I had some trouble, in certain cases, when using LINQ and/or QueryOver. I've posted some query examples in Part 4 of this series, where I talked about that problem.<br /><br />So, my suggestion, first try it out with HQL.Pedro Sousahttps://www.blogger.com/profile/17058685497255714267noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-53183217471794715702012-05-09T17:48:30.029+01:002012-05-09T17:48:30.029+01:00We've compiled the code like you and tested it...We've compiled the code like you and tested it with ORACLE and it turn out working on SELECT, INSERT and UPDATE statements BUT when we tried to perform a spatial criteria it failed with a "Not all variables bound" ORA exception.<br /><br />Is there anything you know about this problem ? <br /><br />Thanks in advanceAgeBladehttps://www.blogger.com/profile/03761085321324824396noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-36898262932073857622012-05-08T13:41:37.860+01:002012-05-08T13:41:37.860+01:00I've built NH Spatial with NHibernate 3.2. I h...I've built NH Spatial with NHibernate 3.2. I had to change some additional source code to make it compile, but I don't recall exactly what. Anyway, and although it compiled correctly, I only tested it on SQL 2008/2012. Not sure at all about Oracle. SorryPedro Sousahttps://www.blogger.com/profile/17058685497255714267noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-48153848481071296662012-05-08T13:19:04.564+01:002012-05-08T13:19:04.564+01:00Hi Pedro,
Did you manage to build and test Spatial...Hi Pedro,<br />Did you manage to build and test Spatial.Oracle (By Ricardo Stuben) latest build with NHibernate 3.2 or 3.3 ?AgeBladehttps://www.blogger.com/profile/03761085321324824396noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-16036200311245184822012-04-14T20:30:44.716+01:002012-04-14T20:30:44.716+01:00very useful set of posts though - I now have nhibe...very useful set of posts though - I now have nhibernate.spatial up an running in my project thanks to your blogs. Thank you.Anonymoushttps://www.blogger.com/profile/07200606801987730997noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-66779189874756745892012-04-14T19:29:45.778+01:002012-04-14T19:29:45.778+01:00Thanks, I'm going to update the post. Anyway, ...Thanks, I'm going to update the post. Anyway, in retrospective, I should have included a zip file with the compiled dll :PPedro Sousahttps://www.blogger.com/profile/17058685497255714267noreply@blogger.comtag:blogger.com,1999:blog-6029629494508626591.post-76939749439450884432012-04-14T18:10:15.285+01:002012-04-14T18:10:15.285+01:00Hi Pedro,
In your screen shot of the dlls shipped ...Hi Pedro,<br />In your screen shot of the dlls shipped with the NetTopologySuite project there is one there called PowerCollections. I found that although I could NHibernate.Spatial to build without including it when I went to use it complained that that this dll was missing (in the class NHibernate.Spatial.Type.GeometryTypeBase). I found referencing it when building Spatial and then referencing it again in the end application resolved the issue.Anonymoushttps://www.blogger.com/profile/07200606801987730997noreply@blogger.com