SQLite Forum

JDBC requires a minimum number of records
Login
Hello everyone,

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.

Regards.