Skip to main content

Posts

Showing posts with the label service grid

Apache Ignite - Examples on Data grid, compute grid, service grid and executing SQL queries

In this article, we will show few examples on using Apache Ignite as Compute Grid, Data Grid, Service Grid and executing SQL queries on Apache Ignite. These are basic examples and use the basic api available. There will be few posts in near future which explains the available API in Compute Grid, Service Grid and Data Grid. Ignite SQL Example Apache Ignite comes with JDBC Thin driver support to execute SQL queries on the In memory data grid. In the example below, we will create tables, insert data into tables and get data from tables. I will assume that you are running Apache Ignite on your local environment otherwise please read setup guide for running Apache Ignite server. Creating Tables try (Connection conn = DriverManager.getConnection("jdbc:ignite:thin://127.0.0.1/"); Statement stmt = conn.createStatement();) { //line 1 stmt.executeUpdate("CREATE TABLE City (id LONG PRIMARY KEY, name VARCHAR) WITH \"template=replicated\"");