Hi,
While testing the new 0.8.1 version of DB Query Plugin I noticed that I could
not read any multigeometries nor geometry collections from Spatialite. Further
research revealed that with a bit older OpenJUMP versions there are no troubles
at all with these geometries. For example OJ r3131 from 2012-12-12 works fine
for me.
The error with recent OJ versions is "Unknown WKB type 0".
running query: select * from multipolygons
Warning: Unable to find FDO-OGR metadata: [SQLITE_ERROR] SQL error or missing
database (no such col
umn: geometry_format). I'll take this as an indication that this database
doesn't conform to FDO RF
C 16, but is just a regular spatialite (or sqlite) database
java.sql.SQLException: Unknown WKB type 0
at
org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialiteDbQuery.getAttributeValueFrom
Results(JumpSpatialiteDbQuery.java:455)
at
org.freevoice.jumpdbqueryextension.AbstractJumpDbQuery.addFeatureToCollection(AbstractJum
pDbQuery.java:132)
at
org.freevoice.jumpdbqueryextension.spatialite.JumpSpatialiteDbQuery.getCollection(JumpSpa
tialiteDbQuery.java:404)
at
org.freevoice.jumpdbqueryextension.JumpDbQueryPlugin.run(JumpDbQueryPlugin.java:169)
at java.lang.Thread.run(Unknown Source)
I made a little test Spatialite v.3 database which contains points,
linestrings, multilinestrings, polygons, multipolygons and geometry collections
with 10 features on each layer to test with
http://latuviitta.org/documents/Geometry_type_test.sqlite
If I could I would have a look at changeset 3137: update jts library to 1.13
-Jukka Rahkonen
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
