[Geotools-devel] [jira] (GEOT-4567) Using string constants in app-schema idExpression causes error

[Rini Angreani (JIRA)]

Rini Angreani created GEOT-4567 Using string constants in app-schema idExpression causes error Issue Type: Bug Affects Versions: 9.3 Assignee: Rini Angreani Components: app-schema plugin Created: 12/Sep/13 9:08 PM Description: Florence's report: ================== Running NVCL ScannedBoreholeCollection feature getting error related to this issue, instead of using getId(), it is using a constant in the mapping as below : <AttributeMapping> <targetAttribute>nvcl:ScannedBoreholeCollection</targetAttribute> <idExpression> <OCQL>'nvcl.scannedboreholecollection.1'</OCQL> </idExpression> </AttributeMapping> Error message : java.lang.UnsupportedOperationException: idExpression 'nvcl.scannedboreholecollection.1' for targetElement 'nvcl:ScannedBoreholeCollection' cannot be translated into SQL, therefore is not supported with joining! Please make sure idExpression is mapped into existing database fields, and only use functions that are supported by your database. If this cannot be helped, you can turn off joining in app-schema.properties file. idExpression 'nvcl.scannedboreholecollection.1' for targetElement 'nvcl:ScannedBoreholeCollection' cannot be translated into SQL, therefore is not supported with joining! Please make sure idExpression is mapped into existing database fields, and only use functions that are supported by your database. If this cannot be helped, you can turn off joining in app-schema.properties file. Workaround at the moment is to use strConcat: <OCQL>strConcat('nvcl.scannedboreholecollection.',DATASET_ID)</OCQL> Fix Versions: 10.0 Project: GeoTools Priority: 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

------------------------------------------------------------------------------
How ServiceNow helps IT people transform IT departments:
1. Consolidate legacy IT systems to a single system of record for IT
2. Standardize and globalize service processes across IT
3. Implement zero-touch automation to replace manual, redundant tasks
http://pubads.g.doubleclick.net/gampad/clk?id=51271111&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel