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