Changes

Jump to: navigation, search

SQLite Xerial JDBC From Source

1,367 bytes added, 22:48, 26 January 2014
no edit summary
{{Admon/obsolete}}
 
[[Category: NexJ_Express_SQLite]]
== Windows ==
=== Setup ===
* Install Cygwin from here [http://cygwin.com/], 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 [http://mercurial.selenic.com/]
* Install Java SDK 1.5+, available here [http://java.sun.com]
** Add java/bin to PATH
** On Command line, type java -version to check
* Install Maven 3.0.2+, available here [http://maven.apache.org]
** add maven/bin to PATH
** On Command line, type mvn -version to check
 
== Steps ==
=== Windows ===* Clone the Xerial repo, type:1. Install Cygwin from here [http** ''hg clone https://cygwinsqlite-jdbc.googlecode.com/]hg/ sqlite-jdbc''* Go into repo folder, During type:** ''cd sqlite-jdbc''* Start the install include these additional librariesbuild, type:* curl* ''make''*Retrieve the newly built, compiled and tested jar at:* unzip* mingw64''sqlite-x86_64jdbc/target/sqlite-gccjdbc-core (Optional: win64 native library recompile)23. Install Mercurial HG, available here [http://mercurial7.selenic*.com/]jar''3. Install Java SDK 1.5+, ** Alternatively one is available here with the SOUNDEX option enabled [http://javawww.sunmediafire.com/?0y3s5eyoor0ked6== SQLite Addtions ==* Add java/bin to PATH4. Install Maven 3.0.2+, available For a full list of compilation options see here [http://mavenwww.apachesqlite.org/compile.html]* To add maven/bin compilation options to PATHsqlite:** Edit ''Makefile'' in the repo root starting at Ln. 58** Example: ''-DSQLITE_SOUNDEX=1 \''
== Result SQLite Extensions ==* Any dll loaded through xerial must match your systems current platform and architecture, eg: win-x64* To add extensions to sqlite at compile time: '''!!!HAS NOT WORKED YET!!!'''** 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')");''

Navigation menu