1,234
edits
Changes
no edit summary
{{Admon/obsolete}}
[[Category: NexJ_Express_SQLite]]
== Windows ==
=== Setup ===
** On Command line, type mvn -version to check
* Clone the Xerial repo, type:
** ''hg clone https://sqlite-jdbc.googlecode.com/hg/ 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')");''
