Difference between revisions of "SQLite Xerial JDBC From Source"
Cwdesautels (talk | contribs) (→Windows) |
|||
(29 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | == | + | {{Admon/obsolete}} |
− | === | + | |
− | * Install Cygwin from here[http://cygwin.com/], | + | [[Category: NexJ_Express_SQLite]] |
+ | == Windows == | ||
+ | === Setup === | ||
+ | * Install Cygwin from here [http://cygwin.com/], During the install include these additional libraries: | ||
+ | ** make | ||
** curl | ** curl | ||
** unzip | ** unzip | ||
** mingw64-x86_64-gcc-core (Optional: win64 native library recompile) | ** 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 == | == 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 \'' | ||
− | == | + | == 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')");'' |
Latest revision as of 21:48, 26 January 2014
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 with the SOUNDEX option enabled [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
- Example: -DSQLITE_SOUNDEX=1 \
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')");