[Geotools-devel] [jira] (GEOT-4390) Missing expression in Oracle with app-schema joining

[Ben Caradoc-Davies (JIRA)]

Ben Caradoc-Davies created GEOT-4390 Missing _expression_ in Oracle with app-schema joining Issue Type: Bug Affects Versions: 8.6 Assignee: Rini Angreani Components: app-schema plugin Created: 11/Feb/13 8:45 PM Description: Report referred to "GeoServer 2.2" so I am guessing a recent 8.x. Not tested against master. Original thread here: http://osgeo-org.1560.n6.nabble.com/WFS-Performance-Issues-in-GeoTools-with-App-schema-Module-td5032333.html This report comes further on: -------- Original Message -------- Subject: Re: [Geotools-gt2-users] WFS Performance Issues in GeoTools with App-schema Module Date: Fri, 8 Feb 2013 10:22:30 +0800 From: Mike Beaumont To: geotools-gt2-us...@lists.sourceforge.net I don't expect anyone to answer the following in this thread but for the record, I set app-schema.joining = true and the following SQL was generated which led to an Oracle Exception *ORA-00936: missing _expression_* due to some of the inner join clauses having empty brackets where the specified join columns should go. I'll have to dig deeper into the code and/or config. But it is interesting that the requests work fine without joining (it's just that it's slow) but not at all with joining=true. Here's the SQL: SELECT SG_GSML_LITHOLOGY.ID, SG_GSML_LITHOLOGY.COMPOSITIONPART_ID, SG_GSML_LITHOLOGY.LITHOLOGY, SG_GSML_LITHOLOGY.LITHOLOGY_URI, SG_GSML_LITHOLOGY.LITHOLOGY_URN, SG_GSML_COMPOSITIONPART.ID FOREIGN_ID_0_0, SG_GSML_GEOLOGICUNIT.GML_ID FOREIGN_ID_1_0, SG_GSML_MAPPEDFEATURE_250K.GML_ID FOREIGN_ID_2_0 FROM SG_GSML_LITHOLOGY INNER JOIN SG_GSML_COMPOSITIONPART ON ( SG_GSML_COMPOSITIONPART.ID = SG_GSML_LITHOLOGY.COMPOSITIONPART_ID) INNER JOIN SG_GSML_COMPOSITIONPART SG_GSML_COMPOSITIONP_1 ON ( ) INNER JOIN SG_GSML_GEOLOGICUNIT ON ( SG_GSML_GEOLOGICUNIT.ID = SG_GSML_COMPOSITIONP_1.GEOGRAPHICFEATURE_ID) INNER JOIN SG_GSML_GEOLOGICUNIT SG_GSML_GEOLOGICUNIT_1 ON ( ) INNER JOIN SG_GSML_MAPPEDFEATURE_250K ON ( SG_GSML_MAPPEDFEATURE_250K.GEOGRAPHICFEATURE_ID = SG_GSML_GEOLOGICUNIT_1.ID) INNER JOIN ( SELECT DISTINCT GML_ID FROM SG_GSML_MAPPEDFEATURE_250K WHERE GML_ID = gsml.mappedfeature.geologicunit.250k-10000005 ) temp_alias_used_for_filter ON ( SG_GSML_MAPPEDFEATURE_250K.GML_ID = TEMP_ALIAS_USED_FOR_FILTER.GML_ID ) ORDER BY SG_GSML_MAPPEDFEATURE_250K.GML_ID ASC, SG_GSML_GEOLOGICUNIT.GML_ID ASC, CASE WHEN SG_GSML_MAPPEDFEATURE_250K.GEOGRAPHICFEATURE_ID = SG_GSML_GEOLOGICUNIT.ID THEN 0 ELSE 1 END ASC, SG_GSML_COMPOSITIONPART.ID ASC, CASE WHEN SG_GSML_GEOLOGICUNIT.ID = SG_GSML_COMPOSITIONPART.GEOGRAPHICFEATURE_ID THEN 0 ELSE 1 END ASC Project: GeoTools Priority: Major Reporter: Ben Caradoc-Davies

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

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel