My question relates more to your earlier article I know.
I'm trying to understand why running a servlet that uses a SQLite JDBC driver and an 'insert' like this:
stmt.executeQuery("INSERT INTO name values('John', 'Dutcher', 0001)");
will only execute 'one' occurrence of such a statement...
If I repeat the above statement (10) times, only one insert happens (no abend though).
If I follow the one successful 'insert' with
a 'stmt.executeQuery(SELECT * from name)' it will not execute that either. If I re-compile the program...and comment the 1st 'stmt'...then the 2nd 'stmt' will execute
(but no subsequent 'stmt' will). Is this a Java language phenomenon ? or a flaw with the SQLiteJDBC interface driver ?