Difference between revisions of "SQLite Xerial JDBC From Source"
Cwdesautels (talk | contribs) (→SQLite Extensions) |
|||
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{Admon/obsolete}} | ||
| + | |||
| + | [[Category: NexJ_Express_SQLite]] | ||
== Windows == | == Windows == | ||
=== Setup === | === Setup === | ||
| Line 23: | Line 26: | ||
* Retrieve the newly built, compiled and tested jar at: | * Retrieve the newly built, compiled and tested jar at: | ||
** ''sqlite-jdbc/target/sqlite-jdbc-3.7.*.jar'' | ** ''sqlite-jdbc/target/sqlite-jdbc-3.7.*.jar'' | ||
| + | ** Alternatively one is available here with the SOUNDEX option enabled [http://www.mediafire.com/?0y3s5eyoor0ked6] | ||
| − | == SQLite | + | == SQLite Addtions == |
* For a full list of compilation options see here [http://www.sqlite.org/compile.html] | * For a full list of compilation options see here [http://www.sqlite.org/compile.html] | ||
* To add compilation options to sqlite: | * To add compilation options to sqlite: | ||
** Edit ''Makefile'' in the repo root starting at Ln. 58 | ** Edit ''Makefile'' in the repo root starting at Ln. 58 | ||
| + | ** Example: ''-DSQLITE_SOUNDEX=1 \'' | ||
== SQLite Extensions == | == SQLite Extensions == | ||
| − | * To add extensions to sqlite at compile time: | + | * Any dll loaded through xerial must match your systems current platform and architecture, eg: win-x64 |
| − | ** append ''-L./ -lyourDllName.dll'' at Ln.67 | + | * 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: | * To add extensions to sqlite at cmd line: | ||
** ''select load_extension("yourQuotedDllName.dll");'' | ** ''select load_extension("yourQuotedDllName.dll");'' | ||
** ''.load yourQuotedDllName.dll'' | ** ''.load yourQuotedDllName.dll'' | ||
| − | * To add extensions through the NexJ framework: | + | * To add extensions through the NexJ framework: |
** ''m_appender.appendSQL("select load_extension('yourQuotedDllName.dll')");'' | ** ''m_appender.appendSQL("select load_extension('yourQuotedDllName.dll')");'' | ||
Latest revision as of 21:48, 26 January 2014
This page may be obsolete.
It contains historical information.
It contains historical information.
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')");
