Data Source — SQLite3 – Error

Asked By hyacinth evan 10 points N/A Posted on - 03/20/2012

When I am trying to connect to a SQLite3 db on the Data Sources I get the following error: 

I have checked that the db file has no errors via Firefox SQL Lite Manager. 

I really need to find a solution for this problem.

Please help me.

Thanks.

 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)

• Status: Open
• Question Views: 1122
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By Michelle Bang 55 points N/A #93481

Data Source — SQLite3 – Error

Seems that you are messing up with the key configuration in each table. Make sure that the keys are correctly placed and are being used on correct attributes of the table. Also check the dependencies between tables and import any key from one table to another as the foreign key. You can also use triggers to throw exceptions or to handle them if you don't know exactly what is causing the error. Also make sure that the sample data that you are using is the correct format data and is not mismatching its data type of the attribute. After that, close the SQL lite and run it again to see if the problem is still there. Then you have to contact some professional person

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 04/24/2012
• Question Category: Misc Databases