[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16178743#comment-16178743 ] Alex Volkov commented on IGNITE-6457: - Yes, that's work. Bug will be closed. > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Taras Ledkov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java:101) > at org.h2.command.Command.executeUpdate(Command.java:260) > at > org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:137) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:122) > at > org.apache.ignite.internal.process
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16176573#comment-16176573 ] Vladimir Ozerov commented on IGNITE-6457: - [~ustas], [~avolkov] The problem is that you create a cache without a single query entity. Currently we treat such caches as SQL-disabled, and do not create relevant schema. Please add the following to config and it should work: {code} java.lang.Integer java.lang.String {code} > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Vladimir Ozerov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16176546#comment-16176546 ] Vladimir Ozerov commented on IGNITE-6457: - [~ustas], please provide details. > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Ilya Suntsov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java:101) > at org.h2.command.Command.executeUpdate(Command.java:260) > at > org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:137) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:122) > at > org.apache.ignite.internal.pro
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16174614#comment-16174614 ] ASF GitHub Bot commented on IGNITE-6457: Github user asfgit closed the pull request at: https://github.com/apache/ignite/pull/2712 > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Taras Ledkov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java:101) > at org.h2.command.Command.executeUpdate(Command.java:260) > at > org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:137) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStat
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16174605#comment-16174605 ] Vladimir Ozerov commented on IGNITE-6457: - Test run: https://ci.ignite.apache.org/viewLog.html?buildId=843790&tab=queuedBuildOverviewTab > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Taras Ledkov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java:101) > at org.h2.command.Command.executeUpdate(Command.java:260) > at > org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:137) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcSta
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16174602#comment-16174602 ] Vladimir Ozerov commented on IGNITE-6457: - [~tledkov-gridgain], I did minor adjustements. Please review my commit. > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Taras Ledkov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.h2.jdbc.JdbcSQLException: Schema "test" not found; SQL > statement: > SET SCHEMA "test" [90079-195] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.engine.Database.getSchema(Database.java:1755) > at org.h2.command.dml.Set.update(Set.java:408) > at org.h2.command.CommandContainer.update(CommandContainer.java:101) > at org.h2.command.Command.executeUpdate(Command.java:260) > at > org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:137) > at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:122) >
[jira] [Commented] (IGNITE-6457) Incorrect exception when used schema name in lower case
[ https://issues.apache.org/jira/browse/IGNITE-6457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16174455#comment-16174455 ] ASF GitHub Bot commented on IGNITE-6457: GitHub user tledkov-gridgain opened a pull request: https://github.com/apache/ignite/pull/2712 IGNITE-6457: support schema case conversion at the JDBC thin driver c… …onnection URL. You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-6457 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/2712.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #2712 commit 6d2d901319d41bf03c38dbfa89443ed0c2ed117d Author: tledkov-gridgain Date: 2017-09-21T08:51:11Z IGNITE-6457: support schema case conversion at the JDBC thin driver connection URL. > Incorrect exception when used schema name in lower case > > > Key: IGNITE-6457 > URL: https://issues.apache.org/jira/browse/IGNITE-6457 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.1 > Environment: Cache configuration: > {noformat} > > > > class="org.apache.ignite.configuration.CacheConfiguration"> > > > > > > > > {noformat} >Reporter: Ilya Suntsov >Assignee: Taras Ledkov > Labels: usability > Fix For: 2.3 > > > Scenario: > 1. Start 1 node > 2. connect to node via sqlline (https://github.com/julianhyde/sqlline) > {noformat} ./sqlline -d org.apache.ignite.IgniteJdbcThinDriver --color=true > --verbose=true --showWarnings=true --showNestedErrs=true -u > jdbc:ignite:thin://127.0.0.1:10800/test{noformat} > 3. Create table: > {noformat}CREATE TABLE city1 (id LONG PRIMARY KEY, name VARCHAR);{noformat} > Result: > {noformat} > [16:35:27,506][SEVERE][client-connector-#40%null%][JdbcRequestHandler] Failed > to execute SQL query [reqId=0, req=JdbcQueryExecuteRequest [schemaName=test, > pageSize=1024, maxRows=0, sqlQry=CREATE TABLE city1 (id LONG PRIMARY KEY, > name VARCHAR), args=[], stmtType=ANY_STATEMENT_TYPE]] > class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed > to set schema for DB connection for thread [schema=test] > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForThread(IgniteH2Indexing.java:439) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.connectionForSchema(IgniteH2Indexing.java:356) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1287) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1918) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1914) > at > org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2396) > at > org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1922) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:286) > at > org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:149) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:141) > at > org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:40) > at > org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279) > at > org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109) > at > org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97) > at > org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110) > at > org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: