Hello! What is the version of Ignite on your cluster? Please make sure that driver version exactly matches cluster nodes' version.
Regards, -- Ilya Kasnacheev пн, 8 апр. 2019 г. в 16:17, shivakumar <[email protected]>: > 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/ >
