On 3 Jul 2011, at 12:19am, Cecil Westerhof wrote:
> I am not sure if it is a SQLite problem, or a Java problem.
>
> While filling a table I get an error "Statement is not executing". It
> happens in the following code:
> System.out.printf("%d, %s, %s\n", line, citation, author);
> prep.setString(1, citation);
> System.out.print("After citation\n");
>
> I see the first output, but not the second. After this there is a -journal
> file. What could be happening here?
The -journal file just means that some program with a SQLite connection quit
without closing it. It's a result, rather than a cause, of the program
crashing. Do not delete/rename/move the -journal file, since when the
application is relaunched SQLite will use it to figure out if the database is
corrupt and needs fixing.
The error text "Statement is not executing" is not anything I've ever seen from
SQLite, so I suspect you're right and that your problem isn't anything to do
with SQLite. But I don't know what 'prep' is in your app.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
