SQL Client


The In-Grid SQL Query driver can be used with existing visualization tools to gain insight into the data grid by using the specific tool provided features like drag and drop.

Examples:

SquirreL

1. Download and install SquirreL

2. Start SquirreL

3. Go to Drivers vertical tab on the left and click + button to add a new driver.

image

4. Go to Aliases vertical tab on the left and click + button to add a new connection.

image

5. Connect to the data grid

image

6. Run query, e.g. SELECT * FROM Product;

image

Currently there is a problem with RMI Classloader + Squirell, so as a workaround we copy our driver to the SquirreL lib folder. On Mac, copy jar as following: cp ./xap-calcite/target/gigaspaces-xap-jdbc-1.12.0-SNAPSHOT.jar /Applications/SQuirreLSQL.app/Contents/Resources/Java/lib.


sqlline

Make sure you have Space deployed with some data and is accessible.

1. Download sqlline

2. cd ./xap-calcite/

3. ./sqlline

4. To connect to the space:

!connect jdbc:xap:url=jini://*/*/space?locators=127.0.0.1 Enter credentials if your space is secured (or just press Return otherwise).

5. To list available tables:

!tables

6. Execute any query, e.g.

SELECT * FROM Product;

7. To close sqlline:

!quit