Hi John,
This looks like a bug when idExpression is not specified:
https://jira.codehaus.org/browse/GEOT-4554.
While I'm fixing the bug, you can use a workaround by specifying idExpression
to your database id column.
http://docs.geoserver.org/latest/en/user/data/app-schema/mapping-file.html#idexpression-optional
Cheers
Rini
From: John Callahan [mailto:john.calla...@udel.edu]
Sent: Monday, 2 September 2013 2:24 PM
To: Angreani, Rini (CESRE, Kensington)
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] OpenLayers with App-Schemas
I have the same problem as Christy. The bug fix you reference looks promising.
As FYI., from looking in the geoserver log file, I see the following error:
2013-09-02 01:48:30,367 DEBUG [geotools.jdbc] - CREATE CONNECTION
2013-09-02 01:48:30,367 TRACE [geotools.core] - ENTRY 4
2013-09-02 01:48:30,367 DEBUG [geotools.filter] - exporting PropertyName
2013-09-02 01:48:30,367 DEBUG [geotools.filter] - exporting LiteralExpression
2013-09-02 01:48:30,367 DEBUG [geotools.jdbc] - SELECT
"public"."geosci_geolunitview100k"."identifier",encode(ST_AsEWKB("public"."geosci_geolunitview100k"."geom"),'base64')
as "geom" FROM "public"."geosci_geolunitview100k" INNER JOIN ( SELECT DISTINCT
FROM "public"."geosci_geolunitview100k" WHERE "geom" &&
ST_GeomFromText('POLYGON ((135058.6446566685 -28179.470173503414,
135058.6446566685 282487.40294382145, 265105.24270579155 282487.40294382145,
265105.24270579155 -28179.470173503414, 135058.6446566685
-28179.470173503414))', 26957) ) "temp_alias_used_for_filter" ON ( )
2013-09-02 01:48:30,382 DEBUG [geotools.jdbc] - CLOSE CONNECTION
2013-09-02 01:48:30,382 ERROR [geotools.rendering] - java.io.IOException
java.lang.RuntimeException: java.io.IOException
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:168)
......
......
... 116 more
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near
"FROM"
Position: 206
I confirm this error by executing the SQL SELECT statement directly to postgis.
Coordinate ordering seems fine and the exact same data table works well
through a non-app-schema based service.
- John
John Callahan
Research Scientist
Delaware Geological Survey
University of Delaware
http://www.dgs.udel.edu
john.calla...@udel.edu<mailto:john.calla...@udel.edu>
On Mon, Sep 2, 2013 at 1:13 AM, Rini Angreani
<rini.angre...@csiro.au<mailto:rini.angre...@csiro.au>> wrote:
Hi Christy,
Apart from Ben's suggestions, I also made a very recent bug fix relating to
WMS with app-schema: https://jira.codehaus.org/browse/GEOT-4550.
Please try the latest from trunk if you're not already using it.
Cheers
Rini
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/OpenLayers-with-App-Schemas-tp5075263p5075509.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users