This part of the documentation website is obsolete. Please see the new Solution Hub.

ODBC Driver


Author XAP Version Last Updated Reference Download
Shay Hassidim 7.1 April 2010

Overview

GigaSpaces Data-Grid support standard data access API. One of them is the JDBC Driver. Using the JDBC API and ODBC-JDBC bridge such as the one comes from Open Link Software, you can use standard ODBC API to access the GigaSpaces Data-Grid.

GigaSpaces Installation

  • You can download Gigaspaces java version from http://www.gigaspaces.com/LatestProductVersion.
  • Unzip the downloaded file into a directory on your local machine. (Note: make sure the directory path does not have any spaces). This directory will be referred as in further instructions.
  • Download and install the latest version of Java JDK.
  • Set a JAVA_HOME variable to the path where you have installed the JDK.

GigaSpaces Configuration

  • Start the GigaSpaces Agent by running \bin\gs-agent.bat(bat).
  • Start the management UI by running \bin\gs-ui.sh(bat).

Create a new user

Create a new user “user” and password “password” and grant it all access privileges. See GigaSpaces Management Center Security for instructions.

Deploy a Secured Space

  • Click the “Deploy In-Memory Data Grid” button (top left, second button) in the UI.
  • In the dialog select the following properties:
DataGrid Name : mySpace
Space Schema : default
Secured Space checkbox enabled
User name : user, password: password
Cluster Schema <None>

And deploy the space.

ODBC-JDBC bridge

  • Download and install the ODBC-JDBC bridge from.
  • Set the following environment variables in your system:
PATH=<Your Java Install directory>\jre\bin\server;%PATH%
CLASSPATH=<GigaSpaces root>lib\required\commons-logging.jar;
<GigaSpaces root>\lib\required\gs-openspaces.jar;<GigaSpaces root>\lib\required\gs-runtime.jar;
<GigaSpaces root>\lib\required\spring.jar
  • Create a new OpenLink ODBC datasource with the following properties:
JDBC Driver : com.j_spaces.jdbc.driver.GDriver
URL String: jdbc:gigaspaces:url:jini://*/*/mySpace
User name  User name : user, Password: password

You can test the connection using the openlink sample application at Program Files\OpenLink Software\UDA\Samples\Odbc