> > What did you use as a Spatialite JDBC connection? Is this pure Java, or > JNI? >
I think there are at least two JDBC drivers for SQLite/Spatialite. I use the Zentus driver with the Jump DB Query Plugin, but I think Jukka has had success with the Xerial drivers. The Zentus documentation is a little confusing regarding whether or not it's pure java, since it says the driver is pure java, but it also says the jar contains "both the pure driver and the native binaries". To me, it feels like a pure java solution because I didn't have to set any paths to DLLs/so's. > H2 I think also is more flexible than Sqlite - e.g. in-memory databases, > etc. But Sqlite is certainly getting deployed in a LOT of large > projects, so its longevity seems assured. I also prefer pure-java to mixed java/binary, but SQLite apparently has a large and growing mindshare. For instance, the latest version of ogr/gdal supports pushing spatial data directly into a SQLite database. I tend to view SQLite like I view other databases, as an external resource, and not something you would want to embed in an app. From that point of view, interoperability is good enough. -lreeder ------------------------------------------------------------------------------ The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose flexible plans and management services without long-term contracts Personal 24x7 support from experience hosting pros just a phone call away. http://p.sf.net/sfu/theplanet-com _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
