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
------------------------------------------------------------------------------
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
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
