[Catalyst] DBIx::Class::ResultSet::all(): DBI Exception: DBD::DB2::db prepare_cached failed: [IBM][CLI Driver][DB2/AIX64] SQL0204N "DBUSERNAME.ACCOUNT_VIEW" is an undefined name.

David Schmidt davewood at gmx.at
Thu Apr 26 19:26:58 GMT 2012

$rs->all returns an array so you should call it in list context like this.

   accounts => [ $c->model('ORANGES::AccountView')->all ]

no idea if that changesyour error msg but it is a start.


On 26 April 2012 21:05, Kenneth S Mclane <ksmclane at us.ibm.com> wrote:
> I do not understand this error at all. It is tacking the DB user name onto
> the model name. Any hints why this is happening?
> This is my list sub:
> sub list :Local {
>         my ($self, $c) = @_;
>         $c->stash(accounts => $c->model('ORANGES::AccountView')->all);
>         $c->stash(template => 'accountview/list.tt2');
> }
> The model exists, if I remove the "->all" I get a different error but at
> least the stash gets populated with a bunch of info ABOUT the model, not the
> actual data. With it left in I never get anything but the error.
> Any help appreciated.
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/

More information about the Catalyst mailing list