[Catalyst] connecting to a remote sqlite

rahed raherh at gmail.com
Fri Oct 12 10:50:01 GMT 2007


Hello,

I connect to a local sqlite db.
The data is being retrieved roughly like this:

my $rs = $c->model('MyAppDB::Table1')->search(
             		      undef,
			{
                             prefetch=>{
'rel1'=>{'rel2'=>['table4','table5'] } },
		     select=>['me,id','me.pd'],
	                 as=>[qw/id pd/],
		            },
		             		     );

while (my $row = $rs->next) {
....
}

That's ok.
But If I try to connect remotely through DBD::Proxy, the Catalyst
application emits the following error:

DBIx::Class::ResultSet::next(): DBI Exception: DBD::Proxy::db ping
failed: Unexpected EOF while waiting for server reply at
/usr/local/lib/perl5/site_perl/5.8.8/RPC/PlClient.pm line 110.

Without prefetch, there is no error. Is it possible (and which way) to
retrieve data from a remote db via proxy with Catalyst?

Thanks.

-- 
Radek



More information about the Catalyst mailing list