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/
