I'm sure it's not a caching problem, but...

[Dan Horne]

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

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Dan Horne]

Hi, any ideas?

On 12/07/2009, at 09:14 AM, Dan Horne wrote:

> 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
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@...

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...

[Dan Horne]

FYI, I have solved this. The read-only report pages connected with  
AutoCommit = 0. This is fine with Oracle, but did not work with MySQL.  
I'm not sure if its a transaction isolation issue, but against my  
better judgement, I have now set AutoCommit = 1.


On 14/07/2009, at 05:11 AM, Dan Horne wrote:

> Hi, any ideas?
>
> On 12/07/2009, at 09:14 AM, Dan Horne wrote:
>
>> 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
>>
>> _______________________________________________
>> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
>> IRC: irc.perl.org#dbix-class
>> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
>> Searchable Archive: http://www.grokbase.com/group/dbix-class@...
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@...

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@...