[Dbix-class] I'm sure it's not a caching problem, but...

Dan Horne dan.horne at redbone.co.nz
Sat Jul 11 21:14:14 GMT 2009


I have a CGI::Application web report that simply gives tabular output  
from a table. I'm using PersistentPerl for persisting my Perl, and I  
use MooseX::Singleton to store my schema object. Everything works fine  
with Oracle, but when I run the report against the same data in  
MySQL,  any changes subsequent to the previous report view aren't  
shown. I'm not explicitly using DBIx::Class caching, I've checked  
Oracle's v$session table to ensure that me DB connections are indeed  
persistent, so I'm just trying to figure out why MySQL isn't working  
as I expected. I'm using:

DBIx::Class: 0.08107
DBI: 1.609
DBD::Oracle: 1.23
DBD::mysql: 4.011

I use PersistentPerl and standard DBI with MySQL without problems, so  
any advice is appreciated

Thanks



More information about the DBIx-Class mailing list