Hi Ragnvald,
2014-02-10 23:10 GMT+01:00 Ragnvald Larsen <[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 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
