Pivotal GemFire® Native Client v9.0

Windows Installation

This topic describes how to install the SQLite Persistence Manager on Windows for use with the Geode native client.

The Geode Native Client has been tested with SQLite v3.7.14.1.

The product-dir directory refers to the native client product directory path.

The following libraries are required. The product-dir/bin directory containing these libraries must be present in the Windows PATH environment variable, and that directory is added to PATH during the Geode product installation.

  • The sqliteimpl.dll and GemStone.GemFire.Plugins.SQLite.dll files are provided in product-dir/bin.
  • For .NET C# native client application development, you need to obtain the System.Data.SQLite.dll SQLite library, as described below. The library can be copied to product-dir/bin.
  • For C++ native client application development, you need the SqLite3.dll SQLite Library. You create this library and make it available in the runtime linking path, or copied to product-dir/bin, as described below.

Downloading Pre-built System.Data.SQLite.dll Binaries

If you are writing native client applications using the .NET caching API, obtain the SQLite library (version 3.12.2 or later) for Windows as follows:

  1. Access the System.Data.SQLite Download Page at the following URL:
  2. Download the appropriate setup file for your .NET Framework installation and hardware architecture.

    • For 64-bit Windows, under Precompiled Binaries for 64-bit Windows (.NET Framework 4.5.1) download
  3. Execute the setup .exe file, and follow the prompts in the installation wizard. Accept all default installation options.

  4. Copy the C:\Program Files\System.Data.SQLite\2010\bin\System.Data.SQLite.dll file to your Geode Native Client distribution at product-dir\bin.

Downloading, Building, and Installing the Library

If you are writing native client applications using the C++ caching API, you need to build the SQLite solution for your Windows platform architecture.

  1. Download the source code sqlite-autoconf-NNNNNNN.tar.gz file (where NNNNNNN corresponds to the version) for SQLite version 3.12.2 or later from
  2. Extract the source code from the .tar.gz file. You may need to use CygWin or a Windows-compatible tar extraction tool.
  3. Using Visual Studio, build the version-specific SqLite solution either as a release or debug build:

    • If you are using 64-bit Windows, use the x64 configuration.
  4. From the built files, copy the SqLite3.dll file to your Geode Native Client distribution at product-dir/bin.