I am using: - sqlline-1.7.0-jar-with-dependencies.jar - sqlite-jdbc-3.27.2.jar
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 DESC ; java.lang.IllegalStateException: SQLite JDBC: inconsistent internal state at org.sqlite.core.CoreResultSet.checkCol(CoreResultSet.java:88) at org.sqlite.jdbc3.JDBC3ResultSet.getTableName(JDBC3ResultSet.java:926) at sqlline.Rows.isPrimaryKey(Rows.java:119) at sqlline.TableOutputFormat.getOutputString(TableOutputFormat.java:114) at sqlline.TableOutputFormat.getOutputString(TableOutputFormat.java:98) at sqlline.TableOutputFormat.print(TableOutputFormat.java:40) at sqlline.SqlLine.print(SqlLine.java:1626) at sqlline.Commands.execute(Commands.java:982) at sqlline.Commands.sql(Commands.java:906) at sqlline.SqlLine.dispatch(SqlLine.java:740) at sqlline.SqlLine.begin(SqlLine.java:557) at sqlline.SqlLine.start(SqlLine.java:270) at sqlline.SqlLine.main(SqlLine.java:201) 0: jdbc:sqlite:/maxmin> Does anybody else have the same problem? Are there any known work arounds or fixes? Any help appreciated. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users