Hi,
you can use DBeaver open source SQL client to connect to Ignite cache.
After the installation of DBeaver from http://dbeaver.jkiss.org/download go
to
Database -> Driver Manager -> New
In the 'Settings' part fill in the requested information as follow:
<http://apache-ignite-users.70518.x6.nabble.com/file/n8366/Screen_Shot_2016-10-19_at_22.png>
Add all the above libraries shown in the screen shot.
Start your Ignite server with default-config as shown below:
" <bean id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">
<property name="clientMode" value="false"/>
<property name="peerClassLoadingEnabled" value="true"/>
<property name="cacheConfiguration">
<list>
<bean
class="org.apache.ignite.configuration.CacheConfiguration">
<property name="atomicityMode" value="ATOMIC"/>
<property name="name" value="testCache"/>
</bean>
</list>
</property>
<property name="discoverySpi">
<bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
<property name="ipFinder">
<bean
class="org.apache.ignite.spi.discovery.tcp.ipfinder.vm.TcpDiscoveryVmIpFinder">
<property name="addresses">
<list>
<value>127.0.0.1:47500..47509</value>
</list>
</property>
</bean>
</property>
</bean>
</property>
</bean>"
also copy the default-config.xml into any file such as
defaul-config-orgin.xml and set the client mode to true as follows:
<property name="clientMode" value="true"/>
test the connection. In the SQL editor panel, you can write any SELECT
statement.
P.S. You can find other interesting informations in the sample chapter from
this book <https://leanpub.com/ignite> https://leanpub.com/ignite
Regards
Shamim
--
View this message in context:
http://apache-ignite-users.70518.x6.nabble.com/GUI-based-SQL-Client-for-Apache-Ignite-tp8283p8366.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.
