ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From shivakumar <shivakumar....@gmail.com>
Subject sql exception while batch inserting records
Date Mon, 08 Apr 2019 13:16:56 GMT
Hi all,
I'am getting this below exception while doing batch insert.

*WARNING: Exception during batch send on streamed connection close
java.sql.BatchUpdateException: Streaming mode supports only INSERT commands
without subqueries.
        at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection$StreamState.readResponses(JdbcThinConnection.java:1016)
        at java.lang.Thread.run(Thread.java:748)*

Scenario:
insert sql statement:
InsertSql = "INSERT INTO PUBLIC.MY_TABLE (Id,
time_stamp,second_time,last_time,period,name,                                   
iid,ptype,pversion) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?);"

 conn = DriverManager.getConnection(url, IGNITE_USER, IGNITE_PASS);
 conn.setAutoCommit(false);
 stmt = conn.createStatement();
 stmt.execute("SET STREAMING ON;");
 stmt.close();

 pStmt = conn.prepareStatement(table.getInsertSql());
            while (n < generate_rows) {
                table.createBatch(pStmt); 
                n++;
            }
            count = pStmt.executeBatch();
            conn.commit();
            pStmt.close();
igniteConn.close();


when last igniteConn.close(); got called it's throwing above sql exception
when i use* 2.7.0 ignite-core jar * and if i use *2.6.0 ignite-core jar*
i'am not getting this exception.

thanks with regards,
shiva







--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Mime
View raw message