Add features to SQL Server Spatial

[Gunter Becker]

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

[Gunter Becker]

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 (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

[Rodolfo Moreno]

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 (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

[Jamo]

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 (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

[zspitzer]

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 <[hidden email]> 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[Gunter Becker]

The advantage of using FDO via the MapGuide API is that you just have to write the code one time and then it should work far all feature sources regardless of datastore (database or file based).
Yes, I would be able to use SQL Scripts but I try to avoid using them. If I dont't find the solution to my problem or find out that it is a bug in mapguide code then I will use SQL Scripts.

Thanks, Gunter

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 (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

[Gunter Becker]

I don't think that you just can write to sdf feature sources. Maybe you mean the creation of datastores.
SDF is the only datastore you can create with mapguide API.

Thanks, Gunter

Jamo 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 (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

[Gunter Becker]

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 <[e-mail]> 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
> [e-mail]
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



--
Zac Spitzer -
http://zacster.blogspot.com
[phone]

_______________________________________________
mapguide-users mailing list
[e-mail]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

[zspitzer]

it's a nasty bug huh?

On Tue, Oct 27, 2009 at 7:09 PM, Gunter Becker <[hidden email]> 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 <[hidden email]>
> 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
>> [hidden email]
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>
>
>
> --
> Zac Spitzer -
> http://zacster.blogspot.com
> [phone]
>
> _______________________________________________
> mapguide-users mailing list
> [hidden email]
> 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users

--
Zac Spitzer -
http://zacster.blogspot.com
[phone]

_______________________________________________
mapguide-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/mapguide-users