You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by deostroll <de...@gmail.com> on 2018/12/12 11:01:54 UTC

Web console project cannot start an ignite server node

Hi,

I successfully imported a database from postgres to ignite via web console.
And through the web console, I noticed there is the option to download a
project. I did that, and, noticed that there was code to start ignite server
and client nodes. They executed properly and I was able to see the count of
nodes increase whenever a new node was started.

However, for some reason the server node fails to start. The program however
doesn't exit, and waits. I am sharing the program console output below. I
cannot make sense of this:



- Arun



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Web console project cannot start an ignite server node

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

2.7 is officially released so you should try that one, see if it helps with
your troubles.

Regards,
-- 
Ilya Kasnacheev


пт, 14 дек. 2018 г. в 11:33, deostroll <de...@gmail.com>:

> Okay, I was able to replicate the problem by adding a dependency of spring
> boot to my project.
>
> Below is the pom.xml file including spring boot. Now what should I do?
>
> ignite 2.7 is not officially released, right?
>
> ----BEGIN_PASTE---
> <?xml version="1.0" encoding="UTF-8"?>
>
>
>
> <project xmlns="http://maven.apache.org/POM/4.0.0"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
> http://maven.apache.org/xsd/maven-4.0.0.xsd">
>     <modelVersion>4.0.0</modelVersion>
>
>     <groupId>org.apache.ignite</groupId>
>     <artifactId>SampleCluster-project</artifactId>
>     <version>2.5.0</version>
>     <parent>
>         <groupId>org.springframework.boot</groupId>
>         <artifactId>spring-boot-starter-parent</artifactId>
>         <version>2.1.1.RELEASE</version>
>     </parent>
>     <dependencies>
>         <dependency>
>             <groupId>org.springframework.boot</groupId>
>             <artifactId>spring-boot-starter-web</artifactId>
>         </dependency>
>         <dependency>
>             <groupId>org.apache.ignite</groupId>
>             <artifactId>ignite-core</artifactId>
>             <version>2.5.0</version>
>         </dependency>
>         <dependency>
>             <groupId>org.apache.ignite</groupId>
>             <artifactId>ignite-spring</artifactId>
>             <version>2.5.0</version>
>         </dependency>
>         <dependency>
>             <groupId>org.apache.ignite</groupId>
>             <artifactId>ignite-indexing</artifactId>
>             <version>2.5.0</version>
>         </dependency>
>         <dependency>
>             <groupId>org.apache.ignite</groupId>
>             <artifactId>ignite-rest-http</artifactId>
>             <version>2.5.0</version>
>         </dependency>
>         <dependency>
>             <groupId>org.postgresql</groupId>
>             <artifactId>postgresql</artifactId>
>             <version>9.4.1212.jre7</version>
>         </dependency>
>     </dependencies>
>
>     <build>
>         <resources>
>             <resource>
>                 <directory>src/main/java</directory>
>                 <excludes>
>                     <exclude>**/*.java</exclude>
>                 </excludes>
>             </resource>
>             <resource>
>                 <directory>src/main/resources</directory>
>             </resource>
>         </resources>
>         <plugins>
>             <plugin>
>                 <artifactId>maven-dependency-plugin</artifactId>
>                 <executions>
>                     <execution>
>                         <id>copy-libs</id>
>                         <phase>test-compile</phase>
>                         <goals>
>                             <goal>copy-dependencies</goal>
>                         </goals>
>                         <configuration>
>
> <excludeGroupIds>org.apache.ignite</excludeGroupIds>
>                             <outputDirectory>target/libs</outputDirectory>
>                             <includeScope>compile</includeScope>
>                             <excludeTransitive>true</excludeTransitive>
>                         </configuration>
>                     </execution>
>                 </executions>
>             </plugin>
>             <plugin>
>                 <artifactId>maven-compiler-plugin</artifactId>
>                 <version>3.1</version>
>                 <configuration>
>                     <source>1.7</source>
>                     <target>1.7</target>
>                 </configuration>
>             </plugin>
>         </plugins>
>     </build>
> </project>
> ----END_PASTE---
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Web console project cannot start an ignite server node

Posted by deostroll <de...@gmail.com>.
Okay, I was able to replicate the problem by adding a dependency of spring
boot to my project. 

Below is the pom.xml file including spring boot. Now what should I do?

ignite 2.7 is not officially released, right?

----BEGIN_PASTE---
<?xml version="1.0" encoding="UTF-8"?>



<project xmlns="http://maven.apache.org/POM/4.0.0"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0
http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.apache.ignite</groupId>
    <artifactId>SampleCluster-project</artifactId>
    <version>2.5.0</version>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.1.RELEASE</version>
    </parent>
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.apache.ignite</groupId>
            <artifactId>ignite-core</artifactId>
            <version>2.5.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.ignite</groupId>
            <artifactId>ignite-spring</artifactId>
            <version>2.5.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.ignite</groupId>
            <artifactId>ignite-indexing</artifactId>
            <version>2.5.0</version>
        </dependency>
        <dependency>
            <groupId>org.apache.ignite</groupId>
            <artifactId>ignite-rest-http</artifactId>
            <version>2.5.0</version>
        </dependency>
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.4.1212.jre7</version>
        </dependency>
    </dependencies>

    <build>
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <excludes>
                    <exclude>**/*.java</exclude>
                </excludes>
            </resource>
            <resource>
                <directory>src/main/resources</directory>
            </resource>
        </resources>
        <plugins>
            <plugin>
                <artifactId>maven-dependency-plugin</artifactId>
                <executions>
                    <execution>
                        <id>copy-libs</id>
                        <phase>test-compile</phase>
                        <goals>
                            <goal>copy-dependencies</goal>
                        </goals>
                        <configuration>
                           
<excludeGroupIds>org.apache.ignite</excludeGroupIds>
                            <outputDirectory>target/libs</outputDirectory>
                            <includeScope>compile</includeScope>
                            <excludeTransitive>true</excludeTransitive>
                        </configuration>
                    </execution>
                </executions>
            </plugin>
            <plugin>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.1</version>
                <configuration>
                    <source>1.7</source>
                    <target>1.7</target>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>
----END_PASTE---



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Web console project cannot start an ignite server node

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello!

java.lang.NoSuchMethodError:
org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V

Where did it go? Please note that Ignite REST needs Jetty 9.2.11 and in
your classpath there is 9.4.12. If they are binary incompatible then you
should downgrade.

Alternatively, please try upgrading Ignite to 2.7 since it uses 9.4.11 and
you should be OK.

Regards,
-- 
Ilya Kasnacheev


чт, 13 дек. 2018 г. в 07:48, deostroll <de...@gmail.com>:

