![]() |
|
|
|
|
Issue Type:
|
![Bug]() Bug
|
|
Affects Versions:
|
10-RC1 |
|
Assignee:
|
Rini Angreani
|
|
Components:
|
app-schema plugin |
|
Created:
|
02/Sep/13 9:55 PM
|
|
Description:
|
I think this may be introduced by app-schema sortby.
John Callahan's email:
=======================
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
|
|
Fix Versions:
|
10-RC2 |
|
Project:
|
GeoTools
|
|
Priority:
|
![Major]() Major
|
|
Reporter:
|
Rini Angreani
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
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
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
