Difference between revisions of "SQLite Xerial JDBC From Source"

From CDOT Wiki
Jump to: navigation, search
(Windows)
 
(29 intermediate revisions by 2 users not shown)
Line 1: Line 1:
== Requirements ==
+
{{Admon/obsolete}}
=== Windows ===
+
 
* Install Cygwin from here[http://cygwin.com/], with these additional libraries:
+
[[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 \''
  
== 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')");''

Latest revision as of 21:48, 26 January 2014

Important.png
This page may be obsolete.
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:
  • 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')");