[mapguide-users] Maestro: can't find the table containing the geometry field with SQLServerSpatial

[Carl]

Exactly, the returned XML based on the new version of SQLSpatialProvider
covers all tables.
But now the root node name is changed to 'fdo:DataStore', and Maestro check
that the root node name must be 'xs:schema'.  (as follows)

///////////////////////////////////
public class FeatureSourceDescription
	{
		private FeatureSourceSchema[] m_schemas;

		public FeatureSourceDescription(System.IO.Stream stream)
		{
			XmlDocument doc = new XmlDocument();
			doc.Load(stream);

			if (doc.FirstChild.Name != "xml")
				throw new Exception("Bad document");

			if (doc.ChildNodes.Count != 2 || doc.ChildNodes[1].Name != "xs:schema")
				throw new Exception("Bad document");

			XmlNamespaceManager mgr = new XmlNamespaceManager(doc.NameTable);
			mgr.AddNamespace("xs", "http://www.w3.org/2001/XMLSchema");
			mgr.AddNamespace("gml", "http://www.opengis.net/gml");
			mgr.AddNamespace("fdo", "http://fdo.osgeo.org/schemas");

            XmlNodeList lst =
doc.SelectNodes("xs:schema/xs:complexType[@abstract='false']", mgr);
			m_schemas = new FeatureSourceSchema[lst.Count];
			for(int i = 0;i<lst.Count;i++)
				m_schemas[i] = new FeatureSourceSchema(lst[i], doc, mgr);
		}
......

///////////////////

Then I changed the Maestro to fit the new version
1. Check the root node name : 'fdo:DataStore'
2. Modify the line
XmlNodeList lst =
doc.SelectNodes("xs:schema/xs:complexType[@abstract='false']", mgr);

as 

XmlNodeList lst =
doc.SelectNodes("fdo:DataStore/xs:schema/xs:complexType[@abstract='false']",
mgr);

OK. It works well. all tables are listed, and the table containing a
geometry field is shown as default.


Brent Robinson-5 wrote:
> 
> One clarification. The fix is specific to the handling of varchar(max) and
> nvarchar(max). It likely doesn't address the problem mentioned at
> http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.html
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Brent
> Robinson
> Sent: Wednesday, October 15, 2008 12:37 PM
> To: MapGuide Users Mail List
> Subject: RE: [mapguide-users] Maestro: can't find the table containing the
> geometry field with SQLServerSpatial
> 
> This is a known defect that was fixed in July. The fix provides almost
> full support for the varchar(max) and nvarchar(max) columns. There's one
> limitation: when selecting from these columns, values longer than 16000
> characters are truncated.
> 
> The FDO 3.3.2 SQLServerSpatial provider should have the fix. It can be
> obtained from the Windows SDK download at
> http://fdo.osgeo.org/content/fdo-332-downloads. You'd just need to extract
> the following DLL's:
> 
>         SQLServerSpatialProvider.dll
>         SQLServerSpatialOverrides.dll
>         OSGeo.FDO.Providers.SQLServerSpatial.Overrides.dll
> 
> to MapGuide's FDO bin directories:
> 
>         Program Files\Autodesk\MapGuideEnterprise2009\Server\Bin\FDO
>         Program Files\Autodesk\MapGuideStudio2009\FDO  (if present)
> 
> I'd recommend saving copies of your current versions of these DLL's before
> extracting, just in case.
> 
> I have MG enterprise on my machine so your directories might look a bit
> different.
> 
> If you get a chance to try this out, please let me know if it fixes the
> problem.
> 
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Carl
> Sent: Wednesday, October 15, 2008 10:28 AM
> To: mapguide-users at lists.osgeo.org
> Subject: RE: [mapguide-users] Maestro: can't find the table containing the
> geometry field with SQLServerSpatial
> 
> 
> yes
> 
> 
> Brent Robinson-5 wrote:
>>
>> Hi Carl,
>>
>> Do any of your tables have a varchar(max) column?
>>
>> Brent.
>>
>>
>>
> 
> --
> View this message in context:
> http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p19994687.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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Maestro%3A-can%27t-find-the-table-containing-the-geometry-field-with-SQLServerSpatial-tp19977173p20015751.html
Sent from the MapGuide Users mailing list archive at Nabble.com.