[mapguide-users] Can't create layer using MySQL feature source

[Stefan Dalakov]

Hi Manel,
Here is a layerDefinition that works for me.
Have you specified Coordinate-System-Overrides ?

Stefan Dalakov

<?xml version="1.0" encoding="UTF-8" ?>
- <#> <LayerDefinition 
xmlns:xsi="*http://www.w3.org/2001/XMLSchema-instance*" 
xsi:noNamespaceSchemaLocation="*LayerDefinition-1.1.0.xsd*" 
version="*1.1.0*">
- <#> <VectorLayerDefinition>
  <ResourceId>Library://mysql_ds.FeatureSource</ResourceId>
  <FeatureName>Fdotechnop_mg:links</FeatureName>
  <FeatureNameType>FeatureClass</FeatureNameType>
- <#> <PropertyMapping>
  <Name>LAYER</Name>
  <Value>LAYER</Value>
  </PropertyMapping>
- <#> <PropertyMapping>
  <Name>LENGTH</Name>
  <Value>LENGTH</Value>
  </PropertyMapping>
  <Geometry>ogc_geom</Geometry>
- <#> <VectorScaleRange>
- <#> <PointTypeStyle>
  <DisplayAsText>false</DisplayAsText>
  <AllowOverpost>false</AllowOverpost>
- <#> <PointRule>
  <LegendLabel />
  </PointRule>
  </PointTypeStyle>
- <#> <LineTypeStyle>
- <#> <LineRule>
  <LegendLabel>'Main Pipe'</LegendLabel>
  <Filter>"LAYER" = 'Main Pipe'</Filter>
- <#> <LineSymbolization2D>
  <LineStyle>Solid</LineStyle>
  <Thickness>2</Thickness>
  <Color>FF000000</Color>
  <Unit>Points</Unit>
  <SizeContext>DeviceUnits</SizeContext>
  </LineSymbolization2D>
  </LineRule>
- <#> <LineRule>
  <LegendLabel>'Pipeline'</LegendLabel>
  <Filter>"LAYER" = 'Pipeline'</Filter>
- <#> <LineSymbolization2D>
  <LineStyle>Solid</LineStyle>
  <Thickness>2</Thickness>
  <Color>FF000080</Color>
  <Unit>Points</Unit>
  <SizeContext>DeviceUnits</SizeContext>
  </LineSymbolization2D>
  </LineRule>
- <#> <LineRule>
  <LegendLabel />
- <#> <LineSymbolization2D>
  <LineStyle>Solid</LineStyle>
  <Thickness>0.0</Thickness>
  <Color>ff000000</Color>
  <Unit>Centimeters</Unit>
  <SizeContext>DeviceUnits</SizeContext>
  </LineSymbolization2D>
  </LineRule>
  </LineTypeStyle>
- <#> <AreaTypeStyle>
- <#> <AreaRule>
  <LegendLabel />
- <#> <AreaSymbolization2D>
- <#> <Fill>
  <FillPattern>Solid</FillPattern>
  <ForegroundColor>ffffffff</ForegroundColor>
  <BackgroundColor>ff000000</BackgroundColor>
  </Fill>
- <#> <Stroke>
  <LineStyle>Solid</LineStyle>
  <Thickness>0.0</Thickness>
  <Color>ff000000</Color>
  <Unit>Centimeters</Unit>
  <SizeContext>DeviceUnits</SizeContext>
  </Stroke>
  </AreaSymbolization2D>
  </AreaRule>
  </AreaTypeStyle>
  </VectorScaleRange>
  </VectorLayerDefinition>
  </LayerDefinition>


Manel Gimeno wrote:
> Hi all,
>  
> I've created a MySQL FeatureSource in Mapguide 2.0 using Mapguide 
> Maestro 1.0.9.15910. When I click in the test connection button no 
> error is reported, so it seems the connection to MySQL works fine.
>  
> When I try to create a FeatureLayer using the MySQL FeatureSource 
> previously defined the following error happens after selecting the 
> FeatureSource as resource:
>  
> "Failed to read schema from data source.
> The operation gave the error message: Error en el servidor remoto: 
> (559) MgConnectionFailedException.:
> Cannot establish connection.
> Exception occurred in method 
> MgServerDescribeSchema::ExecuteDescribeSchema() at line 173 in file 
> d:\buildforgeprojects\mapguide_open_source_v2.0\build_23.8\mgdev\server\src\services\feature\ServerDescribeSchema.cpp"
>  
> Can anyone help me to solve this problem? (Maybe if you have an 
> example of XML LayerDefinition using a MySQL FeatureSource...)
>  
> Thanks in advance
> Manel Gimeno
> ------------------------------------------------------------------------
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090406/84ed599f/attachment.html