> Sorry my bad. I thought nabble editor should take care of this.
>
> I will share the spring config and the program output between a series of
> begin_paste and end_paste.
>
> Program output:
> ==========
>
> ---BEGIN_PASTE---
> "C:\Program Files\Java\jdk1.8.0_181\bin\java.exe" "-javaagent:C:\Program
> Files\JetBrains\IntelliJ IDEA Community Edition
> 2018.2.6\lib\idea_rt.jar=61892:C:\Program Files\JetBrains\IntelliJ IDEA
> Community Edition 2018.2.6\bin" -Dfile.encoding=UTF-8 -classpath
> "C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\charsets.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\deploy.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\access-bridge-64.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\cldrdata.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\dnsns.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\jaccess.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\jfxrt.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\localedata.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\nashorn.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\sunec.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\sunjce_provider.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\sunmscapi.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\sunpkcs11.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\ext\zipfs.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\javaws.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\jce.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\jfr.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\jfxswt.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\jsse.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\management-agent.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\plugin.jar;C:\Program
> Files\Java\jdk1.8.0_181\jre\lib\resources.jar;C:\Program
>
> Files\Java\jdk1.8.0_181\jre\lib\rt.jar;D:\code\java-intellij\SampleCluster\target\classes;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-core\2.5.0\ignite-core-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\javax\cache\cache-api\1.1.0\cache-api-1.1.0.jar;C:\Users\arun_jayapal\.m2\repository\org\jetbrains\annotations\13.0\annotations-13.0.jar;C:\Users\arun_jayapal\.m2\repository\org\gridgain\ignite-shmem\1.0.0\ignite-shmem-1.0.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-spring\2.5.0\ignite-spring-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-core\5.0.9.RELEASE\spring-core-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-jcl\5.0.9.RELEASE\spring-jcl-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-aop\5.0.9.RELEASE\spring-aop-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-beans\5.0.9.RELEASE\spring-beans-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-context\5.0.9.RELEASE\spring-context-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-expression\5.0.9.RELEASE\spring-expression-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-tx\5.0.9.RELEASE\spring-tx-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-jdbc\5.0.9.RELEASE\spring-jdbc-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\commons-logging\commons-logging\1.1.1\commons-logging-1.1.1.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-indexing\2.5.0\ignite-indexing-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-core\5.5.2\lucene-core-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-analyzers-common\5.5.2\lucene-analyzers-common-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queryparser\5.5.2\lucene-queryparser-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queries\5.5.2\lucene-queries-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-sandbox\5.5.2\lucene-sandbox-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\com\h2database\h2\1.4.197\h2-1.4.197.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-rest-http\2.5.0\ignite-rest-http-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\tomcat-servlet-api\8.0.23\tomcat-servlet-api-8.0.23.jar;C:\Users\arun_jayapal\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-continuation\9.4.12.v20180830\jetty-continuation-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-http\9.4.12.v20180830\jetty-http-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-io\9.4.12.v20180830\jetty-io-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-server\9.4.12.v20180830\jetty-server-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-util\9.4.12.v20180830\jetty-util-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-xml\9.4.12.v20180830\jetty-xml-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.9.6\jackson-core-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.9.6\jackson-databind-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\arun_jayapal\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\arun_jayapal\.m2\repository\org\postgresql\postgresql\9.4.1212.jre7\postgresql-9.4.1212.jre7.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.0.5.RELEASE\spring-boot-starter-web-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter\2.0.5.RELEASE\spring-boot-starter-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot\2.0.5.RELEASE\spring-boot-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.0.5.RELEASE\spring-boot-autoconfigure-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;C:\Users\arun_jayapal\.m2\repository\org\yaml\snakeyaml\1.19\snakeyaml-1.19.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.0.5.RELEASE\spring-boot-starter-json-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.6\jackson-datatype-jdk8-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.6\jackson-datatype-jsr310-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.6\jackson-module-parameter-names-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.0.5.RELEASE\spring-boot-starter-tomcat-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.34\tomcat-embed-core-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.34\tomcat-embed-el-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.34\tomcat-embed-websocket-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\hibernate\validator\hibernate-validator\6.0.12.Final\hibernate-validator-6.0.12.Final.jar;C:\Users\arun_jayapal\.m2\repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;C:\Users\arun_jayapal\.m2\repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-web\5.0.9.RELEASE\spring-web-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-webmvc\5.0.9.RELEASE\spring-webmvc-5.0.9.RELEASE.jar"
> startup.ServerNodeSpringStartup
> [16:21:27]    __________  ________________
> [16:21:27]   /  _/ ___/ |/ /  _/_  __/ __/
> [16:21:27]  _/ // (7 7    // /  / / / _/
> [16:21:27] /___/\___/_/|_/___/ /_/ /___/
> [16:21:27]
> [16:21:27] ver. 2.5.0#20180523-sha1:86e110c7
> [16:21:27] 2018 Copyright(C) Apache Software Foundation
> [16:21:27]
> [16:21:27] Ignite documentation: http://ignite.apache.org
> [16:21:27]
> [16:21:27] Quiet mode.
> [16:21:27]   ^-- Logging to file
> 'D:\work\ignite\apache-ignite-2.6.0-src\work\log\ignite-ebaeaeca.0.log'
> [16:21:28]   ^-- Logging by 'JavaLogger [quiet=true, config=null]'
> [16:21:28]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false
> or "-v" to ignite.{sh|bat}
> [16:21:28]
> [16:21:28] OS: Windows 8.1 6.3 amd64
> [16:21:28] VM information: Java(TM) SE Runtime Environment 1.8.0_181-b13
> Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.181-b13
> [16:21:28] Initial heap size is 128MB (should be no less than 512MB, use
> -Xms512m -Xmx512m).
> [16:21:29] Configured plugins:
> [16:21:29]   ^-- None
> [16:21:29]
> [16:21:29] Configured failure handler: [hnd=StopNodeOrHaltFailureHandler
> [tryStop=false, timeout=0]]
> [16:21:29] Message queue limit is set to 0 which may lead to potential
> OOMEs
> when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to
> message queues growth on sender and receiver sides.
> [16:21:29] Security status [authentication=off, tls/ssl=off]
> [16:21:31,404][SEVERE][main][IgniteKernal%SampleCluster] Exception during
> start processors, node will be stopped and close connections
> java.lang.NoSuchMethodError:
> org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
>         at
>
> org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:264)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
>         at
>
> org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
>         at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
>         at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
>         at
>
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
>         at org.apache.ignite.Ignition.start(Ignition.java:352)
>         at
> startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
> [16:21:31,404][SEVERE][main][IgniteKernal%SampleCluster] Got exception
> while
> starting (will rollback startup routine).
> java.lang.NoSuchMethodError:
> org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
>         at
>
> org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:264)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
>         at
>
> org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
>         at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
>         at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
>         at
>
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
>         at org.apache.ignite.Ignition.start(Ignition.java:352)
>         at
> startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
> [16:21:31,483][SEVERE][main][IgniteH2Indexing] Failed to shutdown database.
> org.h2.jdbc.JdbcSQLException: Unsupported connection setting "NESTED_JOINS"
> [90113-197]
>         at
> org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
>         at org.h2.message.DbException.get(DbException.java:179)
>         at org.h2.message.DbException.get(DbException.java:155)
>         at
> org.h2.engine.ConnectionInfo.readSettingsFromURL(ConnectionInfo.java:268)
>         at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:76)
>         at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
>         at org.h2.Driver.connect(Driver.java:69)
>         at java.sql.DriverManager.getConnection(DriverManager.java:664)
>         at java.sql.DriverManager.getConnection(DriverManager.java:270)
>         at
>
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.stop(IgniteH2Indexing.java:2719)
>         at
>
> org.apache.ignite.internal.processors.query.GridQueryProcessor.stop(GridQueryProcessor.java:284)
>         at
> org.apache.ignite.internal.IgniteKernal.stop0(IgniteKernal.java:2269)
>         at
> org.apache.ignite.internal.IgniteKernal.stop(IgniteKernal.java:2147)
>         at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:1131)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
>         at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
>         at
>
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
>         at org.apache.ignite.Ignition.start(Ignition.java:352)
>         at
> startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
> [16:21:31] Ignite node stopped OK [name=SampleCluster, uptime=00:00:43.536]
> Exception in thread "main" java.lang.NoSuchMethodError:
> org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
>         at
>
> org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
>         at java.lang.Class.forName0(Native Method)
>         at java.lang.Class.forName(Class.java:264)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
>         at
>
> org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
>         at
>
> org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
>         at
> org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
>         at
>
> org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
>         at
> org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
>         at
>
> org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
>         at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
>         at org.apache.ignite.Ignition.start(Ignition.java:352)
>         at
> startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
> ------END_PASTE-----
>
> Sprint config:
> ========
>
> ---BEGIN_PASTE----
> <?xml version="1.0" encoding="UTF-8"?>
>
>
>
> <beans xmlns="http://www.springframework.org/schema/beans"
>        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>        xmlns:util="http://www.springframework.org/schema/util"
>        xsi:schemaLocation="http://www.springframework.org/schema/beans
>
> http://www.springframework.org/schema/beans/spring-beans.xsd
>                            http://www.springframework.org/schema/util
>
> http://www.springframework.org/schema/util/spring-util.xsd">
>
>     <bean id="placeholderConfig"
>
> class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
>         <property name="location" value="classpath:secret.properties"/>
>     </bean>
>
>
>     <bean id="dsPostgreSQL_Familybank"
> class="org.postgresql.ds.PGPoolingDataSource">
>         <property name="url" value="${dsPostgreSQL_Familybank.jdbc.url}"/>
>         <property name="user"
> value="${dsPostgreSQL_Familybank.jdbc.username}"/>
>         <property name="password"
> value="${dsPostgreSQL_Familybank.jdbc.password}"/>
>     </bean>
>
>     <bean class="org.apache.ignite.configuration.IgniteConfiguration">
>         <property name="igniteInstanceName" value="SampleCluster"/>
>
>         <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 name="addresses">
>                             <list>
>                                 <value>127.0.0.1:47500..47510</value>
>                             </list>
>                         </property>
>                     </bean>
>                 </property>
>             </bean>
>         </property>
>
>         <property name="cacheConfiguration">
>             <list>
>                 <bean
> class="org.apache.ignite.configuration.CacheConfiguration">
>                     <property name="name" value="AccountCache"/>
>                     <property name="cacheMode" value="PARTITIONED"/>
>                     <property name="atomicityMode" value="ATOMIC"/>
>
>                     <property name="cacheStoreFactory">
>                         <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                             <property name="dataSourceBean"
> value="dsPostgreSQL_Familybank"/>
>                             <property name="dialect">
>                                 <bean
> class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
>                                 </bean>
>                             </property>
>
>                             <property name="types">
>                                 <list>
>                                     <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcType">
>                                         <property name="cacheName"
> value="AccountCache"/>
>                                         <property name="keyType"
> value="java.lang.Integer"/>
>                                         <property name="valueType"
> value="io.oecloud.root.fambank.Account"/>
>                                         <property name="databaseSchema"
> value="public"/>
>                                         <property name="databaseTable"
> value="account"/>
>
>                                         <property name="keyFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="accountid"/>
>                                                     <constructor-arg
> value="int"/>
>                                                     <constructor-arg
> value="accountid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>
>                                         <property name="valueFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.VARCHAR"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="accounttype"/>
>                                                     <constructor-arg
> value="java.lang.String"/>
>                                                     <constructor-arg
> value="accounttype"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="customerid"/>
>                                                     <constructor-arg
> value="java.lang.Integer"/>
>                                                     <constructor-arg
> value="customerid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>                                     </bean>
>                                 </list>
>                             </property>
>                         </bean>
>                     </property>
>
>                     <property name="readThrough" value="true"/>
>                     <property name="writeThrough" value="true"/>
>
>                     <property name="queryEntities">
>                         <list>
>                             <bean
> class="org.apache.ignite.cache.QueryEntity">
>                                 <property name="keyType"
> value="java.lang.Integer"/>
>                                 <property name="valueType"
> value="io.oecloud.root.fambank.Account"/>
>                                 <property name="keyFieldName"
> value="accountid"/>
>
>                                 <property name="keyFields">
>                                     <list>
>                                         <value>accountid</value>
>                                     </list>
>                                 </property>
>
>                                 <property name="fields">
>                                     <map>
>                                         <entry key="accounttype"
> value="java.lang.String"/>
>                                         <entry key="customerid"
> value="java.lang.Integer"/>
>                                         <entry key="accountid"
> value="java.lang.Integer"/>
>                                     </map>
>                                 </property>
>                             </bean>
>                         </list>
>                     </property>
>                 </bean>
>
>                 <bean
> class="org.apache.ignite.configuration.CacheConfiguration">
>                     <property name="name" value="CustomerCache"/>
>                     <property name="cacheMode" value="PARTITIONED"/>
>                     <property name="atomicityMode" value="ATOMIC"/>
>
>                     <property name="cacheStoreFactory">
>                         <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                             <property name="dataSourceBean"
> value="dsPostgreSQL_Familybank"/>
>                             <property name="dialect">
>                                 <bean
> class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
>                                 </bean>
>                             </property>
>
>                             <property name="types">
>                                 <list>
>                                     <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcType">
>                                         <property name="cacheName"
> value="CustomerCache"/>
>                                         <property name="keyType"
> value="java.lang.Integer"/>
>                                         <property name="valueType"
> value="io.oecloud.root.fambank.Customer"/>
>                                         <property name="databaseSchema"
> value="public"/>
>                                         <property name="databaseTable"
> value="customer"/>
>
>                                         <property name="keyFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="customerid"/>
>                                                     <constructor-arg
> value="int"/>
>                                                     <constructor-arg
> value="customerid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>
>                                         <property name="valueFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.VARCHAR"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="customername"/>
>                                                     <constructor-arg
> value="java.lang.String"/>
>                                                     <constructor-arg
> value="customername"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="age"/>
>                                                     <constructor-arg
> value="java.lang.Integer"/>
>                                                     <constructor-arg
> value="age"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.VARCHAR"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="gender"/>
>                                                     <constructor-arg
> value="java.lang.String"/>
>                                                     <constructor-arg
> value="gender"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>                                     </bean>
>                                 </list>
>                             </property>
>                         </bean>
>                     </property>
>
>                     <property name="readThrough" value="true"/>
>                     <property name="writeThrough" value="true"/>
>
>                     <property name="queryEntities">
>                         <list>
>                             <bean
> class="org.apache.ignite.cache.QueryEntity">
>                                 <property name="keyType"
> value="java.lang.Integer"/>
>                                 <property name="valueType"
> value="io.oecloud.root.fambank.Customer"/>
>                                 <property name="keyFieldName"
> value="customerid"/>
>
>                                 <property name="keyFields">
>                                     <list>
>                                         <value>customerid</value>
>                                     </list>
>                                 </property>
>
>                                 <property name="fields">
>                                     <map>
>                                         <entry key="customername"
> value="java.lang.String"/>
>                                         <entry key="age"
> value="java.lang.Integer"/>
>                                         <entry key="gender"
> value="java.lang.String"/>
>                                         <entry key="customerid"
> value="java.lang.Integer"/>
>                                     </map>
>                                 </property>
>                             </bean>
>                         </list>
>                     </property>
>                 </bean>
>
>                 <bean
> class="org.apache.ignite.configuration.CacheConfiguration">
>                     <property name="name" value="FamilyCache"/>
>                     <property name="cacheMode" value="PARTITIONED"/>
>                     <property name="atomicityMode" value="ATOMIC"/>
>
>                     <property name="cacheStoreFactory">
>                         <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                             <property name="dataSourceBean"
> value="dsPostgreSQL_Familybank"/>
>                             <property name="dialect">
>                                 <bean
> class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
>                                 </bean>
>                             </property>
>
>                             <property name="types">
>                                 <list>
>                                     <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcType">
>                                         <property name="cacheName"
> value="FamilyCache"/>
>                                         <property name="keyType"
> value="java.lang.Integer"/>
>                                         <property name="valueType"
> value="io.oecloud.root.fambank.Family"/>
>                                         <property name="databaseSchema"
> value="public"/>
>                                         <property name="databaseTable"
> value="family"/>
>
>                                         <property name="keyFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="familyid"/>
>                                                     <constructor-arg
> value="int"/>
>                                                     <constructor-arg
> value="familyid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>
>                                         <property name="valueFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.VARCHAR"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="familyname"/>
>                                                     <constructor-arg
> value="java.lang.String"/>
>                                                     <constructor-arg
> value="familyname"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>                                     </bean>
>                                 </list>
>                             </property>
>                         </bean>
>                     </property>
>
>                     <property name="readThrough" value="true"/>
>                     <property name="writeThrough" value="true"/>
>
>                     <property name="queryEntities">
>                         <list>
>                             <bean
> class="org.apache.ignite.cache.QueryEntity">
>                                 <property name="keyType"
> value="java.lang.Integer"/>
>                                 <property name="valueType"
> value="io.oecloud.root.fambank.Family"/>
>                                 <property name="keyFieldName"
> value="familyid"/>
>
>                                 <property name="keyFields">
>                                     <list>
>                                         <value>familyid</value>
>                                     </list>
>                                 </property>
>
>                                 <property name="fields">
>                                     <map>
>                                         <entry key="familyname"
> value="java.lang.String"/>
>                                         <entry key="familyid"
> value="java.lang.Integer"/>
>                                     </map>
>                                 </property>
>                             </bean>
>                         </list>
>                     </property>
>                 </bean>
>
>                 <bean
> class="org.apache.ignite.configuration.CacheConfiguration">
>                     <property name="name" value="FamilymembersCache"/>
>                     <property name="cacheMode" value="PARTITIONED"/>
>                     <property name="atomicityMode" value="ATOMIC"/>
>
>                     <property name="cacheStoreFactory">
>                         <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                             <property name="dataSourceBean"
> value="dsPostgreSQL_Familybank"/>
>                             <property name="dialect">
>                                 <bean
> class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
>                                 </bean>
>                             </property>
>
>                             <property name="types">
>                                 <list>
>                                     <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcType">
>                                         <property name="cacheName"
> value="FamilymembersCache"/>
>                                         <property name="keyType"
> value="java.lang.Integer"/>
>                                         <property name="valueType"
> value="io.oecloud.root.fambank.Familymembers"/>
>                                         <property name="databaseSchema"
> value="public"/>
>                                         <property name="databaseTable"
> value="familymembers"/>
>
>                                         <property name="keyFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="memberid"/>
>                                                     <constructor-arg
> value="int"/>
>                                                     <constructor-arg
> value="memberid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>
>                                         <property name="valueFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="familyid"/>
>                                                     <constructor-arg
> value="java.lang.Integer"/>
>                                                     <constructor-arg
> value="familyid"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="accountid"/>
>                                                     <constructor-arg
> value="java.lang.Integer"/>
>                                                     <constructor-arg
> value="accountid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>                                     </bean>
>                                 </list>
>                             </property>
>                         </bean>
>                     </property>
>
>                     <property name="readThrough" value="true"/>
>                     <property name="writeThrough" value="true"/>
>
>                     <property name="queryEntities">
>                         <list>
>                             <bean
> class="org.apache.ignite.cache.QueryEntity">
>                                 <property name="keyType"
> value="java.lang.Integer"/>
>                                 <property name="valueType"
> value="io.oecloud.root.fambank.Familymembers"/>
>                                 <property name="keyFieldName"
> value="memberid"/>
>
>                                 <property name="keyFields">
>                                     <list>
>                                         <value>memberid</value>
>                                     </list>
>                                 </property>
>
>                                 <property name="fields">
>                                     <map>
>                                         <entry key="familyid"
> value="java.lang.Integer"/>
>                                         <entry key="accountid"
> value="java.lang.Integer"/>
>                                         <entry key="memberid"
> value="java.lang.Integer"/>
>                                     </map>
>                                 </property>
>                             </bean>
>                         </list>
>                     </property>
>                 </bean>
>
>                 <bean
> class="org.apache.ignite.configuration.CacheConfiguration">
>                     <property name="name" value="JournalCache"/>
>                     <property name="cacheMode" value="PARTITIONED"/>
>                     <property name="atomicityMode" value="ATOMIC"/>
>
>                     <property name="cacheStoreFactory">
>                         <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                             <property name="dataSourceBean"
> value="dsPostgreSQL_Familybank"/>
>                             <property name="dialect">
>                                 <bean
> class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
>                                 </bean>
>                             </property>
>
>                             <property name="types">
>                                 <list>
>                                     <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcType">
>                                         <property name="cacheName"
> value="JournalCache"/>
>                                         <property name="keyType"
> value="java.lang.Integer"/>
>                                         <property name="valueType"
> value="io.oecloud.root.fambank.Journal"/>
>                                         <property name="databaseSchema"
> value="public"/>
>                                         <property name="databaseTable"
> value="journal"/>
>
>                                         <property name="keyFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="journalid"/>
>                                                     <constructor-arg
> value="int"/>
>                                                     <constructor-arg
> value="journalid"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>
>                                         <property name="valueFields">
>                                             <list>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.INTEGER"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="accountid"/>
>                                                     <constructor-arg
> value="java.lang.Integer"/>
>                                                     <constructor-arg
> value="accountid"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.VARCHAR"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="transactiontype"/>
>                                                     <constructor-arg
> value="java.lang.String"/>
>                                                     <constructor-arg
> value="transactiontype"/>
>                                                 </bean>
>
>                                                 <bean
> class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
>                                                     <constructor-arg>
>                                                         <util:constant
> static-field="java.sql.Types.DOUBLE"/>
>                                                     </constructor-arg>
>                                                     <constructor-arg
> value="amount"/>
>                                                     <constructor-arg
> value="double"/>
>                                                     <constructor-arg
> value="amount"/>
>                                                 </bean>
>                                             </list>
>                                         </property>
>                                     </bean>
>                                 </list>
>                             </property>
>                         </bean>
>                     </property>
>
>                     <property name="readThrough" value="true"/>
>                     <property name="writeThrough" value="true"/>
>
>                     <property name="queryEntities">
>                         <list>
>                             <bean
> class="org.apache.ignite.cache.QueryEntity">
>                                 <property name="keyType"
> value="java.lang.Integer"/>
>                                 <property name="valueType"
> value="io.oecloud.root.fambank.Journal"/>
>                                 <property name="keyFieldName"
> value="journalid"/>
>
>                                 <property name="keyFields">
>                                     <list>
>                                         <value>journalid</value>
>                                     </list>
>                                 </property>
>
>                                 <property name="fields">
>                                     <map>
>                                         <entry key="accountid"
> value="java.lang.Integer"/>
>                                         <entry key="transactiontype"
> value="java.lang.String"/>
>                                         <entry key="amount"
> value="java.lang.Double"/>
>                                         <entry key="journalid"
> value="java.lang.Integer"/>
>                                     </map>
>                                 </property>
>                             </bean>
>                         </list>
>                     </property>
>                 </bean>
>             </list>
>         </property>
>     </bean>
> </beans>
> ---END_PASTE---
>
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>
>

