Since I don't have a test case, You'll have to dig deeper yourself.
David
On 2/22/07, Jake Peavy <[EMAIL PROTECTED]> wrote:
Forgot the list... sorry.
-jp
---------- Forwarded message ----------
From: Jake Peavy <[EMAIL PROTECTED]>
Date: Feb 21, 2007 6:09 PM
Subject: Re: EasyDBI -- No result, just 'Died' [Was: POE & DBI]
To: David Davis <[EMAIL PROTECTED]>
I'm not totally sure what you mean by "error message"...
With
sub POE::Component::EasyDBI::DEBUG () { 1 }
I get the following:
$_[ARG0]->{'error'} => 'Died'
and
POE::Component::EasyDBI got an read error 0 from Subprocess: ''
shutdown:
1
Does that help?
-jp
On 2/21/07, David Davis < [EMAIL PROTECTED]> wrote:
>
> Do you have the exact error message handy? None of my code has the word
> died, so I'm assuming its an error coming from dbi or dbd::odbc
>
> David
>
> On 2/21/07, Jake Peavy <[EMAIL PROTECTED]> wrote:
> >
> > On 2/21/07, David Davis <[EMAIL PROTECTED]> wrote:
> > >
> > > I'm the author of EasyDBI
> >
> >
> > <snip>
> >
> > Comments? Suggestions?
> > >
> > > David
> > >
> > > On 2/21/07, Matt Sickler <[EMAIL PROTECTED]> wrote:
> > > >
> > > > yes, DBI and PoCoEasyDBI work just fine on windows
> > > >
> > > > On 2/21/07, Bill Nash <[EMAIL PROTECTED]> wrote:
> > > > >
> > > > >
> > > > > Well...
> > > > >
> > > > > A better question would be: Do Perl and DBI work with windows?
> > > > >
> > > > > - billn
> > > > >
> > > > > On Wed, 21 Feb 2007, Mathieu Longtin wrote:
> > > > >
> > > > > > Do any of them work with windows?
> > > > > >
> > > > > > On 2/21/07, Matt Sickler <[EMAIL PROTECTED]> wrote:
> > > > > > >
> > > > > > > POE::Component::EasyDBI is what I use - quite simple and can
> > be
> > > > > powerful
> > > > > > >
> > > > > > > On 2/20/07, Kevin Scaldeferri < [EMAIL PROTECTED]>
wrote:
> > > > > > > >
> > > > > > > > Anyone want to strongly advocate for one of the four or so
> > > > > components
> > > > > > > > that comes up on a CPAN search for "POE DBI"?
> > >
> >
> > Ah, the perfect thread for me to jump in with an issue I had with
> > EasyDBI on
> > Win32, original message below to which I received no responses. Any
> > advice
> > would be much appreciated.
> >
> > ---------- Forwarded message ----------
> > From: Jake Peavy <[EMAIL PROTECTED]>
> > Date: Dec 6, 2006 7:09 PM
> > Subject: EasyDBI -- No result, just 'Died'
> > To: POE Mailing List < poe@perl.org>
> >
> > Hey yall,
> >
> > I'm having some problems with EasyDBI. I'm trying to do two
> > simultaneous
> > selects from two different databases. Both queries work fine via
> > standard
> > DBI, but when I run through EasyDBI and POE, the queries take the
right
> > amount of time (the query time is roughly 2 minutes), but they don't
> > return
> > results - all I get is the Error value of the hash in ARG0 reporting
the
> > query "Died".
> >
> > The queries make use of DBD::ODBC if that matters. My guess is maybe
> > that
> > EasyDBI sees something in the return value that it interprets as the
> > query
> > dying (maybe it's trying to compare the number of rows it got to the
> > number
> > the DB reported it was sending? just a WAG..), however, like I said,
> > the
> > queries are ok using a normal DBI connection.
> >
> > Here's the code I'm using though it won't be much help without the
back
> > end
> > DB. If anyone has any ideas on how to debug, I'm all ears. In the
> > meantime, I also tried SimpleDBI, stay tuned for those results... :)~
> >
> > TIA,
> > -jp
> >
> > #!/usr/bin/perl
> >
> > use strict;
> > use warnings;
> >
> > use POE;
> > use POE::Component::EasyDBI;
> >
> > use Data::Dumper;
> > $Data::Dumper::Maxdepth = 1;
> >
> > POE::Component::EasyDBI->spawn(
> > alias => 'db1',
> > dsn => 'dbi:ODBC:Sybase.db1',
> > username => 'user',
> > password => 'pass',
> > stopwatch => 1,
> > );
> >
> > POE::Component::EasyDBI->spawn(
> > alias => 'db2',
> > dsn => 'dbi:ODBC:Sybase.db2',
> > username => 'user',
> > password => 'pass',
> > stopwatch => 1,
> > );
> >
> > POE::Session->create(
> > inline_states => {
> >
> > _start => sub {
> > print '[' . localtime() . "] initiating db1 query\n";
> > $_[KERNEL]->post( 'db1',
> > arrayhash => {
> > sql => 'select * from table where foo = ?',
> > event => 'db1_result_handler',
> > placeholders => [ 'bar' ],
> > }
> > );
> >
> > print '[' . localtime() . "] initiating db2 query\n";
> > $_[KERNEL]->post( 'db2',
> > arrayhash => {
> > sql => 'select * from table where foo = ?',
> > event => 'db2_result_handler',
> > placeholders => [ 'bar' ],
> > }
> > );
> > },
> >
> > db1_result_handler => sub {
> > #my %success_hash = %{ $_[ARG0] };
> >
> > print '[' . localtime() . "] db1 query complete\n";
> > print Dumper $_[ARG0];
> > $_[KERNEL]->post( db1 => 'shutdown' );
> > },
> >
> > db2_result_handler => sub {
> > #my %success_hash = %{ $_[ARG0] };
> >
> > print '[' . localtime() . "] db2 query complete\n";
> > print Dumper $_[ARG0];
> > $_[KERNEL]->post( db2 => 'shutdown' );
> > },
> >
> > },
> > );
> >
> > $poe_kernel->run();
> >
> > __END__
>
>
