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
On Mon, Sep 2, 2013 at 1:13 AM, Rini Angreani <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
> 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
