[
https://issues.apache.org/jira/browse/IGNITE-14381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Devansh Arora updated IGNITE-14381:
-----------------------------------
Description:
Our Application with dependency to *ignite spring 2.10.0* and *h2 1.4.200*
fails to start with error
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]
was:
Our Application with dependency to *ignite spring 2.10.0* and *h2 1.4.200*
fails to start with error
|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]
> 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
> Priority: Major
>
> Our Application with dependency to *ignite spring 2.10.0* and *h2 1.4.200*
> fails to start with error
>
> 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)
