Python: Unresolved import error for sqlite3 in PyDev in Eclipse

Question

import sqlite3 generates:

Unused import: sqlite3
Unresolved import: sqlite3
sqlite3 Found at: DatabaseTests

import sqlite3

However, this works perfectly in the terminal when using the python command-line.

I am running on a Mac Mountain Lion, with the default installation of Python. I am using PyDev in Eclipse Indigo.

score 7 · Answer 1 · answered Jul 05 '14 at 21:22

7

This is a very old thread but I don't see the solution I found for this problem so I'll post it in hopes that somebody sees this and can then solve the problem:

you need to add 'sqlite3' (without the quotatios) in the 'forced builtins' tab in Window>Preferences>PyDev>Python Interpreter

answered Jul 05 '14 at 21:22

A R

500
2
7
20

1

This solves the problem not only for MacOs, but for othe O.S. too. – J.A.I.L. Mar 29 '16 at 07:57

score 3 · Answer 2 · answered Jun 18 '15 at 17:04

3

I fixed this by adding _sqlite3 (note the underscore) to the Forced Built-ins in Window>Preferences>PyDev>Interpreters>Python Interpreter.

answered Jun 18 '15 at 17:04

Stephen H Sentoff

511
4
5

This solved the problem on my eclipse 3.8.1 on Linux 14.04. – delicasso Jul 21 '16 at 18:21
Thanks, this fixed my problems. Working on an old CentOS 6.10 system with Python 3.5.6 and LiClipse 3.6.0.201704111135 – shellman Mar 26 '19 at 10:08

daedalus · Accepted Answer · 2012-05-02T06:46:38.033

1

I have the same development environment and suffered from the same issue. I have resolved it by

switching to the MacPorts Python,
by only using packages that I install from that project
and by setting the default Python interpreter on Eclipse-Pydev to be the MacPorts executable

This works perfectly for me, with the one hitch that I still sometimes get an Unresolved import warning, but if the package is installed, my script still runs.

edited May 02 '12 at 06:46

answered May 02 '12 at 05:32

daedalus

10,873
5
50
71

1

I did not want to use the MacPorts version, but your answer got me to install the Python.org version and point to that interperter. Lo and behold - it finally works. Thank you. – Erez A. Korn May 02 '12 at 05:53
+1 because you, in turn, are pointing me to do the same... :) – daedalus May 02 '12 at 06:07

score 0 · Answer 4 · answered May 02 '12 at 05:31

0

Looks like the project references do not have the site-package path added. Try adding the path to sqlite3 (/usr/lib/python2.7/sqlite3/ or the path installed to which you can get from python shell) to project references from Project -> Properties -> Pydev-PYTHOPATH -> External libraries.

answered May 02 '12 at 05:31

techiev2

298
1
8

Unfortunately, that did not help. To be sure, I also closed and re-opened Eclipse, but nothing :( – Erez A. Korn May 02 '12 at 05:43

score 0 · Answer 5 · answered May 20 '12 at 14:04

I had a similar problem with other imports (simplejson and matplotlib). I'm working on Ubuntu and the problems with the imports started after upgrading from Ubuntu 11.10 to 12.04 (which also upgraded the python version and the eclipse).

My steps for solving the problem were:

In the terminal, do 'import sys' then 'print sys.executable'. This gives the path to the current interpreter.
In Eclipse - Window->preferences->PyDev->interpreter-python. Remove the old path and add the path retrieved in stage 1.
In the problematic project go to Project->properties->PyDev-PYHTONPATH, the external libraries tab remove old paths and add the correct ones (on Ubuntu one can find it via the synaptic manager, e.g. for simplejson go to the synaptic manager, type simplejson in the search box, mark the right result right-click and choose properties from the menu then choose the 'installed files' tab to see the path for the installed files.

I hope someone will find it useful.

Python: Unresolved import error for sqlite3 in PyDev in Eclipse

5 Answers5

Linked