Trying to read Firefox databases

63 views
Skip to first unread message

Stefan Reich

unread,
Nov 26, 2018, 7:46:44 PM11/26/18
to sqljet
Hi,

is it possible that SqlJet is not compatible with all SQLite databases out there? In particular, Firefox bookmarks (places.sqlite).

I'm getting:

org.tmatesoft.sqljet.core.SqlJetException: NOTADB: error code is NOTADB
    at org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.lockBtree(SqlJetBtree.java:755)
    at org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.beginTrans(SqlJetBtree.java:923)
    at org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.lockWithRetry(SqlJetBtree.java:2310)
    at org.tmatesoft.sqljet.core.internal.btree.SqlJetBtreeCursor.<init>(SqlJetBtreeCursor.java:225)
    at org.tmatesoft.sqljet.core.internal.btree.SqlJetBtree.getCursor(SqlJetBtree.java:2292)
    at org.tmatesoft.sqljet.core.internal.table.SqlJetBtreeTable.pushState(SqlJetBtreeTable.java:131)
    at org.tmatesoft.sqljet.core.internal.table.SqlJetBtreeTable.init(SqlJetBtreeTable.java:108)
    at org.tmatesoft.sqljet.core.internal.table.SqlJetBtreeTable.<init>(SqlJetBtreeTable.java:89)
    at org.tmatesoft.sqljet.core.internal.table.SqlJetBtreeSchemaTable.<init>(SqlJetBtreeSchemaTable.java:41)
    at org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema.openSchemaTable(SqlJetSchema.java:158)
    at org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema.init(SqlJetSchema.java:164)
    at org.tmatesoft.sqljet.core.internal.schema.SqlJetSchema.<init>(SqlJetSchema.java:154)
    at org.tmatesoft.sqljet.core.table.engine.SqlJetEngine$2.runSynchronized(SqlJetEngine.java:282)
    at org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.runSynchronized(SqlJetEngine.java:217)
    at org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.readSchema(SqlJetEngine.java:276)
    at org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.refreshSchema(SqlJetEngine.java:310)
    at org.tmatesoft.sqljet.core.table.engine.SqlJetEngine.getSchemaInternal(SqlJetEngine.java:316)
    at org.tmatesoft.sqljet.core.table.SqlJetDb.getSchema(SqlJetDb.java:183)


Any ideas?

I need a platform-independent (so preferably Pure Java) way of reading Firefox's bookmarks.

Many greetings,
Stefan
BotCompany.de

Sean McBride

unread,
Apr 4, 2019, 4:36:48 AM4/4/19
to sqljet
I confirm; I get exactly the same error for Firefox's places.sqlite (browsing history).

This thread seems to suggest it's simply that SQLJet is too old and doesn't support modern sqlite databases.
Reply all
Reply to author
Forward
0 new messages