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/