JDBC requires a minimum number of records
I'm starting sqlite3 to use it from LibreOffice Base and I'm a bit stuck. Due to the restriction of permissions in my company to install new software, I have decided to connect it by JDBC that does not need to be installed, just use a .jar file or its unzipped folder.
After some configuration problems, I see the existing tables, I can create new tables and add records. So far everything seems to be going well.
The problem I have is when I access tables that have less than 42 records, I get the message "SQLite JDBC: internal inconsistent state". It is independent of the number of fields in the table, their sizes and the data loaded, it always gives the error with less than 42 regs. It is also independent of the program that created the database or table.
When using an administration program it seems that everything is correct, when I add the missing records up to 42, the problem disappears.
Any idea why this happens? Thank you.
I know this post is fairly dated, but I wanted to put this information out there:
It seems as though this issue with Base and SQLite JDBCs is a long standing one that has yet to see any form of resolution. Here is the bug report dating back to 2015. We've had some speculation as to the issue, but this is the first I've read about the problem going away based on the number of records. Perhaps you could add this info to the report.