1,234
edits
Changes
no edit summary
{{Admon/obsolete}} [[Category: NexJ_Express_SQLite]]== Requirements Windows ===== 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 ==
* 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 with the SOUNDEX option enabled [http://www.mediafire.com/?0y3s5eyoor0ked6]
== SQLite Addtions ==
* For a full list of compilation options see here [http://www.sqlite.org/compile.html]
* To add compilation options to sqlite:
** 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')");''
