Thanks Jody.

Here is the pull request for this one.

https://github.com/geotools/geotools/pull/362


On Mon, Feb 10, 2014 at 10:03 PM, Jody Garnett <[email protected]>wrote:

> Sounds like a great plan Justin, I especially like change of jdbc
> connection parameters.
>
> Jody
>
> Jody Garnett
>
>
> On Tue, Feb 11, 2014 at 3:41 PM, Justin Deoliveira <
> [email protected]> wrote:
>
>> Hi all,
>>
>> Currently for the jdbc-spatialite module we depend on a patched version
>> of the the xerial sqlite-jdbc driver:
>>
>>   https://bitbucket.org/xerial/sqlite-jdbc
>>   https://bitbucket.org/jdeolive/sqlite-jdbc
>>
>> The reason we use a patched driver is so that we can compile spatialite
>> into the sqlite shared library that the jdbc driver uses.
>>
>> One runs into problems when trying to use the patched driver in an
>> environment where the unpatched driver is also used. For instance, trying
>> to use the mbtiles or geopackage modules in a project with the
>> spatialite-jdbc module. It is a toss up as to which one is loaded first.
>> And if it turns out to be the unpatched version the spatialite module
>> ceases to function.
>>
>> So, to remedy this i would like apply another patch to the sqlite-jdbc
>> that actually changes a few things to avoid conflicts with the unpatched
>> version.
>>
>> 1. The jdbc driver class name
>> 2. The jdbc prefix used for connection strings
>>
>> For example:
>>
>> org.sqlite.JDBC -> org.spatialite.JDBC
>> jdbc:sqlite:foo.db -> jdbc:spatialite:foo.db
>>
>> The plan is to use a different maven artifact id for the new patched
>> version, as to not negatively impact projects depending on the current
>> version.
>>
>> Once the new driver artifact is in place here is the required patch:
>>
>>   https://gist.github.com/anonymous/f7aa78e4c9ae0bf6edd0
>>
>> In terms of backward compatibility code that uses connection parameters
>> will continue to function without any change. Only code that loads the jdbc
>> driver directly would be affected.
>>
>> Thoughts?
>>
>> -Justin
>>
>> --
>> *Justin Deoliveira*
>> Vice President, Engineering | Boundless
>> [email protected]
>> @j_deolive <https://twitter.com/j_deolive>
>>
>>
>> ------------------------------------------------------------------------------
>> Android apps run on BlackBerry 10
>> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
>> Now with support for Jelly Bean, Bluetooth, Mapview and more.
>> Get your Android app in front of a whole new audience.  Start now.
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> GeoTools-Devel mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>>
>>
>


-- 
*Justin Deoliveira*
Vice President, Engineering | Boundless
[email protected]
@j_deolive <https://twitter.com/j_deolive>
------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to