Re: Web console project cannot start an ignite server node

Posted by deostroll <de...@gmail.com>.
Sorry my bad. I thought nabble editor should take care of this.

I will share the spring config and the program output between a series of
begin_paste and end_paste.

Program output:
==========

---BEGIN_PASTE---
"C:\Program Files\Java\jdk1.8.0_181\bin\java.exe" "-javaagent:C:\Program
Files\JetBrains\IntelliJ IDEA Community Edition
2018.2.6\lib\idea_rt.jar=61892:C:\Program Files\JetBrains\IntelliJ IDEA
Community Edition 2018.2.6\bin" -Dfile.encoding=UTF-8 -classpath "C:\Program
Files\Java\jdk1.8.0_181\jre\lib\charsets.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\deploy.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\access-bridge-64.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\cldrdata.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\dnsns.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\jaccess.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\jfxrt.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\localedata.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\nashorn.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\sunec.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\sunjce_provider.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\sunmscapi.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\sunpkcs11.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\ext\zipfs.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\javaws.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\jce.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\jfr.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\jfxswt.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\jsse.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\management-agent.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\plugin.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\resources.jar;C:\Program
Files\Java\jdk1.8.0_181\jre\lib\rt.jar;D:\code\java-intellij\SampleCluster\target\classes;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-core\2.5.0\ignite-core-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\javax\cache\cache-api\1.1.0\cache-api-1.1.0.jar;C:\Users\arun_jayapal\.m2\repository\org\jetbrains\annotations\13.0\annotations-13.0.jar;C:\Users\arun_jayapal\.m2\repository\org\gridgain\ignite-shmem\1.0.0\ignite-shmem-1.0.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-spring\2.5.0\ignite-spring-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-core\5.0.9.RELEASE\spring-core-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-jcl\5.0.9.RELEASE\spring-jcl-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-aop\5.0.9.RELEASE\spring-aop-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-beans\5.0.9.RELEASE\spring-beans-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-context\5.0.9.RELEASE\spring-context-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-expression\5.0.9.RELEASE\spring-expression-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-tx\5.0.9.RELEASE\spring-tx-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-jdbc\5.0.9.RELEASE\spring-jdbc-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\commons-logging\commons-logging\1.1.1\commons-logging-1.1.1.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-indexing\2.5.0\ignite-indexing-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\commons-codec\commons-codec\1.11\commons-codec-1.11.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-core\5.5.2\lucene-core-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-analyzers-common\5.5.2\lucene-analyzers-common-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queryparser\5.5.2\lucene-queryparser-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-queries\5.5.2\lucene-queries-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\lucene\lucene-sandbox\5.5.2\lucene-sandbox-5.5.2.jar;C:\Users\arun_jayapal\.m2\repository\com\h2database\h2\1.4.197\h2-1.4.197.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\ignite\ignite-rest-http\2.5.0\ignite-rest-http-2.5.0.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\tomcat-servlet-api\8.0.23\tomcat-servlet-api-8.0.23.jar;C:\Users\arun_jayapal\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-continuation\9.4.12.v20180830\jetty-continuation-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-http\9.4.12.v20180830\jetty-http-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-io\9.4.12.v20180830\jetty-io-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-server\9.4.12.v20180830\jetty-server-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-util\9.4.12.v20180830\jetty-util-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\org\eclipse\jetty\jetty-xml\9.4.12.v20180830\jetty-xml-9.4.12.v20180830.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.9.6\jackson-core-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.9.0\jackson-annotations-2.9.0.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.9.6\jackson-databind-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\arun_jayapal\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\arun_jayapal\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\arun_jayapal\.m2\repository\org\postgresql\postgresql\9.4.1212.jre7\postgresql-9.4.1212.jre7.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-web\2.0.5.RELEASE\spring-boot-starter-web-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter\2.0.5.RELEASE\spring-boot-starter-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot\2.0.5.RELEASE\spring-boot-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-autoconfigure\2.0.5.RELEASE\spring-boot-autoconfigure-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;C:\Users\arun_jayapal\.m2\repository\org\yaml\snakeyaml\1.19\snakeyaml-1.19.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-json\2.0.5.RELEASE\spring-boot-starter-json-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jdk8\2.9.6\jackson-datatype-jdk8-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\datatype\jackson-datatype-jsr310\2.9.6\jackson-datatype-jsr310-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\jackson\module\jackson-module-parameter-names\2.9.6\jackson-module-parameter-names-2.9.6.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\boot\spring-boot-starter-tomcat\2.0.5.RELEASE\spring-boot-starter-tomcat-2.0.5.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\8.5.34\tomcat-embed-core-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-el\8.5.34\tomcat-embed-el-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.34\tomcat-embed-websocket-8.5.34.jar;C:\Users\arun_jayapal\.m2\repository\org\hibernate\validator\hibernate-validator\6.0.12.Final\hibernate-validator-6.0.12.Final.jar;C:\Users\arun_jayapal\.m2\repository\javax\validation\validation-api\2.0.1.Final\validation-api-2.0.1.Final.jar;C:\Users\arun_jayapal\.m2\repository\org\jboss\logging\jboss-logging\3.3.2.Final\jboss-logging-3.3.2.Final.jar;C:\Users\arun_jayapal\.m2\repository\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-web\5.0.9.RELEASE\spring-web-5.0.9.RELEASE.jar;C:\Users\arun_jayapal\.m2\repository\org\springframework\spring-webmvc\5.0.9.RELEASE\spring-webmvc-5.0.9.RELEASE.jar"
startup.ServerNodeSpringStartup
[16:21:27]    __________  ________________ 
[16:21:27]   /  _/ ___/ |/ /  _/_  __/ __/ 
[16:21:27]  _/ // (7 7    // /  / / / _/   
[16:21:27] /___/\___/_/|_/___/ /_/ /___/  
[16:21:27] 
[16:21:27] ver. 2.5.0#20180523-sha1:86e110c7
[16:21:27] 2018 Copyright(C) Apache Software Foundation
[16:21:27] 
[16:21:27] Ignite documentation: http://ignite.apache.org
[16:21:27] 
[16:21:27] Quiet mode.
[16:21:27]   ^-- Logging to file
'D:\work\ignite\apache-ignite-2.6.0-src\work\log\ignite-ebaeaeca.0.log'
[16:21:28]   ^-- Logging by 'JavaLogger [quiet=true, config=null]'
[16:21:28]   ^-- To see **FULL** console log here add -DIGNITE_QUIET=false
or "-v" to ignite.{sh|bat}
[16:21:28] 
[16:21:28] OS: Windows 8.1 6.3 amd64
[16:21:28] VM information: Java(TM) SE Runtime Environment 1.8.0_181-b13
Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.181-b13
[16:21:28] Initial heap size is 128MB (should be no less than 512MB, use
-Xms512m -Xmx512m).
[16:21:29] Configured plugins:
[16:21:29]   ^-- None
[16:21:29] 
[16:21:29] Configured failure handler: [hnd=StopNodeOrHaltFailureHandler
[tryStop=false, timeout=0]]
[16:21:29] Message queue limit is set to 0 which may lead to potential OOMEs
when running cache operations in FULL_ASYNC or PRIMARY_SYNC modes due to
message queues growth on sender and receiver sides.
[16:21:29] Security status [authentication=off, tls/ssl=off]
[16:21:31,404][SEVERE][main][IgniteKernal%SampleCluster] Exception during
start processors, node will be stopped and close connections
java.lang.NoSuchMethodError:
org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
	at
