I can connect to the database, create a table, select from the table,
insert into the table, but the first time I try to read after an insert I
get the following exception:
0: jdbc:sqlite:/maxmin> SELECT * FROM maxmind_build_specs ORDER by pdate
java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state
> On 27 Apr 2019, at 10:47am, Frank Kemmer <[hidden email]> wrote:
> > I can connect to the database, create a table, select from the table,
> insert into the table, but the first time I try to read after an insert I
> get the following exception:
> >> Are you checking the result codes from all these operations ?
All these operations happen on one connection in one session. My first
operation is to list the tables and then I do the select.
When I insert the lines with the sqlite3 command line tool everything is
fine. But when I use sqlline with the sqlite JDBC Driver, I get this
exception with the first select statement.
I can even insert the lines with sqlline and select them in sqlite3 ... but
I can‘t do a select in sqlline. This results in the exception given above.
It reminds me on the problem that after the iteration over the resultSet,
the resultSet was closed and you no longer could access the metadata ...
but I am just guessing here.
This has nothing to do with the sqlite3 code itself but judging by the
comments in the jdbc binding, colsMeta being null implies that the
ResultSet has been closed. But I'm not sure where colsMeta is initialised,
it appears some other class is responsible for that.