[mapguide-users] Add features to SQL Server Spatial

[Zac Spitzer]

it's a nasty bug huh?

On Tue, Oct 27, 2009 at 7:09 PM, Gunter Becker <gunter.becker at csogis.de>wrote:

>
> Zac, your right. I'm facing the same bug you've described in this ticket.
> No
> errors were thrown when updating my feature source and I didn't recognise
> that the updatefeature methode has a return value. So when I debug my code
> I
> see that a MgStringProperty is returned. The value of this string is:
>
> An exception occurred in FDO component. Item 'Persons' not found in
> collection
>
> OK, now I get at least an error but don't know how to interpret it.
> 'Persons' is the classname of my feature source (and the tablename in SQL
> Server).
>
> I think my feature source is not defined as read only, because using
> MgDeleteFeatures works fine and the SQL Server account which I'm using has
> read-write access.
> Like I said in my first post I can delete features but I'm not able to
> create them.
>
> Thanks, Gunter
>
>
>
>
> zspitzer wrote:
> >
> > sdf is r/w via mapguide?
> >
> > just a guess, is your feature source defined as read only?
> >
> > this might help?
> >
> > http://trac.osgeo.org/mapguide/ticket/649
> >
> >
> >
> > On Tue, Oct 27, 2009 at 1:11 PM, Jamo <adam.jamison at portbris.com.au>
> > wrote:
> >
> >>
> >> I think mapguide api only exposes sdf write capabilities?
> >> Might have to do it through fdos
> >>
> >> Rodolfo Moreno wrote:
> >> >
> >> > why don't you insert sql features using SQL spatial scripts?
> >> >
> >> > Regards,
> >> >
> >> >
> >> > Gunter Becker wrote:
> >> >>
> >> >> Is there at least anyone who had successfully added features to SQL
> >> >> Server 2008 Spatial with the MapGuide API. What could cause problems
> >> when
> >> >> adding features to the database?
> >> >>
> >> >> I think there was another thread (
> >> >>
> >>
> http://n2.nabble.com/MSSqlServer-Spatial-problem-tt3148712.html#a3154109
> >> >> MSSqlServer Spatial problem ) that describes a similar problem.
> >> >> But this problem had to do with 3-dimensional point what is not what
> i
> >> am
> >> >> using. I am using x,y-points.
> >> >>
> >> >> Any ideas?
> >> >>
> >> >> Gunter
> >> >>
> >> >>
> >> >>
> >> >> Gunter Becker wrote:
> >> >>>
> >> >>> Hi,
> >> >>>
> >> >>> i'm trying to add features to an existing FeatureSource via MapGuide
> >> >>> API. I've created a new schema with Autodesk Map 2010, created some
> >> >>> polygons, created my feature source and layer in MapGuide Studio,
> >> >>> inserted the layer in my map and it shows up fine.
> >> >>>
> >> >>> OK, displaying the features works fine. But when trying to add some
> >> >>> features via the digitize function and my serverside code nothing
> >> >>> happens. It seemes that the code works fine, cause it is the same
> >> code
> >> >>> that I use with sdf feature sources and the code throws no error in
> >> >>> debug mode. The "UpdateFeatures"-Methode seems to work but when
> >> looking
> >> >>> into the SQL Server table there is no entry and therefore no object
> >> on
> >> >>> the map. When logging SQL-Statements with SQL Profiler no activities
> >> >>> were logged.
> >> >>>
> >> >>> Only thing that works is deleting an existing map from the
> >> >>> featuresource. So maybe it has to do something with the
> >> >>> coordinatesystem? But as far as I understand the geometry-column of
> >> my
> >> >>> databasetable doesn't need a coordinatesystem assigned!
> >> >>>
> >> >>> Someone who had same problem? Any ideas?
> >> >>>
> >> >>> Thanks, Gunter
> >> >>>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >> --
> >> View this message in context:
> >>
> http://n2.nabble.com/Add-features-to-SQL-Server-Spatial-tp3878130p3896621.html
> >> Sent from the MapGuide Users mailing list archive at Nabble.com.
> >> _______________________________________________
> >> mapguide-users mailing list
> >> mapguide-users at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >>
> >
> >
> >
> > --
> > Zac Spitzer -
> > http://zacster.blogspot.com
> > +61 405 847 168
> >
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> >
>
> --
> View this message in context:
> http://n2.nabble.com/Add-features-to-SQL-Server-Spatial-tp3878130p3897516.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer -
http://zacster.blogspot.com
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20091027/bfc64cb7/attachment.html