org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
	at
org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
	at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
	at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
	at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
	at org.apache.ignite.Ignition.start(Ignition.java:352)
	at startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
[16:21:31,404][SEVERE][main][IgniteKernal%SampleCluster] Got exception while
starting (will rollback startup routine).
java.lang.NoSuchMethodError:
org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
	at
org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
	at
org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
	at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
	at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
	at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
	at org.apache.ignite.Ignition.start(Ignition.java:352)
	at startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
[16:21:31,483][SEVERE][main][IgniteH2Indexing] Failed to shutdown database.
org.h2.jdbc.JdbcSQLException: Unsupported connection setting "NESTED_JOINS"
[90113-197]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
	at org.h2.message.DbException.get(DbException.java:179)
	at org.h2.message.DbException.get(DbException.java:155)
	at
org.h2.engine.ConnectionInfo.readSettingsFromURL(ConnectionInfo.java:268)
	at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:76)
	at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
	at org.h2.Driver.connect(Driver.java:69)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:270)
	at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.stop(IgniteH2Indexing.java:2719)
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor.stop(GridQueryProcessor.java:284)
	at org.apache.ignite.internal.IgniteKernal.stop0(IgniteKernal.java:2269)
	at org.apache.ignite.internal.IgniteKernal.stop(IgniteKernal.java:2147)
	at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:1131)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
	at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
	at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
	at org.apache.ignite.Ignition.start(Ignition.java:352)
	at startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
