On 10 Mar 2007 07:40:23 -0800, jupiter <[EMAIL PROTECTED]> wrote: >On Mar 10, 8:16 pm, Michael Bentley <[EMAIL PROTECTED]> wrote: >> > Thanx for this pointer buddy! I have done my homework. Some Database >> > modules are not actively maintained some modules does not work with >> > Python 2.5. At this moment I am using Sqlite3 which is pretty fast but >> > it dosent allow me to use multi threading so which database module is >> > better in terms of multithreading >> >> Actually, I think sqlite3 just requires that each thread have its own >> connection and cursor. > >Exception in thread Thread-2: >Traceback (most recent call last): > File "D:\Python25\lib\threading.py", line 460, in __bootstrap > self.run() > File "url_part1.py", line 161, in run > dbacc(self.o, self.dbase).dataenter() > File "url_part1.py", line 64, in dataenter > self.c.execute('insert into '+self.odbase+' values >(?,?,?,?,?,?,?,?,?,?,?,?, >?)',self.odata) >InterfaceError: Error binding parameter 3 - probably unsupported type. > >this is the error I am getting................ >
Do you recognize that this has absolutely nothing to do with threading? If this is the reason you want to switch away from SQLite3, reconsider, because it's just a bug in your application code, and no matter what database or adapter you use, bugs in your application code will prevent your application from working properly. Jean-Paul -- http://mail.python.org/mailman/listinfo/python-list