I am developing the application with open layers 3 and geoserver for serving WMS layers. The Layers are published from Microsoft SQL server in geoserver.
In MSSQL server, there are two databases, First database consists of all the spatial and non spatial tables and views which used by some other web application to view and edit the attribute data of each spatial assets.
The second database can contain some spatial tables(layers) which can be directly published from geoserver, but there are some views which has created from the first database. So that if there is any updation for assets has been done in the that web application it will affect the attributes of views in the second database.
I am using the second database for my application. I can easily publish the tables which has uploaded directly from shape file to MSSQL Server. But the problem is while publishing the views in the geoserver throws an exception
The geometry_columns table in second database(which I am using) has stored the geometry column name as ogr_geometry but views has the geomerty column name as SP_GEOMETRY.. Is this the problem?? if so how to over come it.
or how to publish this MSSQL Server views using geoserver 2.7.2?
أكثر...
In MSSQL server, there are two databases, First database consists of all the spatial and non spatial tables and views which used by some other web application to view and edit the attribute data of each spatial assets.
The second database can contain some spatial tables(layers) which can be directly published from geoserver, but there are some views which has created from the first database. So that if there is any updation for assets has been done in the that web application it will affect the attributes of views in the second database.
I am using the second database for my application. I can easily publish the tables which has uploaded directly from shape file to MSSQL Server. But the problem is while publishing the views in the geoserver throws an exception
The geometry_columns table in second database(which I am using) has stored the geometry column name as ogr_geometry but views has the geomerty column name as SP_GEOMETRY.. Is this the problem?? if so how to over come it.
or how to publish this MSSQL Server views using geoserver 2.7.2?
أكثر...