No of visitors who read this post: 198
Category: MS SQL Server
Type: Question
No votes yet

Everytime I try to connect to SQLite3 db (from the Data Sources window) I get the below shown error message. I re-checked my db file and it has NO errors. I checked it from Firefox SQLite Manager. Guys, any idea as to why this comes up? Thanks in advance.

Error:

Connection Error
3 of 3 tables were loaded.
The following errors were encountered:

Table: SCHEMA MIGRATIONS
java.sql.SQLException: not yet implemented
at org.sqlite.MetaData.getImportedkeys(MetaData.java:503)

Table: SQLITE SEQUENCE
java.sql.SQLException: not yet implemented
at org.sqlite.MetaData.getImportedkeys(MetaData.java:503)

Table: USERS
java.sql.SQLException: not yet implemented
at org.sqlite.MetaData.getImportedkeys(MetaData.java:503)

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# (Solution Accepted)

From your post, it is very clear that your system does not support 64 bit version of that software. That might be the main reason for this error. To overcome this error, follow the instruction step by step:

-          If you are using 64 bit version get rid of it, as simple as that.

-          And also make sure that every DLL is 32 bit.

-          Have a unite test using Microsoft testing framework and the spring.Testing.Microsoft, extending the test from Abstract Dependency Injection Spring Context Tests.

Now this will work without any error, it injects the facades and everything will work perfectly.