[jira] [Updated] (IGNITE-24078) Jdbc. Confusing exception when executing DDL query using executeBatch method.

[Pavel Pereslegin (Jira)]

     [ 
https://issues.apache.org/jira/browse/IGNITE-24078?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pavel Pereslegin updated IGNITE-24078:
--------------------------------------
    Description: 
{code:java}
    try (Statement stmt = conn.createStatement()) {
        stmt.addBatch("CREATE TABLE xxxx (id INT PRIMARY KEY, name VARCHAR)");

        stmt.executeBatch();
    }
{code}

Result:
{noformat}
java.sql.BatchUpdateException: class java.lang.Boolean cannot be cast to class 
java.lang.Long (java.lang.Boolean and java.lang.Long are in module java.base of 
loader 'bootstrap')

        at 
org.apache.ignite.internal.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:605)
        at 
org.apache.ignite.jdbc.ItJdbcBatchSelfTest.testBatch(ItJdbcBatchSelfTest.java:128)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
{noformat}


  was:
{code:java}
    try (Statement stmt = conn.createStatement()) {
        stmt.addBatch("CREATE TABLE xxxx (id INT PRIMARY KEY, name VARCHAR)");

        stmt.executeBatch();
    }
{code}

Result:
{noformat}
java.sql.BatchUpdateException: class java.lang.Boolean cannot be cast to class 
java.lang.Long (java.lang.Boolean and java.lang.Long are in module java.base of 
loader 'bootstrap')

        at 
org.apache.ignite.internal.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:605)
        at 
org.apache.ignite.jdbc.ItJdbcBatchSelfTest.testBatch(ItJdbcBatchSelfTest.java:128)
        at java.base/java.lang.reflect.Method.invoke(Method.java:566)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
        at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
{noformat}

I expect there should be a SQL query type mismatch error (expected DML, but was 
DDL).



> Jdbc. Confusing exception when executing DDL query using executeBatch method.
> -----------------------------------------------------------------------------
>
>                 Key: IGNITE-24078
>                 URL: https://issues.apache.org/jira/browse/IGNITE-24078
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Pavel Pereslegin
>            Priority: Major
>              Labels: ignite-3
>
> {code:java}
>     try (Statement stmt = conn.createStatement()) {
>         stmt.addBatch("CREATE TABLE xxxx (id INT PRIMARY KEY, name VARCHAR)");
>         stmt.executeBatch();
>     }
> {code}
> Result:
> {noformat}
> java.sql.BatchUpdateException: class java.lang.Boolean cannot be cast to 
> class java.lang.Long (java.lang.Boolean and java.lang.Long are in module 
> java.base of loader 'bootstrap')
>       at 
> org.apache.ignite.internal.jdbc.JdbcStatement.executeBatch(JdbcStatement.java:605)
>       at 
> org.apache.ignite.jdbc.ItJdbcBatchSelfTest.testBatch(ItJdbcBatchSelfTest.java:128)
>       at java.base/java.lang.reflect.Method.invoke(Method.java:566)
>       at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
>       at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)