ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-6046) Multiple SQL statements in one JDBC command do not work
Date Thu, 07 Sep 2017 16:37:00 GMT

    [ 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 <tledkov@gridgain.com>
Date:   2017-09-04T08:31:28Z

    IGNITE-6046: prototype of execution SQL query with multiple SQL statements

commit fc579cb0cb97c52adeb163ab2a719ccf4039e2c6
Author: devozerov <vozerov@gridgain.com>
Date:   2017-09-04T09:26:01Z

    Merge branch 'master' into ignite-6046

commit 23509bd2f63fc83ee4aa7556317b3f9d05ae370e
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-04T12:04:50Z

    Merge branch '_master' into ignite-6046

commit f43bb01dee136f4e59b6b17ccd6877555aaedab9
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-04T13:03:53Z

    IGNITE-6046: prototype of execution SQL query with multiple SQL statements

commit c9670c3ce27ad98574467e0e418be1b1271916fc
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-04T15:26:46Z

    IGNITE-6046: save the progress

commit 5cef75bcab5d8f31712b0ad5dcbe53ebca110dc4
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-05T06:53:32Z

    IGNITE-6046: save the progress

commit 4c49d4f8489be223627f03c3de1c5a4e45d92e38
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-05T06:54:16Z

    Merge branch '_master' into ignite-6046

commit 1c7173a8979f8ef876d522bb1b017287f139f9bc
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-05T08:53:41Z

    IGNITE-6046: save the progress

commit 23e7cd395618406e1159d52b1b7c30603bd83a48
Author: tledkov-gridgain <tledkov@gridgain.com>
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 <tledkov@gridgain.com>
Date:   2017-09-07T09:39:35Z

    IGNITE-6046: add jdbc test

commit 96e22b6cb72a09ef04b78693f2957322e48a1c56
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-07T09:44:34Z

    IGNITE-6046: minors

commit 00fc06c5f0ee9a4ee83fee1f734ac5aa6151915b
Author: devozerov <vozerov@gridgain.com>
Date:   2017-09-07T09:46:34Z

    Merge remote-tracking branch 'upstream/ignite-6046' into ignite-6046

commit 1d4de2f43c15527df21bf94e0b909d1fb34c3cea
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-07T11:47:35Z

    IGNITE-6046: refactoring

commit dbf9a97e1b286c56387ac65864aa2d1b7b829552
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-07T11:50:37Z

    Merge remote-tracking branch 'community/ignite-6046' into ignite-6046

commit df43b69b2c88fe7788cbe09865e62cf1ba4f3464
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-07T12:48:43Z

    IGNITE-6046: cosmetic

commit 0442727cea44e3287f7aee19f9322e0fda1a5c64
Author: tledkov-gridgain <tledkov@gridgain.com>
Date:   2017-09-07T14:00:08Z

    IGNITE-6046: saver progress

commit df05d6387c828347a07b4d8e272c170c16a19b27
Author: tledkov-gridgain <tledkov@gridgain.com>
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)

Mime
View raw message