Point taken, I wrote this e-mail last night when I was very tired and sick of trying to debug this. 8) Basically my script is using POE, the perl object environment, its an event driven state machine. In Detail "POE Parcels out execution time among one or more tasks, called sessions. Sessions multitask through cooperation (at least until Perl's threads become more mainstream). That is, each session returns execution to POE as quicky as possible so it can parcel out time to the next. The POE developers and contributors have written many modules and components to POE, such as POE::Components that implement non-blocking DBI calls, so you can do multiple inserts at once or an insert and an update or whatever. My program is trying to use POE::Component::EasyDBI to make 1 insert into an oracle database, and another insert into the SQLite2 database. Someone mentioned to me yesterday that more than one process can't access the SQLite2 database, that it doesn't support that kind of stuff.
-----Original Message----- From: Scott Leighton [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 8:35 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] problems using DBD::Sqlite2 On Thursday 07 October 2004 5:11 pm, Freeman, Michael wrote: > I put in a ticket, but I thought I'd also throw this question out to you > guys. I'm having some problems with a script that is using sqlite. I'll > cut and paste from the ticket: > > > > POE::Component::EasyDBI Got STDERR from child, which should never happen > ( <- errstr= ( 'no such table: trapdlog(1) at dbdimp.c line 412' ) [1 > items] at SubProcess.pm line 866 ) at > /usr/local/lib/perl5/site_perl/5.8.5/POE/Component/EasyDBI.pm line 678. > > I keep getting these messages when I run my perl script with > DBI->trace(1); > > I created my database and table and its very simple I'm confused, what do the examples have to do with the code above? In the examples you are using DBI, above you show an error from POE. They are two completely different interfaces. The examples run fine here, so I'd say you need to provide more information regarding the real script giving you a problem. Scott -- POPFile, the OpenSource EMail Classifier http://popfile.sourceforge.net/ Linux 2.6.5-7.108-default x86_64
