This is nearly working now......The first time round the loop, it creates a table with a primary key column that that is set to 'auto increment'. Fine. Then it will insert the first row, I'm sure that the Statement.RETURN_GENERATED_KEYS
is being used wrongly, and as a result it won't insert the...