[
https://issues.apache.org/jira/browse/IGNITE-8197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16525939#comment-16525939
]
kcheng.mvp commented on IGNITE-8197:
------------------------------------
As h2 is the core of ignite, so it should take every consideration into mind
when do h2 upgrade.
for you case, you can simply to overwrite springboot's h2 version by add below
to your pom
<properties>
<h2.version>1.4.195</h2.version>
</properties>
> ignite won't start with spring-boot 1.5.11 - h2 property NESTED_JOINS doesn't
> exist
> -----------------------------------------------------------------------------------
>
> Key: IGNITE-8197
> URL: https://issues.apache.org/jira/browse/IGNITE-8197
> Project: Ignite
> Issue Type: Bug
> Reporter: Scott Feldstein
> Priority: Major
> Attachments: spring-boot-ignite.zip
>
>
> I just upgraded to spring-boot 1.5.11 and am seeing the error below. I think
> this is an issue with the version of h2 associated with spring boot 1.5.11.
> In 1.5.10 the h2 version was 1.4.196 and with 1.5.11 it is 1.4.197. The
> NESTED_JOINS property comes from
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing, i assume it
> was deprecated but not sure. When I lock in my h2 version to 1.4.196 by
> overriding the spring-dependencies parent everything works fine
> {code:java}
> Caused by: org.h2.jdbc.JdbcSQLException: Unsupported connection setting
> "NESTED_JOINS" [90113-197]
> at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.message.DbException.get(DbException.java:179)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.message.DbException.get(DbException.java:155)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.engine.ConnectionInfo.readSettingsFromURL(ConnectionInfo.java:268)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.engine.ConnectionInfo.<init>(ConnectionInfo.java:76)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:103)
> ~[h2-1.4.197.jar:1.4.197]
> at org.h2.Driver.connect(Driver.java:69) ~[h2-1.4.197.jar:1.4.197]
> at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_131]
> at java.sql.DriverManager.getConnection(DriverManager.java:270) ~[?:1.8.0_131]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:317)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.initialValue(IgniteH2Indexing.java:288)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:180) ~[?:1.8.0_131]
> at java.lang.ThreadLocal.get(ThreadLocal.java:170) ~[?:1.8.0_131]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:290)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$1.get(IgniteH2Indexing.java:288)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:514)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeStatement(IgniteH2Indexing.java:582)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.createSchema(IgniteH2Indexing.java:551)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.registerCache(IgniteH2Indexing.java:2667)
> ~[ignite-indexing-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.registerCache0(GridQueryProcessor.java:1594)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart0(GridQueryProcessor.java:800)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.onCacheStart(GridQueryProcessor.java:861)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCache(GridCacheProcessor.java:1158)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.prepareCacheStart(GridCacheProcessor.java:1900)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.GridCacheProcessor.startCachesOnLocalJoin(GridCacheProcessor.java:1764)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.initCachesOnLocalJoin(GridDhtPartitionsExchangeFuture.java:744)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.distributed.dht.preloader.GridDhtPartitionsExchangeFuture.init(GridDhtPartitionsExchangeFuture.java:626)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at
> org.apache.ignite.internal.processors.cache.GridCachePartitionExchangeManager$ExchangeWorker.body(GridCachePartitionExchangeManager.java:2337)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
> ~[ignite-core-2.4.0.jar:2.4.0]
> at java.lang.Thread.run(Thread.java:748) ~[?:1.8.0_131]{code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
