[jira] [Created] (IGNITE-14381) Failed to initialize DB connection- Unsupported connection setting "MULTI_THREADED"

["Devansh Arora (Jira)" <ji...@apache.org>]

Devansh Arora created IGNITE-14381:
--------------------------------------

             Summary: Failed to initialize DB connection- Unsupported connection setting "MULTI_THREADED" 
                 Key: IGNITE-14381
                 URL: https://issues.apache.org/jira/browse/IGNITE-14381
             Project: Ignite
          Issue Type: Bug
    Affects Versions: 2.10
            Reporter: Devansh Arora


Our Application with dependency to *ignite spring 2.10.0* and *h2 1.4.200*
application fails to start with error 

2021-03-23 07:56:47.506Z|proxy-agent|DIPUPTWIN201204|[main]|ERROR|||||||1|org.apache.ignite.internal.IgniteKernal:?|?|Exception during start processors, node will be stopped and close connections
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to initialize DB connection: jdbc:h2:mem:9feea9ed-f89e-4818-b9d7-638749a474d2;LOCK_MODE=3;MULTI_THREADED=1;DB_CLOSE_ON_EXIT=FALSE;DEFAULT_LOCK_TIMEOUT=10000;FUNCTIONS_IN_SCHEMA=true;OPTIMIZE_REUSE_RESULTS=0;QUERY_CACHE_SIZE=0;MAX_OPERATION_MEMORY=0;BATCH_JOINS=1;ROW_FACTORY="org.apache.ignite.internal.processors.query.h2.opt.H2PlainRowFactory";DEFAULT_TABLE_ENGINE=org.apache.ignite.internal.processors.query.h2.opt.GridH2DefaultTableEngine

Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "MULTI_THREADED" [90113-200]Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Unsupported connection setting "MULTI_THREADED" [90113-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:622) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429)


If we revert *h2* version to *1.4.197* it works. But this version has some security vulnerabilities associated to it.
[https://www.cvedetails.com/vulnerability-list/vendor_id-17893/product_id-45580/version_id-243447/H2database-H2-1.4.197.html]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)