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/[email protected]
_______________________________________________
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/[email protected]
_______________________________________________
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/[email protected]
