Are you not able to use the same db connection in both classes? something like FirstTablesClass->dbConnection = MyDBConnectionClass SecondTablesClass->dbConnection = MyDBConnectionClass
On 13 February 2011 23:04, jeff archer <jarch...@yahoo.com> wrote: > I thought this would be OK but now that I am seeing it fail I am having my > doubts. > > > I have created 2 db connections on the same thread, both on the same file. > i.e. > 2 calls to sqlite3_open16() (use exact same filename both times) have > created 2 > sqlite3 instances. I do this because I have 2 classes which each have > their own > set of tables in this single db file. I thought it would be OK because I > do not > intemix operations on the 2 connections. > > I do a transaction on connection 1 using BEGIN IMMEDIATE, some rows > updated, > COMMIT. > Then, when I attempt same sequence on connection 2, when I do first call to > step > to execute begin transaction and it never returns. > > Jeff Archer > Nanotronics Imaging > jsarc...@nanotronicsimaging.com > <330>819.4615 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users