[
https://issues.apache.org/jira/browse/IGNITE-6046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16157197#comment-16157197
]
ASF GitHub Bot commented on IGNITE-6046:
----------------------------------------
GitHub user tledkov-gridgain opened a pull request:
https://github.com/apache/ignite/pull/2618
IGNITE-6046 Multiple SQL statements in one JDBC command do not work
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gridgain/apache-ignite ignite-6046
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/ignite/pull/2618.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 #2618
----
commit f4c6603799c8752c6ee1ef13c697348fa36f9761
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-04T08:31:28Z
IGNITE-6046: prototype of execution SQL query with multiple SQL statements
commit fc579cb0cb97c52adeb163ab2a719ccf4039e2c6
Author: devozerov <[email protected]>
Date: 2017-09-04T09:26:01Z
Merge branch 'master' into ignite-6046
commit 23509bd2f63fc83ee4aa7556317b3f9d05ae370e
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-04T12:04:50Z
Merge branch '_master' into ignite-6046
commit f43bb01dee136f4e59b6b17ccd6877555aaedab9
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-04T13:03:53Z
IGNITE-6046: prototype of execution SQL query with multiple SQL statements
commit c9670c3ce27ad98574467e0e418be1b1271916fc
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-04T15:26:46Z
IGNITE-6046: save the progress
commit 5cef75bcab5d8f31712b0ad5dcbe53ebca110dc4
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-05T06:53:32Z
IGNITE-6046: save the progress
commit 4c49d4f8489be223627f03c3de1c5a4e45d92e38
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-05T06:54:16Z
Merge branch '_master' into ignite-6046
commit 1c7173a8979f8ef876d522bb1b017287f139f9bc
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-05T08:53:41Z
IGNITE-6046: save the progress
commit 23e7cd395618406e1159d52b1b7c30603bd83a48
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T09:39:06Z
Merge branch 'master' into ignite-6046
# Conflicts:
#
modules/core/src/main/java/org/apache/ignite/internal/jdbc/thin/JdbcThinStatement.java
commit 44295708f0d46f430680954c9bdb20ae4843d783
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T09:39:35Z
IGNITE-6046: add jdbc test
commit 96e22b6cb72a09ef04b78693f2957322e48a1c56
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T09:44:34Z
IGNITE-6046: minors
commit 00fc06c5f0ee9a4ee83fee1f734ac5aa6151915b
Author: devozerov <[email protected]>
Date: 2017-09-07T09:46:34Z
Merge remote-tracking branch 'upstream/ignite-6046' into ignite-6046
commit 1d4de2f43c15527df21bf94e0b909d1fb34c3cea
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T11:47:35Z
IGNITE-6046: refactoring
commit dbf9a97e1b286c56387ac65864aa2d1b7b829552
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T11:50:37Z
Merge remote-tracking branch 'community/ignite-6046' into ignite-6046
commit df43b69b2c88fe7788cbe09865e62cf1ba4f3464
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T12:48:43Z
IGNITE-6046: cosmetic
commit 0442727cea44e3287f7aee19f9322e0fda1a5c64
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T14:00:08Z
IGNITE-6046: saver progress
commit df05d6387c828347a07b4d8e272c170c16a19b27
Author: tledkov-gridgain <[email protected]>
Date: 2017-09-07T15:45:14Z
IGNITE-6046: fix query cache usage, add tests
----
> Multiple SQL statements in one JDBC command do not work
> -------------------------------------------------------
>
> Key: IGNITE-6046
> URL: https://issues.apache.org/jira/browse/IGNITE-6046
> Project: Ignite
> Issue Type: Task
> Components: jdbc, sql
> Reporter: Dmitriy Setrakyan
> Assignee: Taras Ledkov
> Labels: usability
>
> I have connected to Ignite from DBeaver using our thin JDBC driver. When I
> execute more than one statement from the SQL Editor, I get an error.
> For example, highlighting and executing these 2 statements gives an error:
> {code:sql}
> INSERT INTO city (id, name) VALUES (2, 'Forest Hill');
> INSERT INTO person (id, name, city_id) VALUES (2, 'John Doe', 3);
> {code}
> Here is the error I get:
> {code}
> [15:25:17,265][SEVERE][sql-connector-#150%null%][JdbcRequestHandler] Failed
> to execute SQL query [reqId=26, req=JdbcQueryExecuteRequest [schemaName=null,
> pageSize=1024, maxRows=0, sqlQry=INSERT INTO city (id, name) VALUES (2,
> 'Forest Hill');
> INSERT INTO person (id, name, city_id) VALUES (2, 'John Doe', 3), args=[]]]
> javax.cache.CacheException: class org.apache.ignite.IgniteCheckedException:
> Can not set org.h2.command.Prepared field
> org.h2.command.CommandContainer.prepared to org.h2.command.CommandList
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1863)
> at
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:188)
> at
> org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:122)
> at
> org.apache.ignite.internal.processors.odbc.SqlListenerNioListener.onMessage(SqlListenerNioListener.java:152)
> at
> org.apache.ignite.internal.processors.odbc.SqlListenerNioListener.onMessage(SqlListenerNioListener.java:44)
> 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: class org.apache.ignite.IgniteCheckedException: Can not set
> org.h2.command.Prepared field org.h2.command.CommandContainer.prepared to
> org.h2.command.CommandList
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2316)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFieldsNoCache(GridQueryProcessor.java:1860)
> ... 12 more
> Caused by: java.lang.IllegalArgumentException: Can not set
> org.h2.command.Prepared field org.h2.command.CommandContainer.prepared to
> org.h2.command.CommandList
> at
> sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:167)
> at
> sun.reflect.UnsafeFieldAccessorImpl.throwSetIllegalArgumentException(UnsafeFieldAccessorImpl.java:171)
> at
> sun.reflect.UnsafeFieldAccessorImpl.ensureObj(UnsafeFieldAccessorImpl.java:58)
> at
> sun.reflect.UnsafeObjectFieldAccessorImpl.get(UnsafeObjectFieldAccessorImpl.java:36)
> at java.lang.reflect.Field.get(Field.java:393)
> at
> org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser$Getter.get(GridSqlQueryParser.java:1600)
> at
> org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.prepared(GridSqlQueryParser.java:443)
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1298)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1856)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$6.applyx(GridQueryProcessor.java:1852)
> at
> org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2293)
> ... 13 more
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
