in python I do from pysqlite2 import dbapi2 as sqlite which works well. When I do: >>> sqlite.sqlite_version '3.8.2' >>> sqlite.version '2.6.3' That's from the Linux Min 17 system. under kubuntu 11.04 it's 3.7.4 and 2.6.0 Under windows xp I get 3.8.5 and 2.6.3 Mark
On Saturday, October 04, 2014 10:23:11 AM Keith Medcalf wrote: > And python is using that same version of SQLite3.dll? That is, pysqlite2 or > sqlite3 or whatever version of the module you are using to interface to > sqlite3.dll returns '3.8.6' when you do something like: > > 2014-10-04 10:19:52 [D:\Temp] > > >python > > Python 2.7.8 (default, Jun 30 2014, 16:03:49) [MSC v.1500 32 bit (Intel)] on > win32 Type "help", "copyright", "credits" or "license" for more > information. > >>> import sqlite3 > >>> sqlite3.sqlite_version > > '3.8.7' > > >>> sqlite3.version > > '2.6.0' > > > sqlite3.version is the version number of pysqlite ... > > >-----Original Message----- > >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > >boun...@sqlite.org] On Behalf Of Mark Halegua > >Sent: Saturday, 4 October, 2014 10:11 > >To: General Discussion of SQLite Database > >Subject: Re: [sqlite] passing error messages to pysqlite > > > >and now the windows version, with sqlite 3.8.6 and a local database and > >local code in the > >same directory is doing the same, database locked. And yet, at the > >command line I could > >do an insert no problem. > > > >Mark > > > >On Saturday, October 04, 2014 12:00:59 PM Mark Halegua wrote: > >> Kieth, > >> > >> the database is not locked. It is a copy residing on the local hard > > > >drive > > > >> in the same directory as the python code and that version of sqlite3. > > > >I > > > >> was able to do an insert with the same sqlite3 in that directory as the > >> code, so this behavior is somehow wrong. > >> > >> The two systems I've tested this on are both Linux, one is kubuntu > > > >11.04 > > > >> with sqlite3 version 3.7.4 the otehr is Linux Mint 17, KDE, and sqlite3 > >> version 3.8.2 > >> > >> I'm about to test the code on a winxp vm with another local copy of the > >> database and code. > >> > >> Mark > >> > >> On Saturday, October 04, 2014 09:39:35 AM Keith Medcalf wrote: > >> > Well that would be because the database is locked. Is the version of > >> > SQLite being used by Python the same version as the command line tool > > > >is > > > >> > using? What is the OS -- is the database stored somewhere that the OS > >> > thinks you are not permitted to change files (feature of windows). > > > >Do > > > >> > you have another outstanding transaction that you have not commit or > >> > rollback? > >> > > >> > Note rollback's are not automatic either, so after you get an error > > > >trying > > > >> > to commit, the transaction is still open and will be commit/rollback > > > >again > > > >> > next time your try to commit or rollback. > >> > > >> > Is the database file in use by something else? Do you have a busy _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users