Document Actions
extMDB 1.1
Up to Product page
For additional information about this project, please visit the
project page.
Available downloads
Release Notes
| State | Final release |
|---|---|
| License | GPL |
| Released | 2009/05/02 |
extMDB is an extension for gvSIG Desktop for accessing data stored by Intergraph GeoMedia® in MS Access (MDB) format, easily loading geometries and related data by using the well-known "Add layer" interface available in gvSIG.
Prerequisites:
- Windows operating system (not tested on Vista)
- Linux operating system (tested on Ubuntu)
- gvSIG 1.9 alpha or better
Install
The correct version of gvSIG must be installed on the PC. The installation steps are:
- download the installer from the project's website;
- execute the installer double-clicking on it (if the installer is a .jar file, it could be necessary to type in the command prompt:
java -jar [path_to]extMDB-1.1-install.jar, where[path_to]is the path to the installer - e.g.,c:\download\-).
If the installation process doesn't automatically find the folder where the correct version of the gvSIG application is installed, it has to be manually indicated. For instance, in the case of gvSIG 1.9 alpha on Windows XP, the folder could be C:\Program Files\gvSIG_1.9_alpha or on Linux it could be /home/[user]/gvSIG_1.9_alpha where [user] is the user's name.
Uninstall
To uninstall extMDB, remove the folder [path_to_gvSIG_1.9_alpha]\bin\gvSIG\extensiones\com.iver.cit.gvsig.mdb where [path_to_gvSIG_1.9_alpha] is the path to the root folder of gvSIG (see above). If during the installation process the 'FMap' library has been updated, it's possible to revert it to the unmodified copy deleting 'fmap.jar' in the folder [path_to_gvSIG_1.9_alpha]\bin\gvSIG\extensiones\com.iver.cit.gvsig\lib and renaming 'fmapyyyymmddhhmm.backup' to 'fmap.jar', where 'yyyymmddhhmm' is the date and time of the installation (if the case of multiple 'fmapyyyymmddhhmm.backup' files, rename the oldest file).
Usage:
- open the gvSIG's "Add layer" window
- select the 'MDB' tab among the layer's data sources
- select the GeoMedia® Warehouse to open clicking on the 'Search' button
- choose the suitables coordinate systems for the Feature Classes to import clicking on the '...' button (one or more Feature Class must be selected), otherwise the coordinate system of the current view is automatically set
- select the Feature Class(es) to import (the unsupported Feature Classes are marked in pale red)
- confirm clicking on the 'Ok' button to start the conversion
Limitations:
- the data access is limited to read-only mode
- 'Text' and 'Image' (raster) types are not supported
- 'Arc' and 'Rectangle' geometries are not supported
- GeometryCollections composed by heterogeneous geometry types are not supported
Change log
Major improvements
- Linux support through the Jackcess library (http://jackcess.sourceforge.net) licensed under the GNU Lesser General Public License
Bugs and minor improvements
- Removed a bug in 'SQLException' detection (now with 'getSQLState()' rather than 'getErrorCode()')
- No more direct closing of a 'ResultSet' (to avoid closing an already closed 'ResultSet') when it derives from a 'Statement' (closing a 'Statement' also closes the 'ResultSet')
- Each SQL statement is now executed individually, due to some instabilities in Linux when auto-commit mode is disabled (possibly, data could be inconsistent if the Access database is updated when extMDB reads it)
- Added support for conversion of 'DECIMAL', 'BOOLEAN' and 'FLOAT' SQL types
- Corrected the wrong interaction with the GUI by the SwingWorker thread in the 'MDBProgress' class for some components
- When a Feature Class can't be imported, a warning for the user has been added to check if the related data table is attached to the Access database (unsupported mode in Linux)
- Now, when opening a new Warehouse, the Feature Class table in the wizard is previously cleared
- Removed a bug that allowed to set the projection also to Feature Classes with a 'none' geometry type
- Support to different horizontal storage units along the X and Y axis