[16:21:31] Ignite node stopped OK [name=SampleCluster, uptime=00:00:43.536]
Exception in thread "main" java.lang.NoSuchMethodError:
org.eclipse.jetty.util.log.StdErrLog.setProperties(Ljava/util/Properties;)V
	at
org.apache.ignite.internal.processors.rest.protocols.http.jetty.GridJettyRestProtocol.<clinit>(GridJettyRestProtocol.java:72)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.startHttpProtocol(GridRestProcessor.java:922)
	at
org.apache.ignite.internal.processors.rest.GridRestProcessor.start(GridRestProcessor.java:516)
	at
org.apache.ignite.internal.IgniteKernal.startProcessor(IgniteKernal.java:1738)
	at org.apache.ignite.internal.IgniteKernal.start(IgniteKernal.java:993)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start0(IgnitionEx.java:2014)
	at
org.apache.ignite.internal.IgnitionEx$IgniteNamedInstance.start(IgnitionEx.java:1723)
	at org.apache.ignite.internal.IgnitionEx.start0(IgnitionEx.java:1151)
	at
org.apache.ignite.internal.IgnitionEx.startConfigurations(IgnitionEx.java:1069)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:955)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:854)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:724)
	at org.apache.ignite.internal.IgnitionEx.start(IgnitionEx.java:693)
	at org.apache.ignite.Ignition.start(Ignition.java:352)
	at startup.ServerNodeSpringStartup.main(ServerNodeSpringStartup.java:14)
