You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by warorc <wa...@ngs.ru> on 2016/09/06 09:06:52 UTC

Simple connect to gridgain via java for taken data

Hello, everyone.

I need simple task. Somewhere our developers which use gridgain.

I try to test that data correct inserted to this gridgain stacks. So I just
want to connect to this node, which I don't know anything and get data from
that.

I tried to do it by jdbc:driver, but seen that such method is deprecated in
version 1.7.0, so I started doing it as written in docs via spring and xml
file. But now I can't connected to gridgains nodes with strange error.  I
lost 2 days and can't resove this problem.

My xml:
<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="visor"
class="org.apache.ignite.plugin.security.SecurityCredentials">
        <constructor-arg value="visor"/>
        <constructor-arg value="q12345678"/>
    </bean>
    
    <bean id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">
        
        <property name="clientMode" value="true"/>

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

        
        <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>10.116.146.201</value>
                                                              
<value>10.116.146.202</value>
                            </list>                                                     
                               </property>
                    </bean>
                               </property>  
                    </bean>
        </property>
        <property name="pluginConfigurations">
            <list>
                <bean
class="org.gridgain.grid.configuration.GridGainConfiguration">
                    <property value="true" name="rollingUpdatesEnabled"/>
                    <property name="securityCredentialsProvider">
                        <bean
class="org.apache.ignite.plugin.security.SecurityCredentialsBasicProvider">
                            <constructor-arg ref="visor"/>
                        </bean>
                    </property>
                </bean>
            </list>
        </property>
    </bean>
</beans>

Exception:

SEVERE: Failed to start manager: GridManagerAdapter [enabled=true,
name=o.a.i.i.managers.discovery.GridDiscoveryManager]
class org.apache.ignite.IgniteCheckedException: Remote node has cache
affinity assignment mode different from local [locId8=3c48b04b,
locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.checkAttributes(GridDiscoveryManager.java:1124)
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(GridDiscoveryManager.java:701)
                at
org.apache.ignite.internal.IgniteKernal.startManager(IgniteKernal.java:1571)
                at
org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1739)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)
                at
org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
                at org.apache.ignite.Ignition.start(Ignition.java:322)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.getIgnite(JdbcConnection.java:190)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:151)
                at
org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
                at
java.sql.DriverManager.getConnection(DriverManager.java:664)
                at
java.sql.DriverManager.getConnection(DriverManager.java:270)
                at ru.sbt.qa.pu.Main.main(Main.java:39)

сен 06, 2016 3:07:55 PM org.apache.ignite.logger.java.JavaLogger error
SEVERE: Got exception while starting (will rollback startup routine).
class org.apache.ignite.IgniteCheckedException: Failed to start manager:
GridManagerAdapter [enabled=true,
name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
                at
org.apache.ignite.internal.IgniteKernal.startManager(IgniteKernal.java:1576)
                at
org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1739)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)
                at
org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
                at org.apache.ignite.Ignition.start(Ignition.java:322)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.getIgnite(JdbcConnection.java:190)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:151)
                at
org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
                at
java.sql.DriverManager.getConnection(DriverManager.java:664)
                at
java.sql.DriverManager.getConnection(DriverManager.java:270)
                at ru.sbt.qa.pu.Main.main(Main.java:39)
Caused by: class org.apache.ignite.IgniteCheckedException: Remote node has
cache affinity assignment mode different from local [locId8=3c48b04b,
locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.checkAttributes(GridDiscoveryManager.java:1124)
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(GridDiscoveryManager.java:701)
                at
org.apache.ignite.internal.IgniteKernal.startManager(IgniteKernal.java:1571)
                ... 13 more

[15:07:56] Ignite node stopped OK
[name=ignite-jdbc-driver-35559313-f8a2-4a36-b914-194022fcf9b1,
uptime=00:00:06:227]
Exception in thread "main" java.sql.SQLException: Failed to start Ignite
node.
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:162)
                at
org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
                at
java.sql.DriverManager.getConnection(DriverManager.java:664)
                at
java.sql.DriverManager.getConnection(DriverManager.java:270)
                at ru.sbt.qa.pu.Main.main(Main.java:39)
Caused by: class org.apache.ignite.IgniteCheckedException: Failed to start
manager: GridManagerAdapter [enabled=true,
name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
                at
org.apache.ignite.internal.IgniteKernal.startManager(IgniteKernal.java:1576)
                at
org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:1739)
                at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1589)
                at
