Problem solved - or at least avoided. Two ways potentially leads to the
glorious access to MSSQL spatial based layers. Both starts with the user
choosing "Add a new resource", after that I choose the relevant data store from
the drop down list. Next is one of these two:
1) "Configure new SQL view..."
2) Press "Publish"
The last option (2) opens the layer definition dialogue and shows "Reload
feature type ...". The first one (1) starts with letting me write a SQL query.
This one works.
I am running geoserver on a windows computer with "JVM Version: Oracle
Corporation: 1.7.0_17 (Java HotSpot(TM) 64-Bit Server VM)".
I suspect this is a windows only issue.
Bug filed in JIRA: http://jira.codehaus.org/browse/GEOS-6342
Ragnvald
Fra: Jody Garnett [mailto:[email protected]]
Sendt: 10. februar 2014 13:33
Til: Ragnvald Larsen
Kopi: [email protected]
Emne: Re: [Geoserver-users] Problems with sqL
Check the logs for a stack trace, perhaps it can provide a clue. Usually the
only way to confuse a database setup is by not filling in the correct metadata
/ spatial index / spatial reference system information. GeoServer makes use of
these kind of details when determining the feature type.
Jody Garnett
On Sun, Feb 9, 2014 at 4:11 AM, Ragnvald Larsen
<[email protected]<mailto:[email protected]>> wrote:
I am importing a set of polygons to MSSQL spatial but continuously get "Reload
feature
type<http://geoserver3:8080/geoserver/web/?wicket:bookmarkablePage=:org.geoserver.web.data.resource.ResourceConfigurationPage&name=inon_objekter&wsName=dn>
...<http://geoserver3:8080/geoserver/web/?wicket:bookmarkablePage=:org.geoserver.web.data.resource.ResourceConfigurationPage&name=inon_objekter&wsName=dn>"
when set up the layer. I am expecting "Edit sql
view<http://geoserver3:8080/geoserver/web/?wicket:interface=:19:resource:tabs:panel:theList:1:content:attributePanel:editSqlContainer:editSql::ILinkListener::>"
* Using Geoserver: 2.4.4
* SQL Server 10.50.400
Spatial preview on SQL server works fine. I have tried importing from both ESRI
FILE Geod and shapefiles. Same issue.
Any suggestions? Common pitfalls?
Ragnvald
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience. Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
