Issue while connecting Ignite grid with SQL client

classic Classic list List threaded Threaded
2 messages Options
vijayendra bhati vijayendra bhati
Reply | Threaded
Open this post in threaded view
|

Issue while connecting Ignite grid with SQL client

Hi,

I am trying to connect to Ignite data grid using Squirrel using URL - 
jdbc:ignite:cfg://D://apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml

ignite-jdbc-own-created-config.xml looks like below - 

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
        http://www.springframework.org/schema/beans
        http://www.springframework.org/schema/beans/spring-beans.xsd">
    <bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
<property name="cacheConfiguration">
            <list>
                <!-- Partitioned cache example configuration (Atomic mode). -->
                <bean class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="atomicityMode" value="ATOMIC"/> 
<property name="cacheMode" value="PARTITIONED"/>
                    <property name="backups" value="1"/>
<property name="statisticsEnabled" value="false" />
                </bean>
            </list>
        </property>
        <property name="clientMode" value="true"/>

        <property name="peerClassLoadingEnabled" value="true"/>

        <!-- Configure TCP discovery SPI to provide list of initial nodes. -->
        <property name="discoverySpi">
            <bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
                <property name="ipFinder">
                    <bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast.TcpDiscoveryMulticastIpFinder"/>
                </property>
            </bean>
        </property>
    </bean>
</beans>


I am getting below exception, can anybody please help me understand what could be the issue - 

Caused by: java.sql.SQLException: Failed to start Ignite node.
at org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:152)
at org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:350)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to instantiate Spring XML application context [springUrl=file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml, err=Error creating bean with name 'ignite.cfg' defined in URL [file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml]: Cannot create inner bean 'org.apache.ignite.configuration.CacheConfiguration#3c51b85d' of type [org.apache.ignite.configuration.CacheConfiguration] while setting bean property 'cacheConfiguration' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.ignite.configuration.CacheConfiguration#3c51b85d' defined in URL [file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml]: Initialization of bean failed;
 nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type [java.lang.String] to required type [org.apache.ignite.cache.CacheAtomicityMode] for property 'atomicityMode'; nested exception is java.lang.IllegalArgumentException: Method must not be null]
at org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:391)

Regards,
Vij

Vladimir Ozerov Vladimir Ozerov
Reply | Threaded
Open this post in threaded view
|

Re: Issue while connecting Ignite grid with SQL client

Hi Vij,

Very weird exception. May be a kind of subtle typo or so. Please try copy-pasting the following string and see if it helps:

<property name="atomicityMode" value="ATOMIC"/>

Vladimir.

On Mon, Apr 18, 2016 at 10:19 AM, vijayendra bhati <[hidden email]> wrote:
Hi,

I am trying to connect to Ignite data grid using Squirrel using URL - 
jdbc:ignite:cfg://D://apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml

ignite-jdbc-own-created-config.xml looks like below - 

       xsi:schemaLocation="
    <bean id="ignite.cfg" class="org.apache.ignite.configuration.IgniteConfiguration">
<property name="cacheConfiguration">
            <list>
                <!-- Partitioned cache example configuration (Atomic mode). -->
                <bean class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="atomicityMode" value="ATOMIC"/> 
<property name="cacheMode" value="PARTITIONED"/>
                    <property name="backups" value="1"/>
<property name="statisticsEnabled" value="false" />
                </bean>
            </list>
        </property>
        <property name="clientMode" value="true"/>

        <property name="peerClassLoadingEnabled" value="true"/>

        <!-- Configure TCP discovery SPI to provide list of initial nodes. -->
        <property name="discoverySpi">
            <bean class="org.apache.ignite.spi.discovery.tcp.TcpDiscoverySpi">
                <property name="ipFinder">
                    <bean class="org.apache.ignite.spi.discovery.tcp.ipfinder.multicast.TcpDiscoveryMulticastIpFinder"/>
                </property>
            </bean>
        </property>
    </bean>
</beans>


I am getting below exception, can anybody please help me understand what could be the issue - 

Caused by: java.sql.SQLException: Failed to start Ignite node.
at org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:152)
at org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:350)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 7 more
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to instantiate Spring XML application context [springUrl=file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml, err=Error creating bean with name 'ignite.cfg' defined in URL [file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml]: Cannot create inner bean 'org.apache.ignite.configuration.CacheConfiguration#3c51b85d' of type [org.apache.ignite.configuration.CacheConfiguration] while setting bean property 'cacheConfiguration' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.ignite.configuration.CacheConfiguration#3c51b85d' defined in URL [file:/D:/apache-ignite-fabric-1.5.0.final-bin/config/ignite-jdbc-own-created-config.xml]: Initialization of bean failed;
 nested exception is org.springframework.beans.TypeMismatchException: Failed to convert property value of type [java.lang.String] to required type [org.apache.ignite.cache.CacheAtomicityMode] for property 'atomicityMode'; nested exception is java.lang.IllegalArgumentException: Method must not be null]
at org.apache.ignite.internal.util.spring.IgniteSpringHelperImpl.applicationContext(IgniteSpringHelperImpl.java:391)

Regards,
Vij