org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
                at
org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
                at org.apache.ignite.Ignition.start(Ignition.java:322)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.getIgnite(JdbcConnection.java:190)
                at
org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(JdbcConnection.java:151)
                ... 4 more
Caused by: class org.apache.ignite.IgniteCheckedException: Remote node has
cache affinity assignment mode different from local [locId8=3c48b04b,
locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.checkAttributes(GridDiscoveryManager.java:1124)
                at
org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(GridDiscoveryManager.java:701)
                at
org.apache.ignite.internal.IgniteKernal.startManager(IgniteKernal.java:1571)
                ... 13 more

How I can in simple way via java just connect to caches and get information
from them?




--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-for-taken-data-tp7539.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Simple connect to gridgain via java for taken data

Posted by Vladislav Pyatkov <vl...@gmail.com>.
In general, Ignite supports compatibility for minor versions, but do not
for new major release.

You can use REST API for the purpose [1].
If you want to configure REST, all you need to do, add dependency to
ignite-rest-http on server side.

[1]: https://apacheignite.readme.io/docs/rest-api

On Tue, Sep 6, 2016 at 1:03 PM, warorc <wa...@ngs.ru> wrote:

> Hi, thank you for your answer!
>
> The problem that I don't know which version use developers. And when they
> will change version to new one, I still don't be known what version they
> use. I can't afford update version every time when developers change their.
>
> So I asked about alternative simple way connecting to gridgain nodes
> without
> starting client node on test machine and doesn't depend on gridgain
> version?
>
>
> vdpyatkov wrote
> > Hi,
> >
> > Are you sure to use same Ignite version on server and client, where are
> > you
> > using Ignite JDBC connection?
> > The message:
> > *Remote node has cache affinity assignment mode different from local*
> > look like you apply different configuration on client and on server.
> >
> > Also, you can access to date using jcache API through Ignite client node
> > [1,2].
> > [1]: https://apacheignite.readme.io/docs/clients-vs-servers
> > [2]: https://apacheignite.readme.io/docs/jcache
> >
> > On Tue, Sep 6, 2016 at 12:06 PM, warorc &lt;
>
> > warorc@
>
> > &gt; wrote:
> >
> >> Hello, everyone.
> >>
> >> I need simple task. Somewhere our developers which use gridgain.
> >>
> >> I try to test that data correct inserted to this gridgain stacks. So I
> >> just
> >> want to connect to this node, which I don't know anything and get data
> >> from
> >> that.
> >>
> >> I tried to do it by jdbc:driver, but seen that such method is deprecated
> >> in
> >> version 1.7.0, so I started doing it as written in docs via spring and
> >> xml
> >> file. But now I can't connected to gridgains nodes with strange error.
> I
> >> lost 2 days and can't resove this problem.
> >>
> >> My xml:
> >>
> > <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="visor"
> >>
> >  class="org.apache.ignite.plugin.security.SecurityCredentials">
> >>
> > <constructor-arg value="visor"/>
> >>
> > <constructor-arg value="q12345678"/>
> >>
> > </bean>
> >>
> >>
> > <bean id="ignite.cfg"
> >>
> >  class="org.apache.ignite.configuration.IgniteConfiguration">
> >>
> >>
> > <property name="clientMode" value="true"/>
> >>
> >>
> > <property name="peerClassLoadingEnabled" value="true"/>
> >>
> >>
> >>
> > <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>
> > 10.116.146.201
> > </value>
> >>
> >>
> > <value>
> > 10.116.146.202
> > </value>
> >>
> > </list>
> >>
> > </property>
> >>
> > </bean>
> >>
> > </property>
> >>
> > </bean>
> >>
> > </property>
> >>
> > <property name="pluginConfigurations">
> >>
> > <list>
> >>
> > <bean
> >>
> >  class="org.gridgain.grid.configuration.GridGainConfiguration">
> >>
> > <property value="true" name="rollingUpdatesEnabled"/>
> >>
> > <property name="securityCredentialsProvider">
> >>
> > <bean
> >>
> >  class="org.apache.ignite.plugin.security.SecurityCredentialsBasicProvid
> >> er">
> >>
> > <constructor-arg ref="visor"/>
> >>
> > </bean>
> >>
> > </property>
> >>
> > </bean>
> >>
> > </list>
> >>
> > </property>
> >>
> > </bean>
> >>
> > </beans>
> >>
> >> Exception:
> >>
> >> SEVERE: Failed to start manager: GridManagerAdapter [enabled=true,
> >> name=o.a.i.i.managers.discovery.GridDiscoveryManager]
> >> class org.apache.ignite.IgniteCheckedException: Remote node has cache
> >> affinity assignment mode different from local [locId8=3c48b04b,
> >> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> >> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> >> checkAttributes(GridDiscoveryManager.java:1124)
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.
> GridDiscoveryManager.start(
> >> GridDiscoveryManager.java:701)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.startManager(
> >> IgniteKernal.java:1571)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> >> IgnitionEx.java:1739)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> >> IgnitionEx.java:1589)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
> >>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> >> getIgnite(JdbcConnection.java:190)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> > <init>
> > (
> >> JdbcConnection.java:151)
> >>                 at
> >> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:664)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:270)
> >>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
> >>
> >> сен 06, 2016 3:07:55 PM org.apache.ignite.logger.java.JavaLogger error
> >> SEVERE: Got exception while starting (will rollback startup routine).
> >> class org.apache.ignite.IgniteCheckedException: Failed to start
> manager:
> >> GridManagerAdapter [enabled=true,
> >> name=org.apache.ignite.internal.managers.discovery.
> GridDiscoveryManager]
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.startManager(
> >> IgniteKernal.java:1576)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> >> IgnitionEx.java:1739)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> >> IgnitionEx.java:1589)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
> >>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> >> getIgnite(JdbcConnection.java:190)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> > <init>
> > (
> >> JdbcConnection.java:151)
> >>                 at
> >> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:664)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:270)
> >>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
> >> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node
> >> has
> >> cache affinity assignment mode different from local [locId8=3c48b04b,
> >> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> >> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> >> checkAttributes(GridDiscoveryManager.java:1124)
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.
> GridDiscoveryManager.start(
> >> GridDiscoveryManager.java:701)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.startManager(
> >> IgniteKernal.java:1571)
> >>                 ... 13 more
> >>
> >> [15:07:56] Ignite node stopped OK
> >> [name=ignite-jdbc-driver-35559313-f8a2-4a36-b914-194022fcf9b1,
> >> uptime=00:00:06:227]
> >> Exception in thread "main" java.sql.SQLException: Failed to start Ignite
> >> node.
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> > <init>
> > (
> >> JdbcConnection.java:162)
> >>                 at
> >> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:664)
> >>                 at
> >> java.sql.DriverManager.getConnection(DriverManager.java:270)
> >>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
> >> Caused by: class org.apache.ignite.IgniteCheckedException: Failed to
> >> start
> >> manager: GridManagerAdapter [enabled=true,
> >> name=org.apache.ignite.internal.managers.discovery.
> GridDiscoveryManager]
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.startManager(
> >> IgniteKernal.java:1576)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> >> IgnitionEx.java:1739)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> >> IgnitionEx.java:1589)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
> >>                 at
> >> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
> >>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> >> getIgnite(JdbcConnection.java:190)
> >>                 at
> >> org.apache.ignite.internal.jdbc2.JdbcConnection.
> > <init>
> > (
> >> JdbcConnection.java:151)
> >>                 ... 4 more
> >> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node
> >> has
> >> cache affinity assignment mode different from local [locId8=3c48b04b,
> >> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> >> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> >> checkAttributes(GridDiscoveryManager.java:1124)
> >>                 at
> >> org.apache.ignite.internal.managers.discovery.
> GridDiscoveryManager.start(
> >> GridDiscoveryManager.java:701)
> >>                 at
> >> org.apache.ignite.internal.IgniteKernal.startManager(
> >> IgniteKernal.java:1571)
> >>                 ... 13 more
> >>
> >> How I can in simple way via java just connect to caches and get
> >> information
> >> from them?
> >>
> >>
> >>
> >>
> >> --
> >> View this message in context: http://apache-ignite-users.
> >> 70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-
> >> for-taken-data-tp7539.html
> >> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
> >>
> >
> >
> >
> > --
> > Vladislav Pyatkov
>
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-
> for-taken-data-tp7539p7545.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov

Re: Simple connect to gridgain via java for taken data

Posted by warorc <wa...@ngs.ru>.
Hi, thank you for your answer!

The problem that I don't know which version use developers. And when they
will change version to new one, I still don't be known what version they
use. I can't afford update version every time when developers change their. 

So I asked about alternative simple way connecting to gridgain nodes without
starting client node on test machine and doesn't depend on gridgain version?


vdpyatkov wrote
> Hi,
> 
> Are you sure to use same Ignite version on server and client, where are
> you
> using Ignite JDBC connection?
> The message:
> *Remote node has cache affinity assignment mode different from local*
> look like you apply different configuration on client and on server.
> 
> Also, you can access to date using jcache API through Ignite client node
> [1,2].
> [1]: https://apacheignite.readme.io/docs/clients-vs-servers
> [2]: https://apacheignite.readme.io/docs/jcache
> 
> On Tue, Sep 6, 2016 at 12:06 PM, warorc &lt;

> warorc@

> &gt; wrote:
> 
>> Hello, everyone.
>>
>> I need simple task. Somewhere our developers which use gridgain.
>>
>> I try to test that data correct inserted to this gridgain stacks. So I
>> just
>> want to connect to this node, which I don't know anything and get data
>> from
>> that.
>>
>> I tried to do it by jdbc:driver, but seen that such method is deprecated
>> in
>> version 1.7.0, so I started doing it as written in docs via spring and
>> xml
>> file. But now I can't connected to gridgains nodes with strange error.  I
>> lost 2 days and can't resove this problem.
>>
>> My xml:
>> 
> <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="visor"
>>
>  class="org.apache.ignite.plugin.security.SecurityCredentials">
>>         
> <constructor-arg value="visor"/>
>>         
> <constructor-arg value="q12345678"/>
>>     
> </bean>
>>
>>     
> <bean id="ignite.cfg"
>>
>  class="org.apache.ignite.configuration.IgniteConfiguration">
>>
>>         
> <property name="clientMode" value="true"/>
>>
>>         
> <property name="peerClassLoadingEnabled" value="true"/>
>>
>>
>>         
> <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>
> 10.116.146.201
> </value>
>>
>> 
> <value>
> 10.116.146.202
> </value>
>>                             
> </list>
>>                                
> </property>
>>                     
> </bean>
>>                                
> </property>
>>                     
> </bean>
>>         
> </property>
>>         
> <property name="pluginConfigurations">
>>             
> <list>
>>                 
> <bean
>>
>  class="org.gridgain.grid.configuration.GridGainConfiguration">
>>                     
> <property value="true" name="rollingUpdatesEnabled"/>
>>                     
> <property name="securityCredentialsProvider">
>>                         
> <bean
>>
>  class="org.apache.ignite.plugin.security.SecurityCredentialsBasicProvid
>> er">
>>                             
> <constructor-arg ref="visor"/>
>>                         
> </bean>
>>                     
> </property>
>>                 
> </bean>
>>             
> </list>
>>         
> </property>
>>     
> </bean>
>> 
> </beans>
>>
>> Exception:
>>
>> SEVERE: Failed to start manager: GridManagerAdapter [enabled=true,
>> name=o.a.i.i.managers.discovery.GridDiscoveryManager]
>> class org.apache.ignite.IgniteCheckedException: Remote node has cache
>> affinity assignment mode different from local [locId8=3c48b04b,
>> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
>> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
>> checkAttributes(GridDiscoveryManager.java:1124)
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
>> GridDiscoveryManager.java:701)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.startManager(
>> IgniteKernal.java:1571)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
>> IgnitionEx.java:1739)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
>> IgnitionEx.java:1589)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
>> getIgnite(JdbcConnection.java:190)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
> <init>
> (
>> JdbcConnection.java:151)
>>                 at
>> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:664)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:270)
>>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
>>
>> сен 06, 2016 3:07:55 PM org.apache.ignite.logger.java.JavaLogger error
>> SEVERE: Got exception while starting (will rollback startup routine).
>> class org.apache.ignite.IgniteCheckedException: Failed to start manager:
>> GridManagerAdapter [enabled=true,
>> name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
>>                 at
>> org.apache.ignite.internal.IgniteKernal.startManager(
>> IgniteKernal.java:1576)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
>> IgnitionEx.java:1739)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
>> IgnitionEx.java:1589)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
>> getIgnite(JdbcConnection.java:190)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
> <init>
> (
>> JdbcConnection.java:151)
>>                 at
>> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:664)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:270)
>>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
>> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node
>> has
>> cache affinity assignment mode different from local [locId8=3c48b04b,
>> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
>> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
>> checkAttributes(GridDiscoveryManager.java:1124)
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
>> GridDiscoveryManager.java:701)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.startManager(
>> IgniteKernal.java:1571)
>>                 ... 13 more
>>
>> [15:07:56] Ignite node stopped OK
>> [name=ignite-jdbc-driver-35559313-f8a2-4a36-b914-194022fcf9b1,
>> uptime=00:00:06:227]
>> Exception in thread "main" java.sql.SQLException: Failed to start Ignite
>> node.
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
> <init>
> (
>> JdbcConnection.java:162)
>>                 at
>> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:664)
>>                 at
>> java.sql.DriverManager.getConnection(DriverManager.java:270)
>>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
>> Caused by: class org.apache.ignite.IgniteCheckedException: Failed to
>> start
>> manager: GridManagerAdapter [enabled=true,
>> name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
>>                 at
>> org.apache.ignite.internal.IgniteKernal.startManager(
>> IgniteKernal.java:1576)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
>> IgnitionEx.java:1739)
>>                 at
>> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
>> IgnitionEx.java:1589)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>>                 at
>> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
>> getIgnite(JdbcConnection.java:190)
>>                 at
>> org.apache.ignite.internal.jdbc2.JdbcConnection.
> <init>
> (
>> JdbcConnection.java:151)
>>                 ... 4 more
>> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node
>> has
>> cache affinity assignment mode different from local [locId8=3c48b04b,
>> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
>> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
>> checkAttributes(GridDiscoveryManager.java:1124)
>>                 at
>> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
>> GridDiscoveryManager.java:701)
>>                 at
>> org.apache.ignite.internal.IgniteKernal.startManager(
>> IgniteKernal.java:1571)
>>                 ... 13 more
>>
>> How I can in simple way via java just connect to caches and get
>> information
>> from them?
>>
>>
>>
>>
>> --
>> View this message in context: http://apache-ignite-users.
>> 70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-
>> for-taken-data-tp7539.html
>> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>>
> 
> 
> 
> -- 
> Vladislav Pyatkov