------END_PASTE-----

Sprint config:
========

---BEGIN_PASTE----
<?xml version="1.0" encoding="UTF-8"?>



<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:util="http://www.springframework.org/schema/util"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
                          
http://www.springframework.org/schema/beans/spring-beans.xsd
                           http://www.springframework.org/schema/util
                          
http://www.springframework.org/schema/util/spring-util.xsd">
    
    <bean id="placeholderConfig"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location" value="classpath:secret.properties"/>
    </bean>

    
    <bean id="dsPostgreSQL_Familybank"
class="org.postgresql.ds.PGPoolingDataSource">
        <property name="url" value="${dsPostgreSQL_Familybank.jdbc.url}"/>
        <property name="user"
value="${dsPostgreSQL_Familybank.jdbc.username}"/>
        <property name="password"
value="${dsPostgreSQL_Familybank.jdbc.password}"/>
    </bean>

    <bean class="org.apache.ignite.configuration.IgniteConfiguration">
        <property name="igniteInstanceName" value="SampleCluster"/>

        <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 name="addresses">
                            <list>
                                <value>127.0.0.1:47500..47510</value>
                            </list>
                        </property>
                    </bean>
                </property>
            </bean>
        </property>

        <property name="cacheConfiguration">
            <list>
                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="AccountCache"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="ATOMIC"/>

                    <property name="cacheStoreFactory">
                        <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                            <property name="dataSourceBean"
