Hello GeoServer User-List,
I’m currently trying to use a Geomedia-database (which is a .mdb-file) in an OGR Datastore. I followed the instructions and used the JNI-files from this link: http://comments.gmane.org/gmane.comp.gis.geoserver.user/34379
I was able to set up an OGR DataStore and to publish my layer in GeoServer 2.2. But as soon as I’m doing a layer preview on this layer, I get the following error in Tomcat console:
„[Microsoft][ODBC Microsoft Access Driver] Syntax error in query. Incomplete query clause“
The „OGR Geomedia driver“ uses an ODBC-Connection to read the information from the mdb-file (http://www.gdal.org/ogr/drv_geomedia.html).
„ogr2ogr“ and „ogrinfo“ works fine on this Geomedia-database when used from the command line (not in OGR DataStore).
I did an ODBC Trace to see at which position the request stops. The ODBC request breaks at the following statement: “SELECT FID FROM ‘Stadt’ \ 0”
(‚Stadt‘ is the name of my layer).
So it seems that the layer is missing the fid.
I‘ve located the position of this request in the ‚OGRFeatureSource.java‘ in the getLayerSql()-function.
Do you have any idea what I could do to get the Geomedia-database running?
Any help would be highly appreciated!
Best regards
Paul
P.S.: Using the OGR DataStore with a shape file works fine
Hello,
unfortunately it seems, that nobody can help me.
Could you please tell me how I can compile the OGRDataStore, in order to use
it in GeoServer?
I will try to fix it by myself.
Best regards
Paul
--
View this message in context: http://osgeo-org.1560.n6.nabble.com/OGR-DataStore-using-Geomedia-tp5033667p5035094.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
On Tue, Feb 19, 2013 at 10:37 AM, PBI <paul.biskup@anonymised.com> wrote:
Hello,
unfortunately it seems, that nobody can help me.
Could you please tell me how I can compile the OGRDataStore, in order to use
it in GeoServer?
I will try to fix it by myself.
The ogr data store is in GeoTools, unsupported land:
https://github.com/geotools/geotools/tree/master/modules/unsupported/ogr
You’ll have to pick up the proper branch depending on the version of GeoServer you’re using:
master (2.4.x) → master (10.x)
2.3.x → 9.x
2.2.x → 8.x
2.1.x → 2.7.x
Cheers
Andrea
–
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
Thank you,
I’ll give it a try.
Regards
Paul
Von: andrea.aime@anonymised.com [mailto:andrea.aime@anonymised.com…84…] Im Auftrag von Andrea Aime
Gesendet: Dienstag, 19. Februar 2013 11:07
An: Biskup, Paul
Cc: geoserver-users@lists.sourceforge.net
Betreff: Re: [Geoserver-users] OGR DataStore using Geomedia
On Tue, Feb 19, 2013 at 10:37 AM, PBI <paul.biskup@anonymised.com…4943…> wrote:
Hello,
unfortunately it seems, that nobody can help me.
Could you please tell me how I can compile the OGRDataStore, in order to use
it in GeoServer?
I will try to fix it by myself.
The ogr data store is in GeoTools, unsupported land:
https://github.com/geotools/geotools/tree/master/modules/unsupported/ogr
You’ll have to pick up the proper branch depending on the version of GeoServer you’re using:
master (2.4.x) → master (10.x)
2.3.x → 9.x
2.2.x → 8.x
2.1.x → 2.7.x
Cheers
Andrea
–
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.
==
Ing. Andrea Aime
@geowolf
Technical Lead
GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549
http://www.geo-solutions.it
http://twitter.com/geosolutions_it