SQLite Xerial JDBC From Source

Windows

Setup

• Install Cygwin from here [1], During the install include these additional libraries:
  • make
  • curl
  • unzip
  • mingw64-x86_64-gcc-core (Optional: win64 native library recompile)
• Install Mercurial HG, available here [2]
• Install Java SDK 1.5+, available here [3]
  • Add java/bin to PATH
  • On Command line, type java -version to check
• Install Maven 3.0.2+, available here [4]
  • add maven/bin to PATH
  • On Command line, type mvn -version to check

Steps

• Clone the Xerial repo, type:
  • hg clone https://sqlite-jdbc.googlecode.com/hg/ sqlite-jdbc
• Go into repo folder, type:
  • cd sqlite-jdbc
• Start the build, type:
  • make
• Retrieve the newly built, compiled and tested jar at:
  • sqlite-jdbc/target/sqlite-jdbc-3.7.*.jar
  • Alternatively one is available here [5]

SQLite addtions

• For a full list of compilation options see here [6]
• To add compilation options to sqlite:
  • Edit Makefile in the repo root starting at Ln. 58

SQLite Extensions

• To add extensions to sqlite at compile time:
  • Edit Makefile in the repo root starting and append -L./ -lyourDllName.dll at Ln.67
• To add extensions to sqlite at cmd line:
  • select load_extension("yourQuotedDllName.dll");
  • .load yourQuotedDllName.dll
• To add extensions through the NexJ framework:
  • m_appender.appendSQL("select load_extension('yourQuotedDllName.dll')");