Jody Garnett wrote: > Noticed SQLiteJDBC uses native libraries to get decent > performance...supports windows, mac, linux and falls back to pure java > implementation (the same one you had trouble with before) when on a > different platform.
The pure java version a different driver than was used before. That one was javasqlite: http://www.ch-werner.de/javasqlite/ The sqlitejdbc actually ships with precompiled native libraries inside of the jar which is nice because it means you dont' have to worry about setting the java.library.path. But it should never actually fall into pure java mode since it has the native libs internally. Actually the author is thinking of killing the pure java mode. http://groups.google.com/group/xerial/browse_thread/thread/2319560d8ff0b321?hl=en > > Jody > > On Thu, Nov 26, 2009 at 7:05 AM, Justin Deoliveira <[email protected]> > wrote: >> Hi all, >> >> Over the weekend I spent some time working toward getting the rest of >> the jdbc plugins (based on the jdbc-ng architecture) to supported >> status. This includes: >> >> * sqlserver >> * mysql >> * spatialite >> >> The blockers for sqlserver and mysql where not utilizing any spatial >> indexing which made them sort of useless. And spatialite was a work in >> progress fighting with the jdbc driver for it. >> >> But i am happy to report that filter to sql encoders have been >> implemented for sql server and mysql so they now will utilize a spatial >> index. >> >> I am also happy to report that I found a much better jdbc driver for >> sqlite (http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC) and it is now >> working quite well. It also utilizes an sql encoder that makes use of >> spatial indexes. All jdbc test cases pass (with some exceptions to due >> to non transaction isolation) on both mac and linux. >> >> So I would like to move these three modules to supported status unless >> anyone objects. >> >> Comments? >> >> -- >> Justin Deoliveira >> OpenGeo - http://opengeo.org >> Enterprise support for open source geospatial. >> >> ------------------------------------------------------------------------------ >> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day >> trial. Simplify your report design, integration and deployment - and focus on >> what you do best, core application coding. Discover what's new with >> Crystal Reports now. http://p.sf.net/sfu/bobj-july >> _______________________________________________ >> Geotools-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial. ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
