2011/7/3 Simon Slavin <[email protected]>
>
> 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.
>
It is java code. prep is of type preparedStatement ("INSERT INTO
storeCitations (citation, name) VALUES (?, ?);") and I am trying to set the
value for citation. The 2005 times before it goes good, but here it goes
wrong. I also put it on a java list. Maybe they can help me.
--
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
