Thankyou Mauro and Andrea - your explanations of the issue made me see it
clearer!
I have changed the issue in JIRA to a possible improvement in documentation or
the user interface :) Given time I might even submit a suggestion to update of
the documentation.
Ragnvald
Fra: [email protected] [mailto:[email protected]] På vegne
av Mauro Bartolomeoli
Sendt: 11. februar 2014 08:56
Til: Ragnvald Larsen
Kopi: [email protected]
Emne: Re: [Geoserver-users] Problems with sqL
Hi Ragnvald,
2014-02-10 23:10 GMT+01:00 Ragnvald Larsen
<[email protected]<mailto:[email protected]>>:
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
I think there is a misunderstanding here: the option 1 and 2 are quite
different in scope: the "Configure new SQL view" allows you to publish a
"virtual table" from your database built using a sql query, while the second
one is used to publish an existing database table "as is", so also the
configuration UI is different for the layers built using one of the two methods.
With the first one you get an "Edit SQL View" link that allows you to define
the sql for the virtual table, for the second one you cannot define a sql
query, you only get a "Reload feature type..." that simply reads the table
fields and properties from the database and synchronizes the internal cache.
So, as it is usually said: "it's not a bug, it's a feature" :-).
Cheers,
Mauro Bartolomeoli
--
==
Our support, Your Success! Visit
http://opensdi.geo-solutions.it<http://opensdi.geo-solutions.it/> for more
information.
==
Dott. Mauro Bartolomeoli
@mauro_bart
Senior Software Engineer
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
-------------------------------------------------------
------------------------------------------------------------------------------
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
