Hi all, I am working on adding OGR support to GeoScript and noticed that reading SQLite databases currently fails because SQLite doesn't support FID. So I get the following error:
ERROR 1: In ExecuteSQL(): sqlite3_prepare(SELECT FID, * FROM 'points' ): no such column: FID because of this line of code: https://github.com/geotools/geotools/blob/master/modules/unsupported/ogr/ogr-core/src/main/java/org/geotools/data/ogr/OGRFeatureSource.java#L308 Now the OGR C API has a function called OGR_L_GetFIDColumn that we could use to get the FID column for a Layer or an empty string if its not supported but FID is also used for sorting. https://github.com/geotools/geotools/blob/master/modules/unsupported/ogr/ogr-core/src/main/java/org/geotools/data/ogr/OGRFeatureSource.java#L333 I am not sure what to do about the FID usage for sorting if the OGR_L_GetFIDColumn call returns an empty string. Thanks, Jared ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk _______________________________________________ GeoTools-GT2-Users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
