I am doing a data load from a csv file in playframework/scala using Anorm. I do 2 selects (validation), one insert and 1 update for each line. Somewhere in this process, and it is not consistently at the same place, an "SQLException: statement is not executing" error occurs. The last part of the stack is as follows:
Caused by: java.sql.SQLException: statement is not executing
at org.sqlite.Stmt.checkOpen(Stmt.java:52) ~[sqlite-jdbc-3.7.15-SNAPSHOT.jar:na]
at org.sqlite.PrepStmt.executeQuery(PrepStmt.java:89) ~[sqlite-jdbc-3.7.15-SNAPSHOT.jar:na]
at org.sqlite.MetaData.getGeneratedKeys(MetaData.java:1850) ~[sqlite-jdbc-3.7.15-SNAPSHOT.jar:na]
at org.sqlite.Stmt.getGeneratedKeys(Stmt.java:406) ~[sqlite-jdbc-3.7.15-SNAPSHOT.jar:na]
at com.jolbox.bonecp.StatementHandle.getGeneratedKeys(StatementHandle.java:711) ~[bonecp.jar:0.7.1.RELEASE]
at anorm.Sql$class.executeInsert(Anorm.scala:465) ~[anorm_2.10.jar:2.1-RC1]
I've tried with 3.7.2 and the latest snapshot with same result. Seems always to happen on the insert itself. (I've looked at checkOpen() in Stmt.java and it is checking the value of Pointer. So somehow when it gets to getGeneratedKeys() the value of Pointer is no longer set.)
Anyone with any ideas for helping me resolve it - would be most appreciated!!
TIA