value="dsPostgreSQL_Familybank"/>
                            <property name="dialect">
                                <bean
class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
                                </bean>
                            </property>

                            <property name="types">
                                <list>
                                    <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                        <property name="cacheName"
value="AccountCache"/>
                                        <property name="keyType"
value="java.lang.Integer"/>
                                        <property name="valueType"
value="io.oecloud.root.fambank.Account"/>
                                        <property name="databaseSchema"
value="public"/>
                                        <property name="databaseTable"
value="account"/>

                                        <property name="keyFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="accountid"/>
                                                    <constructor-arg
value="int"/>
                                                    <constructor-arg
value="accountid"/>
                                                </bean>
                                            </list>
                                        </property>

                                        <property name="valueFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="accounttype"/>
                                                    <constructor-arg
value="java.lang.String"/>
                                                    <constructor-arg
value="accounttype"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="customerid"/>
                                                    <constructor-arg
value="java.lang.Integer"/>
                                                    <constructor-arg
value="customerid"/>
                                                </bean>
                                            </list>
                                        </property>
                                    </bean>
                                </list>
                            </property>
                        </bean>
                    </property>

                    <property name="readThrough" value="true"/>
                    <property name="writeThrough" value="true"/>

                    <property name="queryEntities">
                        <list>
                            <bean
class="org.apache.ignite.cache.QueryEntity">
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="io.oecloud.root.fambank.Account"/>
                                <property name="keyFieldName"
value="accountid"/>

                                <property name="keyFields">
                                    <list>
                                        <value>accountid</value>
                                    </list>
                                </property>

                                <property name="fields">
                                    <map>
                                        <entry key="accounttype"
value="java.lang.String"/>
                                        <entry key="customerid"
value="java.lang.Integer"/>
                                        <entry key="accountid"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>

                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="CustomerCache"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="ATOMIC"/>

                    <property name="cacheStoreFactory">
                        <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                            <property name="dataSourceBean"
value="dsPostgreSQL_Familybank"/>
                            <property name="dialect">
                                <bean
class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
                                </bean>
                            </property>

                            <property name="types">
                                <list>
                                    <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                        <property name="cacheName"
value="CustomerCache"/>
                                        <property name="keyType"
value="java.lang.Integer"/>
                                        <property name="valueType"
value="io.oecloud.root.fambank.Customer"/>
                                        <property name="databaseSchema"
value="public"/>
                                        <property name="databaseTable"
value="customer"/>

                                        <property name="keyFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="customerid"/>
                                                    <constructor-arg
value="int"/>
                                                    <constructor-arg
value="customerid"/>
                                                </bean>
                                            </list>
                                        </property>

                                        <property name="valueFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="customername"/>
                                                    <constructor-arg
value="java.lang.String"/>
                                                    <constructor-arg
value="customername"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="age"/>
                                                    <constructor-arg
value="java.lang.Integer"/>
                                                    <constructor-arg
value="age"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="gender"/>
                                                    <constructor-arg
value="java.lang.String"/>
                                                    <constructor-arg
value="gender"/>
                                                </bean>
                                            </list>
                                        </property>
                                    </bean>
                                </list>
                            </property>
                        </bean>
                    </property>

                    <property name="readThrough" value="true"/>
                    <property name="writeThrough" value="true"/>

                    <property name="queryEntities">
                        <list>
                            <bean
class="org.apache.ignite.cache.QueryEntity">
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="io.oecloud.root.fambank.Customer"/>
                                <property name="keyFieldName"
value="customerid"/>

                                <property name="keyFields">
                                    <list>
                                        <value>customerid</value>
                                    </list>
                                </property>

                                <property name="fields">
                                    <map>
                                        <entry key="customername"
value="java.lang.String"/>
                                        <entry key="age"
value="java.lang.Integer"/>
                                        <entry key="gender"
value="java.lang.String"/>
                                        <entry key="customerid"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>

                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="FamilyCache"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="ATOMIC"/>

                    <property name="cacheStoreFactory">
                        <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                            <property name="dataSourceBean"
value="dsPostgreSQL_Familybank"/>
                            <property name="dialect">
                                <bean
class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
                                </bean>
                            </property>

                            <property name="types">
                                <list>
                                    <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                        <property name="cacheName"
value="FamilyCache"/>
                                        <property name="keyType"
value="java.lang.Integer"/>
                                        <property name="valueType"
value="io.oecloud.root.fambank.Family"/>
                                        <property name="databaseSchema"
value="public"/>
                                        <property name="databaseTable"
value="family"/>

                                        <property name="keyFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="familyid"/>
                                                    <constructor-arg
value="int"/>
                                                    <constructor-arg
value="familyid"/>
                                                </bean>
                                            </list>
                                        </property>

                                        <property name="valueFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="familyname"/>
                                                    <constructor-arg