--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-for-taken-data-tp7539p7545.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Re: Simple connect to gridgain via java for taken data

Posted by Vladislav Pyatkov <vl...@gmail.com>.
Hi,

Are you sure to use same Ignite version on server and client, where are you
using Ignite JDBC connection?
The message:
*Remote node has cache affinity assignment mode different from local*
look like you apply different configuration on client and on server.

Also, you can access to date using jcache API through Ignite client node
[1,2].
[1]: https://apacheignite.readme.io/docs/clients-vs-servers
[2]: https://apacheignite.readme.io/docs/jcache

On Tue, Sep 6, 2016 at 12:06 PM, warorc <wa...@ngs.ru> wrote:

> Hello, everyone.
>
> I need simple task. Somewhere our developers which use gridgain.
>
> I try to test that data correct inserted to this gridgain stacks. So I just
> want to connect to this node, which I don't know anything and get data from
> that.
>
> I tried to do it by jdbc:driver, but seen that such method is deprecated in
> version 1.7.0, so I started doing it as written in docs via spring and xml
> file. But now I can't connected to gridgains nodes with strange error.  I
> lost 2 days and can't resove this problem.
>
> My xml:
> <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="visor"
> class="org.apache.ignite.plugin.security.SecurityCredentials">
>         <constructor-arg value="visor"/>
>         <constructor-arg value="q12345678"/>
>     </bean>
>
>     <bean id="ignite.cfg"
> class="org.apache.ignite.configuration.IgniteConfiguration">
>
>         <property name="clientMode" value="true"/>
>
>         <property name="peerClassLoadingEnabled" value="true"/>
>
>
>         <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>10.116.146.201</value>
>
> <value>10.116.146.202</value>
>                             </list>
>                                </property>
>                     </bean>
>                                </property>
>                     </bean>
>         </property>
>         <property name="pluginConfigurations">
>             <list>
>                 <bean
> class="org.gridgain.grid.configuration.GridGainConfiguration">
>                     <property value="true" name="rollingUpdatesEnabled"/>
>                     <property name="securityCredentialsProvider">
>                         <bean
> class="org.apache.ignite.plugin.security.SecurityCredentialsBasicProvid
> er">
>                             <constructor-arg ref="visor"/>
>                         </bean>
>                     </property>
>                 </bean>
>             </list>
>         </property>
>     </bean>
> </beans>
>
> Exception:
>
> SEVERE: Failed to start manager: GridManagerAdapter [enabled=true,
> name=o.a.i.i.managers.discovery.GridDiscoveryManager]
> class org.apache.ignite.IgniteCheckedException: Remote node has cache
> affinity assignment mode different from local [locId8=3c48b04b,
> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> checkAttributes(GridDiscoveryManager.java:1124)
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
> GridDiscoveryManager.java:701)
>                 at
> org.apache.ignite.internal.IgniteKernal.startManager(
> IgniteKernal.java:1571)
>                 at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1739)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>                 at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.
> getIgnite(JdbcConnection.java:190)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(
> JdbcConnection.java:151)
>                 at
> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:664)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:270)
>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
>
> сен 06, 2016 3:07:55 PM org.apache.ignite.logger.java.JavaLogger error
> SEVERE: Got exception while starting (will rollback startup routine).
> class org.apache.ignite.IgniteCheckedException: Failed to start manager:
> GridManagerAdapter [enabled=true,
> name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
>                 at
> org.apache.ignite.internal.IgniteKernal.startManager(
> IgniteKernal.java:1576)
>                 at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1739)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>                 at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.
> getIgnite(JdbcConnection.java:190)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(
> JdbcConnection.java:151)
>                 at
> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:664)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:270)
>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node has
> cache affinity assignment mode different from local [locId8=3c48b04b,
> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> checkAttributes(GridDiscoveryManager.java:1124)
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
> GridDiscoveryManager.java:701)
>                 at
> org.apache.ignite.internal.IgniteKernal.startManager(
> IgniteKernal.java:1571)
>                 ... 13 more
>
> [15:07:56] Ignite node stopped OK
> [name=ignite-jdbc-driver-35559313-f8a2-4a36-b914-194022fcf9b1,
> uptime=00:00:06:227]
> Exception in thread "main" java.sql.SQLException: Failed to start Ignite
> node.
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(
> JdbcConnection.java:162)
>                 at
> org.apache.ignite.IgniteJdbcDriver.connect(IgniteJdbcDriver.java:361)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:664)
>                 at
> java.sql.DriverManager.getConnection(DriverManager.java:270)
>                 at ru.sbt.qa.pu.Main.main(Main.java:39)
> Caused by: class org.apache.ignite.IgniteCheckedException: Failed to start
> manager: GridManagerAdapter [enabled=true,
> name=org.apache.ignite.internal.managers.discovery.GridDiscoveryManager]
>                 at
> org.apache.ignite.internal.IgniteKernal.startManager(
> IgniteKernal.java:1576)
>                 at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:901)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(
> IgnitionEx.java:1739)
>                 at
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(
> IgnitionEx.java:1589)
>                 at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1042)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:569)
>                 at
> org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:516)
>                 at org.apache.ignite.Ignition.start(Ignition.java:322)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.
> getIgnite(JdbcConnection.java:190)
>                 at
> org.apache.ignite.internal.jdbc2.JdbcConnection.<init>(
> JdbcConnection.java:151)
>                 ... 4 more
> Caused by: class org.apache.ignite.IgniteCheckedException: Remote node has
> cache affinity assignment mode different from local [locId8=3c48b04b,
> locDelayAssign=true, rmtId8=4d888c0f, rmtLateAssign=false,
> rmtAddrs=[os-sbt-oaabs-006.ca.sbrf.ru/10.116.144.202, /127.0.0.1]]
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.
> checkAttributes(GridDiscoveryManager.java:1124)
>                 at
> org.apache.ignite.internal.managers.discovery.GridDiscoveryManager.start(
> GridDiscoveryManager.java:701)
>                 at
> org.apache.ignite.internal.IgniteKernal.startManager(
> IgniteKernal.java:1571)
>                 ... 13 more
>
> How I can in simple way via java just connect to caches and get information
> from them?
>
>
>
>
> --
> View this message in context: http://apache-ignite-users.
> 70518.x6.nabble.com/Simple-connect-to-gridgain-via-java-
> for-taken-data-tp7539.html
> Sent from the Apache Ignite Users mailing list archive at Nabble.com.
>



-- 
Vladislav Pyatkov