$heap->{dbi_helper} = POE::Component::DBIAgent->new (
DSN => \@DSN,
Queries => {
"create_table" => "create table #test ( name varchar(30), value varchar(50) )",
"drop_table" => "drop table #test",
},
Count => 1,
Debug => 1,
);
####
$heap->{dbi_helper}->query( "create_table" => "$session_id" => "create_table_done");
$heap->{dbi_helper}->query( drop_table => $session_id => "drop_table_done");
####
POE::Component::DBIAgent received _start.
POE::Component::DBIAgent Started db helper pid 9355 wheel 2
QA:(#2) 1 pending: create_table => 2::create_table_done
QA:(#_) 2 pending: drop_table => 2::drop_table_done
QA:(#2) 1 pending: EOF => 2::create_table_done
QA:(#2) 1 pending: drop_table => 2::drop_table_done
- Create table #table done. -
DBD::Sybase::st execute failed: Server message number=3701 severity=11 state=1 line=1 server=CH_TST125_SQL text=Cannot drop the table '#test', because it doesn't exist in the system catalogs.:
^CPOE::Component::DBIAgent has stopped.