value="java.lang.String"/>
                                                    <constructor-arg
value="familyname"/>
                                                </bean>
                                            </list>
                                        </property>
                                    </bean>
                                </list>
                            </property>
                        </bean>
                    </property>

                    <property name="readThrough" value="true"/>
                    <property name="writeThrough" value="true"/>

                    <property name="queryEntities">
                        <list>
                            <bean
class="org.apache.ignite.cache.QueryEntity">
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="io.oecloud.root.fambank.Family"/>
                                <property name="keyFieldName"
value="familyid"/>

                                <property name="keyFields">
                                    <list>
                                        <value>familyid</value>
                                    </list>
                                </property>

                                <property name="fields">
                                    <map>
                                        <entry key="familyname"
value="java.lang.String"/>
                                        <entry key="familyid"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>

                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="FamilymembersCache"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="ATOMIC"/>

                    <property name="cacheStoreFactory">
                        <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                            <property name="dataSourceBean"
value="dsPostgreSQL_Familybank"/>
                            <property name="dialect">
                                <bean
class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
                                </bean>
                            </property>

                            <property name="types">
                                <list>
                                    <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                        <property name="cacheName"
value="FamilymembersCache"/>
                                        <property name="keyType"
value="java.lang.Integer"/>
                                        <property name="valueType"
value="io.oecloud.root.fambank.Familymembers"/>
                                        <property name="databaseSchema"
value="public"/>
                                        <property name="databaseTable"
value="familymembers"/>

                                        <property name="keyFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="memberid"/>
                                                    <constructor-arg
value="int"/>
                                                    <constructor-arg
value="memberid"/>
                                                </bean>
                                            </list>
                                        </property>

                                        <property name="valueFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="familyid"/>
                                                    <constructor-arg
value="java.lang.Integer"/>
                                                    <constructor-arg
value="familyid"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="accountid"/>
                                                    <constructor-arg
value="java.lang.Integer"/>
                                                    <constructor-arg
value="accountid"/>
                                                </bean>
                                            </list>
                                        </property>
                                    </bean>
                                </list>
                            </property>
                        </bean>
                    </property>

                    <property name="readThrough" value="true"/>
                    <property name="writeThrough" value="true"/>

                    <property name="queryEntities">
                        <list>
                            <bean
class="org.apache.ignite.cache.QueryEntity">
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="io.oecloud.root.fambank.Familymembers"/>
                                <property name="keyFieldName"
value="memberid"/>

                                <property name="keyFields">
                                    <list>
                                        <value>memberid</value>
                                    </list>
                                </property>

                                <property name="fields">
                                    <map>
                                        <entry key="familyid"
value="java.lang.Integer"/>
                                        <entry key="accountid"
value="java.lang.Integer"/>
                                        <entry key="memberid"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>

                <bean
class="org.apache.ignite.configuration.CacheConfiguration">
                    <property name="name" value="JournalCache"/>
                    <property name="cacheMode" value="PARTITIONED"/>
                    <property name="atomicityMode" value="ATOMIC"/>

                    <property name="cacheStoreFactory">
                        <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                            <property name="dataSourceBean"
value="dsPostgreSQL_Familybank"/>
                            <property name="dialect">
                                <bean
class="org.apache.ignite.cache.store.jdbc.dialect.BasicJdbcDialect">
                                </bean>
                            </property>

                            <property name="types">
                                <list>
                                    <bean
class="org.apache.ignite.cache.store.jdbc.JdbcType">
                                        <property name="cacheName"
value="JournalCache"/>
                                        <property name="keyType"
value="java.lang.Integer"/>
                                        <property name="valueType"
value="io.oecloud.root.fambank.Journal"/>
                                        <property name="databaseSchema"
value="public"/>
                                        <property name="databaseTable"
value="journal"/>

                                        <property name="keyFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="journalid"/>
                                                    <constructor-arg
value="int"/>
                                                    <constructor-arg
value="journalid"/>
                                                </bean>
                                            </list>
                                        </property>

                                        <property name="valueFields">
                                            <list>
                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.INTEGER"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="accountid"/>
                                                    <constructor-arg
value="java.lang.Integer"/>
                                                    <constructor-arg
value="accountid"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.VARCHAR"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="transactiontype"/>
                                                    <constructor-arg
value="java.lang.String"/>
                                                    <constructor-arg
value="transactiontype"/>
                                                </bean>

                                                <bean
class="org.apache.ignite.cache.store.jdbc.JdbcTypeField">
                                                    <constructor-arg>
                                                        <util:constant
static-field="java.sql.Types.DOUBLE"/>
                                                    </constructor-arg>
                                                    <constructor-arg
value="amount"/>
                                                    <constructor-arg
value="double"/>
                                                    <constructor-arg
value="amount"/>
                                                </bean>
                                            </list>
                                        </property>
                                    </bean>
                                </list>
                            </property>
                        </bean>
                    </property>

                    <property name="readThrough" value="true"/>
                    <property name="writeThrough" value="true"/>

                    <property name="queryEntities">
                        <list>
                            <bean
class="org.apache.ignite.cache.QueryEntity">
                                <property name="keyType"
value="java.lang.Integer"/>
                                <property name="valueType"
value="io.oecloud.root.fambank.Journal"/>
                                <property name="keyFieldName"
value="journalid"/>

                                <property name="keyFields">
                                    <list>
                                        <value>journalid</value>
                                    </list>
                                </property>

                                <property name="fields">
                                    <map>
                                        <entry key="accountid"
value="java.lang.Integer"/>
                                        <entry key="transactiontype"
value="java.lang.String"/>
                                        <entry key="amount"
value="java.lang.Double"/>
                                        <entry key="journalid"
value="java.lang.Integer"/>
                                    </map>
                                </property>
                            </bean>
                        </list>
                    </property>
                </bean>
            </list>
        </property>
    </bean>
</beans>
---END_PASTE---




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/


Re: Web console project cannot start an ignite server node

Posted by Ilya Kasnacheev <il...@gmail.com>.
Hello, Arun!

Unfortunately there are no links or attachments in your e-mail.

Regards,
-- 
Ilya Kasnacheev


ср, 12 дек. 2018 г. в 14:09, deostroll <de...@gmail.com>:

> Hi,
>
> I successfully imported a database from postgres to ignite via web console.
> And through the web console, I noticed there is the option to download a
> project. I did that, and, noticed that there was code to start ignite
> server
> and client nodes. They executed properly and I was able to see the count of
> nodes increase whenever a new node was started.
>
> However, for some reason the server node fails to start. The program
> however
> doesn't exit, and waits. I am sharing the program console output below. I
> cannot make sense of this:
>
>
>
> - Arun
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>