I think the issue was a 32 vs 64-bit mismatch. My sqlite3.dll is a 64-bit library. I just downloaded the 32-bit version of sqlite3.dll and CFFI did link to it (did not issue any errors). I will continue with testing. My reading of java -version implies that my java is 32-bit:
java.exe" -version java version "1.7.0_51" Java(TM) SE Runtime Environment (build 1.7.0_51-b13) Java HotSpot(TM) Client VM (build 24.51-b03, mixed mode, sharing)
On Mon, Apr 24, 2017 at 6:24 AM Luís Oliveira <luismbo@gmail.com> wrote:
Hello Mirko,
On Mon, Apr 24, 2017 at 4:05 AM, Mirko Vukovic <mirko.vukovic@gmail.com> wrote:
Unable to load library 'C:/Program Files/sqlite/sqlite3.dll': Native library (win32-x86/C:/Program Files/sqlite/sqlite3.dll) not found in resource path ([file:/C:/mv-program-files/abcl-bin-1.4.0/, file:/C:/mv-program-files/abcl-bin-1.4.0/abcl.jar])
Kind of looks like "C:/Program Files/sqlite/sqlite3.dll" is being interpreted as the library name rather than a path. I have a couple of random, independent ideas:
1. Replace forward slashes with backward slashes: "C:\\Program Files\\sqlite\\sqlite3.dll". 2. Place the DLL (and its dependencies) somewhere in the PATH and try (cffi:load-foreign-library "sqlite3.dll") 3. <http://stackoverflow.com/questions/25063614/jna-set-resource-path>
Hope that helps,
-- Luís Oliveira http://kerno.org/~luis/